mysql select * into OUTFILE 不会锁表

最新推荐文章于 2022-01-08 10:52:16 发布

scan724

最新推荐文章于 2022-01-08 10:52:16 发布

阅读量1.6k

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/45333785

版权

Mysql 专栏收录该内容

90 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

在MySQL中，使用`SELECT * INTO OUTFILE`语句从表`test.t3`导出数据到`out.txt`文件时，不会对表进行锁定。查询`SHOW ENGINE INNODB STATUSG`显示当前事务状态，证实了在执行导出操作的同时，其他事务可以正常进行，表未被锁定。

摘要由CSDN通过智能技术生成

mysql>  select * into  OUTFILE  'out.txt' from test.t3; 不会锁表:

mysql> show engine innodb status\G  
*************************** 1. row ***************************

------------
TRANSACTIONS
------------
Trx id counter 123413
Purge done for trx's n:o < 122897 undo n:o < 0 state: running but idle
History list length 461
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 123412, not started
MySQL thread id 62, OS thread handle 0x7fe5a1337700, query id 1261 localhost root init
show engine innodb status
---TRANSACTION 123410, ACTIVE 108 sec
MySQL thread id 60, OS thread handle 0x7fe5a12f6700, query id 1243 localhost root cleaning up
Trx read view will not see trx with id >= 123411, sees < 123409
--------


mysql> show engin

了解本专栏