数据库突然链接不上了 帮忙看下日志
网站打开提示 Error establishing a database connectionFTP和ssh都能连上PHPmyadmin 登录不进去了 好几个月没登录过这个VPS了
确信自己没改过任何东西
军歌帮忙看下是不是被入侵了 改了配置
附件：
------------------------
日志里边有段这个代码很可疑 但是不明白意思
Version: '5.5.28-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
131211 15:11:16 IP address '60.171.215.146' could not be resolved: Name or service not known
131217 23:40:14 IP address '82.221.102.179' could not be resolved: Name or service not known
1312180:36:18 IP address '80.82.78.9' could not be resolved: Name or service not known
1312286:17:54 IP address '61.139.44.69' could not be resolved: Name or service not known
1312303:31:59 IP address '121.14.220.190' could not be resolved: Name or service not known
131231 20:42:40 IP address '60.222.229.66' has been resolved to the host name '66.229.222.60.adsl-pool.sx.cn', which resembles IPv4-address itself.
1401043:04:45 IP address '1.93.14.51' could not be resolved: Name or service not known
140108 14:03:12 IP address '221.11.108.10' could not be resolved: Name or service not known
1401250:22:16 IP address '1.93.1.83' could not be resolved: Name or service not known
140201 16:02:15 IP address '61.147.103.154' could not be resolved: Name or service not known
140215 23:49:31 IP address '117.34.72.148' could not be resolved: Name or service not known
140218 11:43:12 IP address '61.147.103.160' could not be resolved: Name or service not known
140219 19:09:17 IP address '220.181.158.174' could not be resolved: Name or service not known
1402238:03:19 IP address '118.26.230.35' could not be resolved: Name or service not known
1402263:52:58 IP address '222.187.129.29' could not be resolved: Name or service not known
1403069:46:39 IP address '112.186.1.37' could not be resolved: Name or service not known
140317 13:41:09 IP address '96.47.235.31' could not be resolved: Name or service not known
1403180:53:23 IP address '61.167.138.235' could not be resolved: Name or service not known
140320 12:36:27 IP address '113.105.247.54' could not be resolved: Name or service not known
140320 15:58:18 IP address '218.9.29.90' could not be resolved: Name or service not known
140321 19:17:08 IP address '96.47.235.5' could not be resolved: Name or service not known
140324 15:05:03 IP address '61.183.41.72' could not be resolved: Name or service not known
140326 22:14:18 IP address '119.147.114.23' could not be resolved: Name or service not known
140328 17:02:23 IP address '119.97.184.164' has been resolved to the host name '164.184.97.119.broad.wh.hb.dynamic.163data.com.cn', which resembles IPv4-address itself.
140404 12:26:56 /usr/local/mysql/bin/mysqld: Normal shutdown
前半部分日志里没错误信息
只是一些mysql对ip地址进行dns解析的日志记录
后半部分
1406054:50:23 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
1406054:50:23 Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
1406054:50:23 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_2.MYI'; try to repair it
1406054:50:23 Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
1406054:50:23 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_1.MYI'; try to repair it
1406054:50:23 Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605 14:50:25 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
140605 14:50:25 Got an error from unknown thread, /root/lnmp1.0-full/mysql-5.5.28/storage/myisam/mi_write.c:223
140605 15:13:30 /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_3b53_0.MYI'; try to repair it
140605 15:13:30 Got an error from unkn140607 16:09:05 mysqld_safe A mysqld process already exists
140607 16:15:49 /usr/local/mysql/bin/mysqld: Retry in 60 secs. Message reprinted in 600 secs
数据库有错误需要修复
/usr/local/mysql/bin/mysqlcheck -A -r -c -p 修复试试看
回复 2# 的帖子
谢谢军哥这么快速的回复在论坛找到帖子 说可能是日志满了 造成的
用探针看了下 可用空间为0了
于是删除了10几G的mysql-bin.000013 类似文件
网站现在能访问了
https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html
页:
[1]