mysqldump 备份需要锁表

show engine innodb status\G------------TRANSACTIONS------------Trx id counter 117509Purge done for trx's n:o < 112086 undo n:o < 0 state: running but idleHistory list length 224LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 0, not startedMySQL thread id 2, OS thread handle 0x7f33aab99700, query id 13 localhost root initshow engine innodb status开始备份:------------TRANSACTIONS------------Trx id counter 119049Purge done for trx's n:o < 118074 undo n:o < 0 state: running but idleHistory list length 300LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 0, not startedMySQL thread id 2, OS thread handle 0x7fb128107700, query id 47 localhost root initshow engine innodb status---TRANSACTION 119048, ACTIVE 18 sec fetching rowsmysql tables in use 1, locked 11 lock struct(s), heap size 360, 0 row lock(s)MySQL thread id 4, OS thread handle 0x7fb1280c6700, query id 43 localhost mysql Sending dataSELECT /*!40001 SQL_NO_CACHE */ * FROM `t3`Trx read view will not see trx with id >= 119049, sees < 119049------------TRANSACTIONS------------Trx id counter 119051Purge done for trx's n:o < 118074 undo n:o < 0 state: running but idleHistory list length 300LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 0, not startedMySQL thread id 6, OS thread handle 0x7fb128085700, query id 128 localhost root initshow engine innodb status---TRANSACTION 119050, ACTIVE 43 secmysql tables in use 1, locked 11 lock struct(s), heap size 360, 0 row lock(s)MySQL thread id 5, OS thread handle 0x7fb1280c6700, query id 117 localhost mysql Sending dataSELECT /*!40001 SQL_NO_CACHE */ * FROM `t3`Trx read view will not see trx with id >= 119051, sees < 119049---TRANSACTION 119049, ACTIVE 107 secmysql tables in use 1, locked 1MySQL thread id 2, OS thread handle 0x7fb128107700, query id 118 localhost root Waiting for table level lockinsert into t3 values(25255,'a','a','20110101')Trx read view will not see trx with id >= 119050, sees < 119050mysql> insert into t3 values(9999999999,'a','a','20110101'); --HANG[mysql@master data]$ mysqldump test t3>t3.sql备份需要锁表