首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >MySQL一直处于关闭状态

MySQL一直处于关闭状态
EN

Stack Overflow用户
提问于 2020-01-28 15:29:55
回答 1查看 1.5K关注 0票数 2

我有一个关于我的MySQL数据库的问题。

我有一个程序,每天都有轻微到重度的交通。它以前工作得很好,但在过去的几天里,它一直在关闭,服务器在几秒钟后重新启动它,或者更糟糕的是,我不得不手动重新启动它。我不明白的是,它是如何以及为什么一直关闭的。它在MySQL日志上显示以下注释:

代码语言:javascript
复制
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)

我试着在网上搜索,但不幸的是没有找到解决方案。我希望有人能帮我解决这个问题。如果我遗漏了一些可能有助于解决这个问题的信息,请让我知道。谢谢你,?

EN

回答 1

Stack Overflow用户

发布于 2020-01-28 18:10:25

请发送显示全局状态和显示全局变量值。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/59943969

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档