Неожиданно начала падать Mysql

[bzik]

Всем доброго дня!
И спасибо за советы, которые Вы дадите.
Проблема началась с 25 числа, неожиданно начала перезапускаться mysql каждые 60-80 минут, грешил на обновленный скрипт от одного разработчика, который как раз перед этим обновил, он сидит на кроне и прилично работает с бд, бд может получаться и 8 гб где-то.
Правки в my.cnf после команды mysqltuner и рекомендаций там, привели к тому, что сервер вообще перестал запускаться и потом еще пришлось проверять файловую систему.
Вчера ночью я отключил полностью запуск данного скрипта, чтобы понаблюдать за mysql, подозревая тот скрипт, но нет, падения продолжились и без его работы, также примерно каждые 60-80 минут.

Помогите разобраться

Настройки my.cnf

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
#********************************94.250.252.214**********************************#
skip-name-resolve=off

key_buffer_size         = 2M
thread_stack            = 512K
thread_cache_size	    = 32
table_cache             = 2048
thread_concurrency      = 12
net_buffer_length       = 32K
 
myisam-recover-options	= BACKUP
#query_cache_limit      = 6M
query_cache_limit       = 24M
query_cache_size        = 128M
 
myisam_sort_buffer_size = 32M
tmp_table_size          = 150M
max_heap_table_size     = 150M
 
read_buffer_size        = 1M
read_rnd_buffer_size    = 1M
 
sort_buffer_size        = 2M
#join_buffer_size        = 6M
join_buffer_size        = 6M
 
max_allowed_packet	    = 256M
max_sort_length         = 512
max_connections         = 70
max_connect_errors      = 10000
max_user_connections    = 30
 
 
#general_log_file               = /var/log/mysql/mysql.log
#general_log                    = 1
 
slow_query_log	            = /var/log/mysql/mysql-slow.log
long_query_time = 1
 
#server-id		                = 1
#log_bin			            = /var/log/mysql/mysql-bin.log
expire_logs_days	            = 10
max_binlog_size                 = 300M
innodb_buffer_pool_size         = 500M
innodb_additional_mem_pool_size = 32M
innodb_read_io_threads			= 8
innodb_write_io_threads			= 8
innodb_lock_wait_timeout        = 50
innodb_log_buffer_size          = 8M
innodb_flush_log_at_trx_commit  = 2
innodb_flush_method             = O_DIRECT
transaction-isolation           = READ-COMMITTED







