mysql - 删除 innodb_status.* 文件是否安全？

Question

查看 Ubuntu 13.10 服务器上的 /var/lib/mysql 文件夹，我看到很多名为 innodb_status.* 的文件。

运行ls -la这些文件似乎没有大小，但我不想删除它们，以防它正在做一些重要的事情。

有什么想法吗？

Answer 1

根据MySQL pages下面引用，我会说“是的，你可以(但首先停止 mysql 服务器)”。

InnoDB sends diagnostic output to stderr or to files rather than to stdout or fixed-size memory buffers, to avoid potential buffer overflows. As a side effect, the output of SHOW ENGINE INNODB STATUS is written to a status file in the MySQL data directory every fifteen seconds. The name of the file is innodb_status.pid, where pid is the server process ID. InnoDB removes the file for a normal shutdown. If abnormal shutdowns have occurred, instances of these status files may be present and must be removed manually. Before removing them, you might want to examine them to see whether they contain useful information about the cause of abnormal shutdowns. The innodb_status.pid file is created only if the configuration option innodb-status-file=1 is set.