We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Неожиданно начала падать Mysql
Неожиданно начала падать Mysql
Всем доброго дня!
И спасибо за советы, которые Вы дадите.
Проблема началась с 25 числа, неожиданно начала перезапускаться mysql каждые 60-80 минут, грешил на обновленный скрипт от одного разработчика, который как раз перед этим обновил, он сидит на кроне и прилично работает с бд, бд может получаться и 8 гб где-то.
Правки в my.cnf после команды mysqltuner и рекомендаций там, привели к тому, что сервер вообще перестал запускаться и потом еще пришлось проверять файловую систему.
Вчера ночью я отключил полностью запуск данного скрипта, чтобы понаблюдать за mysql, подозревая тот скрипт, но нет, падения продолжились и без его работы, также примерно каждые 60-80 минут.
Помогите разобраться
Настройки my.cnf
Вот логи mysqld.log
И спасибо за советы, которые Вы дадите.
Проблема началась с 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
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
Re: Неожиданно начала падать Mysql
Привет,
Вышел довольно странный конфиг, попробуй дефолт 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* довольно много памяти
Ошибка в маленьком 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.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.
Вышел довольно странный конфиг, попробуй дефолт 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* довольно много памяти
Re: Неожиданно начала падать Mysql
Ну и стоит сверяться с тюнерами:
viewtopic.php?f=32&t=14149
Есть специальные и довольно удачные скрипты для проверки своих настроек.
viewtopic.php?f=32&t=14149
Есть специальные и довольно удачные скрипты для проверки своих настроек.