mysql无法执行source

问题背景：

1.相关系统变量当前设置

Variable_name Value
--------------------------- ----------
interactive_timeout 600
lock_wait_timeout 3600
net_read_timeout 30
net_write_timeout 60
wait_timeout 28800

Variable_name Value
------------------ ----------
max_allowed_packet 33554432   -- 32MB

2.article.sql文件内容，单条insert语句，文件大小337MB

执行

mysql> source /usr/local/src/article.sql

问题现象

2.连接状态

Id User Host db Command Time State Info
------ ------ ------------------ --------- ------- ------ -------- -----------------------
7 dba 192.168.42.1:53337 oper_test Query 0 starting show full processlist
8 dba 192.168.42.1:53338 (NULL) Sleep 2495 (NULL)
10 root localhost oper_test Sleep 513 (NULL)   -- sleep 513s

连接sleep 600s后

Id User Host db Command Time State Info
------ ------ ------------------ --------- ------- ------ -------- -----------------------
7 dba 192.168.42.1:53337 oper_test Query 0 starting SHOW FULL PROCESSLIST
8 dba 192.168.42.1:53338 (NULL) Sleep 3042 (NULL)

mysql无法执行source

原文：https://www.cnblogs.com/geek-ace/p/15033849.html