爱编程的欧巴

让我们成长吧~
  博客园  :: 首页  :: 新随笔  :: 订阅 订阅  :: 管理

一大早来到公司,看到了一个噩梦,后台总是登录不上,登录就出错,还以为被黑客入侵了。经过1个小时的排错原因如下:

我的服务器是linux的,mysql的报错日志路径是/var/log/,经过查看日志发现错误信息为:

Can't start server: can't create PID file: No space left on device

120321 14:23:54 InnoDB: 1.1.8 started; log sequence number 1595695
120321 14:23:54 [ERROR] /usr/libexec/mysqld: Error writing file ‘/var/run/mysqld/mysqld.pid' (Errcode: 28)
120321 14:23:54 [ERROR] Can't start server: can't create PID file: No space left on device
120321 14:23:54 mysqld_safe Number of processes running now: 0
120321 14:23:54 mysqld_safe mysqld restarted
120321 14:23:54 [Note] Plugin ‘FEDERATED' is disabled.
120321 14:23:54 InnoDB: The InnoDB memory heap is disabled
120321 14:23:54 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120321 14:23:54 InnoDB: Compressed tables use zlib 1.2.3
120321 14:23:54 InnoDB: Using Linux native AIO
120321 14:23:54 InnoDB: Initializing buffer pool, size = 128.0M
120321 14:23:54 InnoDB: Completed initialization of buffer pool
120321 14:23:54 InnoDB: highest supported file format is Barracuda.
120321 14:23:55  InnoDB: Waiting for the background threads to start

这个错误。

提示磁盘空间不足

后用df -h 命令查看

我的是mysql的日志占用太多

我把mysql的日志删除掉

service mysqld start

重新启动mysql服务就好了

因为马上过年要回家了,虚惊一场,吓死宝宝了。

相关问题链接:http://www.jb51.net/article/66449.htm