☰

MySQL 在连续查询后断开连接

tag-icon • tag-icon ubuntu mysql networking
MySQL 在连续查询后断开连接

有人知道为什么会发生这种情况吗？在我实施 mysql_multi 来运行 MySQL 服务的多个实例（一个在端口 3306 上，一个在端口 3307 上）后，这种情况开始发生。我在 Ubuntu 服务器上运行 MySQL。

事情的经过如下：

Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
Operation failed: Can't connect to MySQL server on '192.168.1.40' (10061)
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query
Fetching table list.
    63 items from dbname
OK
Fetching view list.
    0 items from dbname
OK
Fetching routine list.
    0 items from dbname
OK
Fetching trigger list.
Operation failed: Lost connection to MySQL server during query

答案1

我相信您已在 my.cnf 上将超时设置为低

相关内容