我有一个关于我的MySQL数据库的问题。
我有一个程序,每天都有轻微到重度的交通。它以前工作得很好,但在过去的几天里,它一直在关闭,服务器在几秒钟后重新启动它,或者更糟糕的是,我不得不手动重新启动它。我不明白的是,它是如何以及为什么一直关闭的。它在MySQL日志上显示以下注释:
2020-01-28T06:02:00.157339Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-01-28T06:02:00.157379Z 0 [Note] Shutting down slave threads
2020-01-28T06:02:00.157385Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-01-28T06:02:00.157393Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-01-28T06:02:00.157442Z 0 [Note] Binlog end
2020-01-28T06:02:00.162900Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-01-28T06:02:00.162903Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-01-28T06:02:00.162906Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-01-28T06:02:00.162910Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-01-28T06:02:00.162913Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-01-28T06:02:00.162916Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-01-28T06:02:00.162920Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-01-28T06:02:00.162923Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-01-28T06:02:00.162927Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-01-28T06:02:00.162930Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-01-28T06:02:00.162933Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-01-28T06:02:00.162937Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-01-28T06:02:00.162940Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-01-28T06:02:00.162943Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-01-28T06:02:00.162947Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-01-28T06:02:00.162950Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-01-28T06:02:00.162954Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-01-28T06:02:00.162957Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-01-28T06:02:00.162960Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-01-28T06:02:00.162964Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-01-28T06:02:00.162967Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-01-28T06:02:00.162970Z 0 [Note] Shutting down plugin 'InnoDB'
2020-01-28T06:02:00.163030Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-01-28T06:02:00.163125Z 0 [Note] InnoDB: Starting shutdown...
2020-01-28T06:02:00.263407Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-01-28T06:02:00.264206Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200128 6:02:00
2020-01-28T06:02:01.380815Z 0 [Note] InnoDB: Shutdown completed; log sequence number 564620850
2020-01-28T06:02:01.382628Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-01-28T06:02:01.382643Z 0 [Note] Shutting down plugin 'MEMORY'
2020-01-28T06:02:01.382649Z 0 [Note] Shutting down plugin 'CSV'
2020-01-28T06:02:01.382654Z 0 [Note] Shutting down plugin 'sha256_password'
2020-01-28T06:02:01.382657Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-01-28T06:02:01.382833Z 0 [Note] Shutting down plugin 'binlog'
2020-01-28T06:02:01.383206Z 0 [Note] /usr/sbin/mysqld: Shutdown complete全局状态
https://drive.google.com/file/d/1S9kTDaMlNMenWMbGg
mByHQnG-eYRYap/视图
全局变量
https://drive.google.com/file/d/1Inqp8xv3NYmEJY9x8
QmasNCp4VZUCbF/view
添加信息
到目前为止的内存:
Memory as of now: 563M/15.7G
描述:
Ubuntu 18.04.1 LTS
MySQL服务器版本:
5.7.29-0ubuntu0.18.04.1 (Ubuntu)
我试着在网上搜索,但不幸的是没有找到解决方案。我希望有人能帮我解决这个问题。如果我遗漏了一些可能有助于解决这个问题的信息,请让我知道。谢谢你,?
发布于 2020-01-28 18:10:25
请发送显示全局状态和显示全局变量值。
https://stackoverflow.com/questions/59943969
复制相似问题