自动关闭 MySQL [英] Auto shutdown of MySQL

问题描述

今天早上发现mysql服务不可用.以前运行良好.

Today morning, I found that mysql service was not available. It was working fine previously.

请指导我这可能是什么原因.我重新安装 MySQL 服务器后，它又工作了.

Please guide me what could be the possible reason for this. After I reinstall MySQL server, it worked again.

在这里我找到了错误日志:

here i found the error log:

120409 16:48:46 InnoDB:等待后台线程启动120409 16:48:47 InnoDB:1.1.8 开始；日志序列号147932368753 120409 16:48:49 [注意] 事件调度程序:加载了 2 个事件120409 16:48:49 [注意] 事件调度程序:调度程序线程开始于id 1 120409 16:48:49 [注] C:\Program Files\MySQL\MySQL Server5.5\bin\mysqld:准备好连接.版本:'5.5.18-log' 套接字:'' 端口:3306 MySQL Community Server (GPL) 120413 3:20:08 [注意]C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld:正常关机

120409 16:48:46 InnoDB: Waiting for the background threads to start 120409 16:48:47 InnoDB: 1.1.8 started; log sequence number 147932368753 120409 16:48:49 [Note] Event Scheduler: Loaded 2 events 120409 16:48:49 [Note] Event Scheduler: scheduler thread started with id 1 120409 16:48:49 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections. Version: '5.5.18-log' socket: '' port: 3306 MySQL Community Server (GPL) 120413 3:20:08 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown

120413 3:20:10 [注意] 事件调度器:杀死调度器线程，线程 id 1 120413 3:20:10 [注意] 事件调度程序:等待调度线程回复 120413 3:20:10 【注意】事件调度:已停止 120413 3:20:10 [注意] 事件调度程序:清除队列.2事件 120413 3:20:12 InnoDB:开始关闭...

120413 3:20:10 [Note] Event Scheduler: Killing the scheduler thread, thread id 1 120413 3:20:10 [Note] Event Scheduler: Waiting for the scheduler thread to reply 120413 3:20:10 [Note] Event Scheduler: Stopped 120413 3:20:10 [Note] Event Scheduler: Purging the queue. 2 events 120413 3:20:12 InnoDB: Starting shutdown...

推荐答案

服务关闭的可能原因:

• Windows 更新(最有可能)
• 停电(不太可能，否则您不会在日志中看到正常关机")
• 有人关闭了机器

你提到你重新安装了你的 MySQL 服务器，这让我相信你原来的服务无法启动.MySQL 通常非常擅长记录为什么它无法启动，这是您没有为我们提供的重要信息.我提到 Windows 更新只是为了指出可能影响您的 MySQL 安装的外部力量，并就您的服务关闭的原因提供可能(但可能)的解释.

You mentioned that you re-installed your MySQL server, which leads me to believe that your original service could not start up. MySQL is usually very good about logging why it cannot start up, a piece of important information that you have not included for us. I only mentioned Windows update to point out an external force that may have affected your MySQL installation, and to also give a possible (but probable) explanation as to why your service went into shutdown.

这篇关于自动关闭 MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！