Приветствую всех. С недавнего момента на сайте стала падать база с ошибкой:
"Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
Спасает рестарт мускула, но через какое-то время снова падает.
Начал наблюдать за логами, но не вижу в них ничего, что может указать на какую-то конкретную проблему...
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
171023 17:55:46 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171023 17:55:46 [Note] Plugin 'FEDERATED' is disabled.
171023 17:55:46 InnoDB: The InnoDB memory heap is disabled
171023 17:55:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171023 17:55:46 InnoDB: Compressed tables use zlib 1.2.8
171023 17:55:46 InnoDB: Using Linux native AIO
171023 17:55:46 InnoDB: Initializing buffer pool, size = 128.0M
171023 17:57:13 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
171023 17:57:13 [Note] Plugin 'FEDERATED' is disabled.
171023 17:57:13 InnoDB: The InnoDB memory heap is disabled
171023 17:57:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
171023 17:57:13 InnoDB: Compressed tables use zlib 1.2.8
171023 17:57:13 InnoDB: Using Linux native AIO
171023 17:57:13 InnoDB: Initializing buffer pool, size = 128.0M
171023 17:57:13 InnoDB: Completed initialization of buffer pool
171023 17:57:13 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!
171023 17:57:13 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...
171023 17:57:14 InnoDB: Waiting for the background threads to start
171023 17:57:15 InnoDB: 5.5.58 started; log sequence number 6290876
171023 17:57:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171023 17:57:15 [Note] - '0.0.0.0' resolves to '0.0.0.0';
171023 17:57:15 [Note] Server socket created on IP: '0.0.0.0'.
171023 17:57:15 [Note] Event Scheduler: Loaded 0 events
171023 17:57:15 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.58-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
171023 17:57:16 [ERROR] /usr/sbin/mysqld: Table './bd/dle_users' is marked as crashed and should be repaired
171023 17:57:16 [Warning] Checking table: './bd/dle_users'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_admin_logs' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_admin_logs'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_be_read_topic' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_be_read_topic'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_be_topic' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_be_topic'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_login_log' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_login_log'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_post_extras' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_post_extras'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_spam_log' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_spam_log'
171023 17:57:17 [ERROR] /usr/sbin/mysqld: Table './bd/dle_static' is marked as crashed and should be repaired
171023 17:57:17 [Warning] Checking table: './bd/dle_static'
В конце логов пишется, мол таблицы сломаны, но это не так, они нормально работают после рестарта и в phpmyadmin нормально открываются... Прошу помощи, уже не знаю что и где копать...
