MYSQL运行1到2天会连接不上 好奇怪 面板显示启动着的 就是连接不上 必须重启服务器重新启动

A@本来

一下是错误代码:

200824 21:25:53 [Note] Plugin 'FEDERATED' is disabled.200824 21:25:53 InnoDB: The InnoDB memory heap is disabled200824 21:25:53 InnoDB: Mutexes and rw_locks use Windows interlocked functions200824 21:25:53 InnoDB: Compressed tables use zlib 1.2.3200824 21:25:54 InnoDB: Initializing buffer pool, size = 128.0M200824 21:25:54 InnoDB: Completed initialization of buffer pool200824 21:25:54 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!200824 21:25:54  InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...200824 21:25:54  InnoDB: Waiting for the background threads to start200824 21:25:55 InnoDB: 1.1.8 started; log sequence number 1595675200824 21:25:55 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306200824 21:25:55 [Note]   - '0.0.0.0' resolves to '0.0.0.0';200824 21:25:55 [Note] Server socket created on IP: '0.0.0.0'.200824 21:25:55 [Note] Event Scheduler: Loaded 0 events200824 21:25:55 [Note] D:\huanjing\COM\..\Extensions\MySQL5.5.29\\bin\mysqld.exe: ready for connections.Version: '5.5.29'  socket: ''  port: 3306  MySQL Community Server (GPL)200824 21:26:37 [Note] Plugin 'FEDERATED' is disabled.200824 21:26:37 InnoDB: The InnoDB memory heap is disabled200824 21:26:37 InnoDB: Mutexes and rw_locks use Windows interlocked functions200824 21:26:37 InnoDB: Compressed tables use zlib 1.2.3200824 21:26:37 InnoDB: Initializing buffer pool, size = 128.0M200824 21:26:37 InnoDB: Completed initialization of buffer pool200824 21:26:37 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!200824 21:26:37  InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...200824 21:26:38  InnoDB: Waiting for the background threads to start200824 21:26:39 InnoDB: 1.1.8 started; log sequence number 1595675200824 21:26:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306200824 21:26:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';200824 21:26:39 [Note] Server socket created on IP: '0.0.0.0'.200824 21:26:39 [Note] Event Scheduler: Loaded 0 events200824 21:26:39 [Note] D:\huanjing\COM\..\Extensions\MySQL5.5.29\\bin\mysqld.exe: ready for connections.Version: '5.5.29'  socket: ''  port: 3306  MySQL Community Server (GPL)200824 21:32:21 [Note] Plugin 'FEDERATED' is disabled.200824 21:32:21 InnoDB: The InnoDB memory heap is disabled200824 21:32:21 InnoDB: Mutexes and rw_locks use Windows interlocked functions200824 21:32:21 InnoDB: Compressed tables use zlib 1.2.3200824 21:32:21 InnoDB: Initializing buffer pool, size = 128.0M200824 21:32:21 InnoDB: Completed initialization of buffer pool200824 21:32:21 InnoDB: highest supported file format is Barracuda.InnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!200824 21:32:21  InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...200824 21:32:22  InnoDB: Waiting for the background threads to start200824 21:32:23 InnoDB: 1.1.8 started; log sequence number 1595675200824 21:32:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306200824 21:32:23 [Note]   - '0.0.0.0' resolves to '0.0.0.0';200824 21:32:23 [Note] Server socket created on IP: '0.0.0.0'.200824 21:32:25 [Note] Event Scheduler: Loaded 0 events200824 21:32:25 [Note] D:\huanjing\COM\..\Extensions\MySQL5.5.29\\bin\mysqld.exe: ready for connections.Version: '5.5.29'  socket: ''  port: 3306  MySQL Community Server (GPL)

问题比较着急?请联系QQ:760483
  • Peter·Python
  • Peter·Python    2020-08-25 10:03:371楼

    里面没有错误

    +添加回复

  • 回复

    真的好奇怪 运行一两天就连接不上了 必须重启服务器才可以

    A@本来  作者 · 2020-08-25 10:05:15
    回复

    这种会跟服务器系统有关系吗

    A@本来  作者 · 2020-08-25 10:05:38
    回复

    可能是连接数满了,建议及时释放不用的连接

    Peter·Python · 2020-08-25 10:13:06
    回复

    好的 我看下 非常感谢

    A@本来  作者 · 2020-08-25 10:17:38
    回复

    默认最大连接数 已经 是1000 了啊 我认为够了

    A@本来  作者 · 2020-08-25 10:19:35
    回复

    那你加官方群和别的用户讨论一下吧

    Peter·Python · 2020-08-25 10:20:24
    回复