show engine innodb status\G
------------
TRANSACTIONS
------------
Trx id counter 117509
Purge done for trx's n:o < 112086 undo n:o < 0 state: running but idle
History list length 224
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7f33aab99700, query id 13 localhost root init
show engine innodb status
开始备份:
------------
TRANSACTIONS
------------
Trx id counter 119049
Purge done for trx's n:o < 118074 undo n:o < 0 state: running but idle
History list length 300
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 2, OS thread handle 0x7fb128107700, query id 47 localhost root init
show engine innodb status
---TRANSACTION 119048, ACTIVE 18 sec fetc
mysqldump 备份需要锁表
最新推荐文章于 2024-04-11 10:16:00 发布
在使用mysqldump进行数据库备份时,如果数据库中存在活跃的事务,可能会导致备份过程中需要等待表级锁,从而影响备份效率。通过查看InnoDB引擎状态,可以看到正在进行的事务及其状态,例如在示例中看到多个事务正在执行或等待锁。在高并发环境下,为确保数据一致性,备份可能需要暂停应用写操作,以避免事务冲突。
摘要由CSDN通过智能技术生成