[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Вот логи mysqld.log

Code: Select all

170927 23:06:25 [Warning] IP address '221.229.166.36' could not be resolved: Name or service not known
170927 23:09:42 [Note] /usr/libexec/mysqld: Normal shutdown

170927 23:09:42 [Note] Event Scheduler: Purging the queue. 0 events
170927 23:09:44 [Warning] /usr/libexec/mysqld: Forcing close of thread 106  user: 'prime_direct'

170927 23:09:44  InnoDB: Starting shutdown...
170927 23:09:46  InnoDB: Shutdown completed; log sequence number 49195748849
170927 23:09:46 [Note] /usr/libexec/mysqld: Shutdown complete

170927 23:09:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170927 23:13:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170927 23:13:01 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170927 23:13:01 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170927 23:13:01 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 2396 ...
170927 23:13:01 [Note] Plugin 'FEDERATED' is disabled.
170927 23:13:01 InnoDB: The InnoDB memory heap is disabled
170927 23:13:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170927 23:13:01 InnoDB: Compressed tables use zlib 1.2.3
170927 23:13:01 InnoDB: Using Linux native AIO
170927 23:13:01 InnoDB: Initializing buffer pool, size = 800.0M
170927 23:13:01 InnoDB: Completed initialization of buffer pool
170927 23:13:01 InnoDB: highest supported file format is Barracuda.
170927 23:13:01  InnoDB: Waiting for the background threads to start
170927 23:13:02 InnoDB: 5.5.45 started; log sequence number 49195748849
170927 23:13:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170927 23:13:02 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170927 23:13:02 [Note] Server socket created on IP: '0.0.0.0'.
170927 23:13:02 [Note] Event Scheduler: Loaded 0 events
170927 23:13:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170927 23:18:12 [Note] /usr/libexec/mysqld: Normal shutdown

170927 23:18:12 [Note] Event Scheduler: Purging the queue. 0 events
170927 23:18:12  InnoDB: Starting shutdown...
170927 23:18:14  InnoDB: Shutdown completed; log sequence number 49195974218
170927 23:18:14 [Note] /usr/libexec/mysqld: Shutdown complete

170927 23:18:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170927 23:18:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170927 23:18:15 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170927 23:18:15 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170927 23:18:15 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 4426 ...
170927 23:18:15 [Note] Plugin 'FEDERATED' is disabled.
170927 23:18:15 InnoDB: The InnoDB memory heap is disabled
170927 23:18:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170927 23:18:15 InnoDB: Compressed tables use zlib 1.2.3
170927 23:18:15 InnoDB: Using Linux native AIO
170927 23:18:15 InnoDB: Initializing buffer pool, size = 600.0M
170927 23:18:15 InnoDB: Completed initialization of buffer pool
170927 23:18:15 InnoDB: highest supported file format is Barracuda.
170927 23:18:15  InnoDB: Waiting for the background threads to start
170927 23:18:16 InnoDB: 5.5.45 started; log sequence number 49195974218
170927 23:18:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170927 23:18:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170927 23:18:16 [Note] Server socket created on IP: '0.0.0.0'.
170927 23:18:16 [Note] Event Scheduler: Loaded 0 events
170927 23:18:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  1:11:24 [Warning] IP address '221.229.166.104' could not be resolved: Name or service not known
170928  2:37:25 [Warning] IP address '123.59.195.45' could not be resolved: Name or service not known
170928 02:41:20 mysqld_safe Number of processes running now: 0
170928 02:41:20 mysqld_safe mysqld restarted
170928  2:41:20 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  2:41:20 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  2:41:20 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 3404 ...
170928  2:41:20 [Note] Plugin 'FEDERATED' is disabled.
170928  2:41:20 InnoDB: The InnoDB memory heap is disabled
170928  2:41:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  2:41:20 InnoDB: Compressed tables use zlib 1.2.3
170928  2:41:20 InnoDB: Using Linux native AIO
170928  2:41:20 InnoDB: Initializing buffer pool, size = 600.0M
170928  2:41:21 InnoDB: Completed initialization of buffer pool
170928  2:41:21 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!
170928  2:41:21  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...
170928  2:41:21  InnoDB: Waiting for the background threads to start
170928  2:41:22 InnoDB: 5.5.45 started; log sequence number 49201702715
170928  2:41:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  2:41:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  2:41:22 [Note] Server socket created on IP: '0.0.0.0'.
170928  2:41:22 [Note] Event Scheduler: Loaded 0 events
170928  2:41:22 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  2:42:21 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  2:42:21 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  2:42:22 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_contact_settings' is marked as crashed and should be repaired
170928  2:42:22 [Warning] Checking table:   './almamed_1/wa_contact_settings'
170928  2:42:24 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_product' is marked as crashed and should be repaired
170928  2:42:24 [Warning] Checking table:   './almamed_1/shop_product'
170928  2:42:34 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_currency' is marked as crashed and should be repaired
170928  2:42:34 [Warning] Checking table:   './almamed_1/shop_currency'
170928  2:43:08 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_phrase' is marked as crashed and should be repaired
170928  2:43:08 [Warning] Checking table:   './prime_direct/direct_direct_phrase'
170928  2:43:12 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_company' is marked as crashed and should be repaired
170928  2:43:12 [Warning] Checking table:   './prime_direct/direct_direct_company'
170928  2:43:35 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  2:43:35 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  2:43:36 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_product_skus' is marked as crashed and should be repaired
170928  2:43:36 [Warning] Checking table:   './almamed_1/shop_product_skus'
170928  2:44:13 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  2:44:13 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  2:46:54 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_currencyrates' is marked as crashed and should be repaired
170928  2:46:54 [Warning] Checking table:   './almamed_1/shop_currencyrates'
170928  2:46:56 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_banner' is marked as crashed and should be repaired
170928  2:46:56 [Warning] Checking table:   './prime_direct/direct_direct_banner'
170928  2:46:56 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_group' is marked as crashed and should be repaired
170928  2:46:56 [Warning] Checking table:   './prime_direct/direct_direct_group'
170928  2:46:56 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_retargeting' is marked as crashed and should be repaired
170928  2:46:56 [Warning] Checking table:   './prime_direct/direct_direct_retargeting'
170928  2:46:56 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_statistic' is marked as crashed and should be repaired
170928  2:46:56 [Warning] Checking table:   './prime_direct/direct_direct_statistic'
170928  2:47:01 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_statistic_price' is marked as crashed and should be repaired
170928  2:47:01 [Warning] Checking table:   './prime_direct/direct_direct_statistic_price'
170928  2:47:25 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_direct_statistic_price_temp' is marked as crashed and should be repaired
170928  2:47:25 [Warning] Checking table:   './prime_direct/direct_direct_statistic_price_temp'
170928  2:47:26 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_user' is marked as crashed and should be repaired
170928  2:47:26 [Warning] Checking table:   './prime_direct/direct_user'
170928  2:47:26 [ERROR] /usr/libexec/mysqld: Table './prime_direct/direct_user_param' is marked as crashed and should be repaired
170928  2:47:26 [Warning] Checking table:   './prime_direct/direct_user_param'
170928  2:50:44 [Note] /usr/libexec/mysqld: Normal shutdown

170928  2:50:44 [Note] Event Scheduler: Purging the queue. 0 events
170928  2:50:44  InnoDB: Starting shutdown...
170928  2:50:46  InnoDB: Shutdown completed; log sequence number 49201746281
170928  2:50:46 [Note] /usr/libexec/mysqld: Shutdown complete

170928 02:50:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170928 02:50:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170928  2:50:46 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  2:50:46 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  2:50:46 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 6307 ...
170928  2:50:46 [Note] Plugin 'FEDERATED' is disabled.
170928  2:50:46 InnoDB: The InnoDB memory heap is disabled
170928  2:50:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  2:50:46 InnoDB: Compressed tables use zlib 1.2.3
170928  2:50:46 InnoDB: Using Linux native AIO
170928  2:50:46 InnoDB: Initializing buffer pool, size = 500.0M
170928  2:50:46 InnoDB: Completed initialization of buffer pool
170928  2:50:46 InnoDB: highest supported file format is Barracuda.
170928  2:50:47  InnoDB: Waiting for the background threads to start
170928  2:50:48 InnoDB: 5.5.45 started; log sequence number 49201746281
170928  2:50:48 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  2:50:48 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  2:50:48 [Note] Server socket created on IP: '0.0.0.0'.
170928  2:50:48 [Note] Event Scheduler: Loaded 0 events
170928  2:50:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  2:53:08 [Note] /usr/libexec/mysqld: Normal shutdown

170928  2:53:08 [Note] Event Scheduler: Purging the queue. 0 events
170928  2:53:08  InnoDB: Starting shutdown...
170928  2:53:10  InnoDB: Shutdown completed; log sequence number 49201746291
170928  2:53:10 [Note] /usr/libexec/mysqld: Shutdown complete

170928 02:53:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170928 02:53:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170928  2:53:11 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  2:53:11 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  2:53:11 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 7057 ...
170928  2:53:11 [Note] Plugin 'FEDERATED' is disabled.
170928  2:53:11 InnoDB: The InnoDB memory heap is disabled
170928  2:53:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  2:53:11 InnoDB: Compressed tables use zlib 1.2.3
170928  2:53:11 InnoDB: Using Linux native AIO
170928  2:53:11 InnoDB: Initializing buffer pool, size = 500.0M
170928  2:53:11 InnoDB: Completed initialization of buffer pool
170928  2:53:11 InnoDB: highest supported file format is Barracuda.
170928  2:53:11  InnoDB: Waiting for the background threads to start
170928  2:53:12 InnoDB: 5.5.45 started; log sequence number 49201746291
170928  2:53:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  2:53:12 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  2:53:12 [Note] Server socket created on IP: '0.0.0.0'.
170928  2:53:12 [Note] Event Scheduler: Loaded 0 events
170928  2:53:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  2:58:15  InnoDB: ERROR: the age of the last checkpoint is 9436642,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
170928  3:05:05 [Note] /usr/libexec/mysqld: Normal shutdown

170928  3:05:05 [Note] Event Scheduler: Purging the queue. 0 events
170928  3:05:07  InnoDB: Starting shutdown...
170928  3:05:07  InnoDB: Waiting for 23 pages to be flushed
170928  3:05:08  InnoDB: Shutdown completed; log sequence number 49577216275
170928  3:05:08 [Note] /usr/libexec/mysqld: Shutdown complete

170928 03:05:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170928 03:05:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170928  3:05:09 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  3:05:09 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  3:05:09 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 9046 ...
170928  3:05:09 [Note] Plugin 'FEDERATED' is disabled.
170928  3:05:09 InnoDB: The InnoDB memory heap is disabled
170928  3:05:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  3:05:09 InnoDB: Compressed tables use zlib 1.2.3
170928  3:05:09 InnoDB: Using Linux native AIO
170928  3:05:09 InnoDB: Initializing buffer pool, size = 500.0M
170928  3:05:09 InnoDB: Completed initialization of buffer pool
170928  3:05:09 InnoDB: highest supported file format is Barracuda.
170928  3:05:09  InnoDB: Waiting for the background threads to start
170928  3:05:10 InnoDB: 5.5.45 started; log sequence number 49577216275
170928  3:05:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  3:05:10 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  3:05:10 [Note] Server socket created on IP: '0.0.0.0'.
170928  3:05:10 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  3:05:10 [Note] Event Scheduler: Loaded 0 events
170928  3:05:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  3:12:09 [Note] /usr/libexec/mysqld: Normal shutdown

170928  3:12:09 [Note] Event Scheduler: Purging the queue. 0 events
170928  3:12:09  InnoDB: Starting shutdown...
170928  3:12:10  InnoDB: Shutdown completed; log sequence number 49577246391
170928  3:12:10 [Note] /usr/libexec/mysqld: Shutdown complete

170928 03:12:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170928 03:12:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170928  3:12:11 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  3:12:11 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  3:12:11 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 10543 ...
170928  3:12:11 [Note] Plugin 'FEDERATED' is disabled.
170928  3:12:11 InnoDB: The InnoDB memory heap is disabled
170928  3:12:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  3:12:11 InnoDB: Compressed tables use zlib 1.2.3
170928  3:12:11 InnoDB: Using Linux native AIO
170928  3:12:11 InnoDB: Initializing buffer pool, size = 500.0M
170928  3:12:11 InnoDB: Completed initialization of buffer pool
170928  3:12:11 InnoDB: highest supported file format is Barracuda.
170928  3:12:12  InnoDB: Waiting for the background threads to start
170928  3:12:13 InnoDB: 5.5.45 started; log sequence number 49577246391
170928  3:12:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  3:12:13 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  3:12:13 [Note] Server socket created on IP: '0.0.0.0'.
170928  3:12:13 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  3:12:13 [Note] Event Scheduler: Loaded 0 events
170928  3:12:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  3:16:49 [Note] /usr/libexec/mysqld: Normal shutdown

170928  3:16:49 [Note] Event Scheduler: Purging the queue. 0 events
170928  3:16:49  InnoDB: Starting shutdown...
170928  3:16:51  InnoDB: Shutdown completed; log sequence number 49577465505
170928  3:16:51 [Note] /usr/libexec/mysqld: Shutdown complete

170928 03:16:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170928 03:16:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170928  3:16:52 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  3:16:52 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  3:16:52 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 12688 ...
170928  3:16:52 [Note] Plugin 'FEDERATED' is disabled.
170928  3:16:52 InnoDB: The InnoDB memory heap is disabled
170928  3:16:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  3:16:52 InnoDB: Compressed tables use zlib 1.2.3
170928  3:16:52 InnoDB: Using Linux native AIO
170928  3:16:52 InnoDB: Initializing buffer pool, size = 500.0M
170928  3:16:52 InnoDB: Completed initialization of buffer pool
170928  3:16:52 InnoDB: highest supported file format is Barracuda.
170928  3:16:52  InnoDB: Waiting for the background threads to start
170928  3:16:53 InnoDB: 5.5.45 started; log sequence number 49577465505
170928  3:16:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  3:16:53 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  3:16:53 [Note] Server socket created on IP: '0.0.0.0'.
170928  3:16:53 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  3:16:53 [Note] Event Scheduler: Loaded 0 events
170928  3:16:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928 05:36:38 mysqld_safe Number of processes running now: 0
170928 05:36:38 mysqld_safe mysqld restarted
170928  5:36:38 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  5:36:38 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  5:36:38 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 25076 ...
170928  5:36:38 [Note] Plugin 'FEDERATED' is disabled.
170928  5:36:38 InnoDB: The InnoDB memory heap is disabled
170928  5:36:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  5:36:38 InnoDB: Compressed tables use zlib 1.2.3
170928  5:36:38 InnoDB: Using Linux native AIO
170928  5:36:38 InnoDB: Initializing buffer pool, size = 500.0M
170928  5:36:38 InnoDB: Completed initialization of buffer pool
170928  5:36:38 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49581755541
170928  5:36:38  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: Doing recovery: scanned up to log sequence number 49581755761
170928  5:36:41  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
170928  5:36:41  InnoDB: Waiting for the background threads to start
170928  5:36:42 InnoDB: 5.5.45 started; log sequence number 49581755761
170928  5:36:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  5:36:42 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  5:36:42 [Note] Server socket created on IP: '0.0.0.0'.
170928  5:36:43 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  5:36:43 [Note] Event Scheduler: Loaded 0 events
170928  5:36:43 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  5:36:43 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  5:36:43 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  5:36:53 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  5:36:53 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  5:37:18 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  5:37:18 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  5:43:30 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cartsreport_plugin_cart' is marked as crashed and should be repaired
170928  5:43:30 [Warning] Checking table:   './almamed_1/shop_cartsreport_plugin_cart'
170928  5:54:42 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_contact_settings' is marked as crashed and should be repaired
170928  5:54:42 [Warning] Checking table:   './almamed_1/wa_contact_settings'
170928 06:46:37 mysqld_safe Number of processes running now: 0
170928 06:46:37 mysqld_safe mysqld restarted
170928  6:46:37 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  6:46:37 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  6:46:37 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 30341 ...
170928  6:46:37 [Note] Plugin 'FEDERATED' is disabled.
170928  6:46:37 InnoDB: The InnoDB memory heap is disabled
170928  6:46:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  6:46:37 InnoDB: Compressed tables use zlib 1.2.3
170928  6:46:37 InnoDB: Using Linux native AIO
170928  6:46:37 InnoDB: Initializing buffer pool, size = 500.0M
170928  6:46:37 InnoDB: Completed initialization of buffer pool
170928  6:46:37 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!
170928  6:46:37  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...
170928  6:46:38  InnoDB: Waiting for the background threads to start
170928  6:46:39 InnoDB: 5.5.45 started; log sequence number 49583000225
170928  6:46:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  6:46:39 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  6:46:39 [Note] Server socket created on IP: '0.0.0.0'.
170928  6:46:39 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  6:46:40 [Note] Event Scheduler: Loaded 0 events
170928  6:46:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  6:46:40 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  6:46:40 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  6:46:40 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  6:46:40 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  6:47:19 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  6:47:19 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  7:04:50 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cartsreport_plugin_cart' is marked as crashed and should be repaired
170928  7:04:50 [Warning] Checking table:   './almamed_1/shop_cartsreport_plugin_cart'
170928 07:52:41 mysqld_safe Number of processes running now: 0
170928 07:52:41 mysqld_safe mysqld restarted
170928  7:52:42 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  7:52:42 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  7:52:42 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 5677 ...
170928  7:52:43 [Note] Plugin 'FEDERATED' is disabled.
170928  7:52:43 InnoDB: The InnoDB memory heap is disabled
170928  7:52:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  7:52:43 InnoDB: Compressed tables use zlib 1.2.3
170928  7:52:43 InnoDB: Using Linux native AIO
170928  7:52:44 InnoDB: Initializing buffer pool, size = 500.0M
170928  7:52:44 InnoDB: Completed initialization of buffer pool
170928  7:52:45 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49584386349
170928  7:52:46  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: Doing recovery: scanned up to log sequence number 49584567120
170928  7:52:53  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
170928  7:52:54  InnoDB: Waiting for the background threads to start
170928  7:52:55 InnoDB: 5.5.45 started; log sequence number 49584567120
170928  7:52:55 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  7:52:55 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  7:52:55 [Note] Server socket created on IP: '0.0.0.0'.
170928  7:52:55 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  7:52:55 [Note] Event Scheduler: Loaded 0 events
170928  7:52:55 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  7:52:57 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  7:52:57 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  7:52:59 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  7:52:59 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  7:53:03 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  7:53:03 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  7:53:07 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cart_items' is marked as crashed and should be repaired
170928  7:53:07 [Warning] Checking table:   './almamed_1/shop_cart_items'
170928  7:53:24 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cartsreport_plugin_cart' is marked as crashed and should be repaired
170928  7:53:24 [Warning] Checking table:   './almamed_1/shop_cartsreport_plugin_cart'
170928  7:53:27 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_checkout_flow' is marked as crashed and should be repaired
170928  7:53:27 [Warning] Checking table:   './almamed_1/shop_checkout_flow'
170928  8:00:04 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_error301' is marked as crashed and should be repaired
170928  8:00:04 [Warning] Checking table:   './almamed_1/shop_error301'
170928  8:00:07 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_contact_settings' is marked as crashed and should be repaired
170928  8:00:07 [Warning] Checking table:   './almamed_1/wa_contact_settings'
170928 08:27:40 mysqld_safe Number of processes running now: 0
170928 08:27:40 mysqld_safe mysqld restarted
170928  8:27:41 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  8:27:41 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  8:27:41 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 12300 ...
170928  8:27:41 [Note] Plugin 'FEDERATED' is disabled.
170928  8:27:42 InnoDB: The InnoDB memory heap is disabled
170928  8:27:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  8:27:42 InnoDB: Compressed tables use zlib 1.2.3
170928  8:27:42 InnoDB: Using Linux native AIO
170928  8:27:42 InnoDB: Initializing buffer pool, size = 500.0M
170928  8:27:45 InnoDB: Completed initialization of buffer pool
170928  8:27: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!
170928  8:27:46  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...
170928  8:27:52  InnoDB: Waiting for the background threads to start
170928  8:27:53 InnoDB: 5.5.45 started; log sequence number 49584747042
170928  8:27:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  8:27:53 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  8:27:53 [Note] Server socket created on IP: '0.0.0.0'.
170928  8:27:53 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  8:27:53 [Note] Event Scheduler: Loaded 0 events
170928  8:27:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  8:27:53 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  8:27:53 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  8:27:54 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cart_items' is marked as crashed and should be repaired
170928  8:27:54 [Warning] Checking table:   './almamed_1/shop_cart_items'
170928  8:29:31 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  8:29:31 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  8:30:04 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  8:30:04 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  9:15:58 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cartsreport_plugin_cart' is marked as crashed and should be repaired
170928  9:15:58 [Warning] Checking table:   './almamed_1/shop_cartsreport_plugin_cart'
170928  9:26:55 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_checkout_flow' is marked as crashed and should be repaired
170928  9:26:55 [Warning] Checking table:   './almamed_1/shop_checkout_flow'
170928 09:36:49 mysqld_safe Number of processes running now: 0
170928 09:36:49 mysqld_safe mysqld restarted
170928  9:36:51 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
170928  9:36:51 [Warning] option 'slow_query_log': boolean value '/var/log/mysql/mysql-slow.log' wasn't recognized. Set to OFF.
170928  9:36:51 [Note] /usr/libexec/mysqld (mysqld 5.5.45) starting as process 22783 ...
170928  9:36:52 [Note] Plugin 'FEDERATED' is disabled.
170928  9:36:52 InnoDB: The InnoDB memory heap is disabled
170928  9:36:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170928  9:36:52 InnoDB: Compressed tables use zlib 1.2.3
170928  9:36:52 InnoDB: Using Linux native AIO
170928  9:36:52 InnoDB: Initializing buffer pool, size = 500.0M
170928  9:36:52 InnoDB: Completed initialization of buffer pool
170928  9:36:52 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 49587202309
170928  9:36:52  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: Doing recovery: scanned up to log sequence number 49587202554
170928  9:36:55  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 
InnoDB: Apply batch completed
170928  9:36:57  InnoDB: Waiting for the background threads to start
170928  9:36:58 InnoDB: 5.5.45 started; log sequence number 49587202554
170928  9:36:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170928  9:36:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170928  9:36:58 [Note] Server socket created on IP: '0.0.0.0'.
170928  9:36:58 [Warning] 'proxies_priv' entry '@ [email protected]' ignored in --skip-name-resolve mode.
170928  9:36:58 [Note] Event Scheduler: Loaded 0 events
170928  9:36:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.45'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Remi
170928  9:37:03 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_app_settings' is marked as crashed and should be repaired
170928  9:37:03 [Warning] Checking table:   './almamed_1/wa_app_settings'
170928  9:37:12 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cart_items' is marked as crashed and should be repaired
170928  9:37:12 [Warning] Checking table:   './almamed_1/shop_cart_items'
170928  9:37:13 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_contact' is marked as crashed and should be repaired
170928  9:37:13 [Warning] Checking table:   './almamed_1/wa_contact'
170928  9:37:13 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_contact_settings' is marked as crashed and should be repaired
170928  9:37:13 [Warning] Checking table:   './almamed_1/wa_contact_settings'
170928  9:39:21 [ERROR] /usr/libexec/mysqld: Table './belkuzov_s/wp_options' is marked as crashed and should be repaired
170928  9:39:21 [Warning] Checking table:   './belkuzov_s/wp_options'
170928  9:44:06 [ERROR] /usr/libexec/mysqld: Table './mebel@002dvoronezh_s/wp_options' is marked as crashed and should be repaired
170928  9:44:06 [Warning] Checking table:   './mebel@002dvoronezh_s/wp_options'
170928  9:47:59 [ERROR] /usr/libexec/mysqld: Table './almamed_1/wa_login_log' is marked as crashed and should be repaired
170928  9:47:59 [Warning] Checking table:   './almamed_1/wa_login_log'
170928 10:00:02 [ERROR] /usr/libexec/mysqld: Table './almamed_1/shop_cartsreport_plugin_cart' is marked as crashed and should be repaired
170928 10:00:02 [Warning] Checking table:   './almamed_1/shop_cartsreport_plugin_cart

[PeaceData]

Привет,

InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.

Ошибка в маленьком Redo логе Innodb, поменяй innodb_log_file_size 50M (в mysql 5.5 дефолт 8M, О том, как менять читай тут https://dev.mysql.com/doc/refman/5.5/en ... ation.html). Параметр max_allowed_packet лучше ставь не более innodb_log_file_size.

Вышел довольно странный конфиг, попробуй дефолт http://c.vestacp.com/rhel/7/mysqld/my-large.cnf, смотря сколько памяти в сервере, кстати скажи, сколько там RAM? Посмотри вывод dmesg и лог /var/log/messages на события Out of memory kill. Есть еще сайт https://tools.percona.com/ с мастером генерайции конфига

key_buffer_size - необычно маленький
thread_stack - лучше убери, по дефолту будет около 260K
thread_cache_size - большой
query_cache* большой
max_allowed_packet большой
innodb* довольно много памяти

[skurudo]

Ну и стоит сверяться с тюнерами:
viewtopic.php?f=32&t=14149

Есть специальные и довольно удачные скрипты для проверки своих настроек.