VPS侦探论坛

 找回密码
 注册
查看: 2560|回复: 1

军哥mysql老挂,php进程数已经调低,但还是不行,帮忙看看什么原因?

[复制链接]
发表于 2018-9-30 11:43:45 | 显示全部楼层 |阅读模式

军哥mysql老挂,php进程数已经调低,也把程序优化了一下,但是效果还是不理想,麻烦军哥看看什么原因?下面是mysql的日志。
180930  8:11:36 [ERROR] Got error 134 when reading table './wx_zhaog/ims_core_cache'
180930  8:11:39 [ERROR] Got error 134 when reading table './wx_zhaog/ims_core_cache'
180930  8:11:40 [ERROR] Got error 134 when reading table './wx_zhaog/ims_core_cache'
180930  8:11:42 [ERROR] Got error 134 when reading table './wx_zhaog/ims_core_cache'
180930  8:12:45 [Note] Plugin 'FEDERATED' is disabled.
180930  8:12:45 InnoDB: The InnoDB memory heap is disabled
180930  8:12:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180930  8:12:45 InnoDB: Compressed tables use zlib 1.2.7
180930  8:12:45 InnoDB: Initializing buffer pool, size = 128.0M
180930  8:12:45 InnoDB: Completed initialization of buffer pool
180930  8:12:45 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
180930  8:12:45  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 5830760, file name ./mysql-bin.000225
180930  8:12:46  InnoDB: Waiting for the background threads to start
180930  8:12:47 InnoDB: 5.5.56 started; log sequence number 3908621716
180930  8:12:47 [Note] Recovering after a crash using mysql-bin
180930  8:12:47 [Note] Starting crash recovery...
180930  8:12:47 [Note] Crash recovery finished.
180930  8:12:47 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180930  8:12:47 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
180930  8:12:47 [Note] Server socket created on IP: '0.0.0.0'.
180930  8:12:47 [Note] Event Scheduler: Loaded 0 events
180930  8:12:47 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
180930 10:58:54 [Note] Plugin 'FEDERATED' is disabled.
180930 10:58:54 InnoDB: The InnoDB memory heap is disabled
180930 10:58:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180930 10:58:54 InnoDB: Compressed tables use zlib 1.2.7
180930 10:58:54 InnoDB: Initializing buffer pool, size = 128.0M
180930 10:58:55 InnoDB: Completed initialization of buffer pool
180930 10:58:55 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
180930 10:58:55  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 917272, file name ./mysql-bin.000226
180930 10:58:57  InnoDB: Waiting for the background threads to start
180930 10:58:58 InnoDB: 5.5.56 started; log sequence number 3908622076
180930 10:58:58 [Note] Recovering after a crash using mysql-bin
180930 10:58:58 [Note] Starting crash recovery...
180930 10:58:58 [Note] Crash recovery finished.
180930 10:58:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180930 10:58:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
180930 10:58:58 [Note] Server socket created on IP: '0.0.0.0'.
180930 10:58:58 [Note] Event Scheduler: Loaded 0 events
180930 10:58:58 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2018-9-30 17:44:48 | 显示全部楼层


[ERROR] Got error 134 when reading table './wx_zhaog/ims_core_cache'
这个的话是数据库表有损坏,修复一下就行
其他就是mysql异常退出,不清楚原因,有可能是系统资源不够被kill掉了
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-19 15:12 , Processed in 0.034463 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表