【待反馈】Mysql经常卡顿，导致打开网页经常提示数据库错误

SQLSTATE[HY000] [2002] Connection refused
环境LAMP,一直很稳定，今天发现的问题，
刷新几次页面又好了，ssh登录 Navicat登录mysql也是需要几次才能连得上




求大佬给点思路，谢谢！

您好，服务器是什么配置呢？如果服务器配置内存过低，也是会导致MySQL异常停止的

谢花郎 发表于 2022-5-19 21:14
您好，服务器是什么配置呢？如果服务器配置内存过低，也是会导致MySQL异常停止的 ...

您好，服务器4U 4G 之前使用都是正常  状态如下

启动时间        2022/05/19 21:30:57        每秒查询        2
总连接次数        8        每秒事务        0
发送        119 B        File        OFF
接收        184 B        Position        OFF
活动/峰值连接数        6/1        若值过大,增加max_connections
线程缓存命中率        87.50%        若过低,增加thread_cache_size
索引命中率        0%        若过低,增加key_buffer_size
Innodb索引命中率        63.84%        若过低,增加innodb_buffer_pool_size
查询缓存命中率        OFF        若过低,增加query_cache_size
创建临时表到磁盘        0.00%        若过大,尝试增加tmp_table_size
已打开的表        11        table_open_cache配置值应大于等于此值
没有使用索引的量        0        若不为0,请检查数据表的索引是否合理
没有索引的JOIN量        0        若不为0,请检查数据表的索引是否合理
排序后的合并次数        0        若值过大,增加sort_buffer_size
锁表次数        0        若值过大,请考虑增加您的数据库性能

出现问题的时候将MySQL错误日志提供出来看下，只看错误日志。

谢花郎 发表于 2022-5-19 21:58
出现问题的时候将MySQL错误日志提供出来看下，只看错误日志。

2022-05-19 22:06:32 0 [ERROR] InnoDB: Tried to read 8192 bytes at offset 172032, but was only able to read 0
2022-05-19 22:06:32 0 [ERROR] InnoDB: Operating system error number 5 in a file operation.
2022-05-19 22:06:32 0 [ERROR] InnoDB: Error number 5 means 'Input/output error'
2022-05-19 22:06:32 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2022-05-19 22:06:32 0 [ERROR] InnoDB: File (unknown): 'read' returned OS error 205. Cannot continue operation
220519 22:06:32 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

宝塔用户_lsrene 发表于 2022-5-19 22:07
2022-05-19 22:06:32 0 [ERROR] InnoDB: Tried to read 8192 bytes at offset 172032, but was only able ...

您好！在错误日志中给出了解决方案https://mariadb.com/kb/en/reporting-bugs可以参考一下。