Mysql – MariaDB Frequently Restarting

mariadbMySQL

MariaDB is frequently (multiple times a day) restarting.

This is what I get in the mariadb.log

200411 18:38:51 mysqld_safe Number of processes running now: 0
200411 18:38:51 mysqld_safe mysqld restarted
200411 18:38:53 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.HWm8QZ' --pid-file='/var/lib/mysql/db-recover.pid'
200411 18:38:54 [Note] /usr/sbin/mysqld (mysqld 10.0.33-MariaDB-wsrep) starting as process 16103 ...
200411 18:39:01 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
200411 18:39:01 [Note] /usr/sbin/mysqld (mysqld 10.0.33-MariaDB-wsrep) starting as process 16162 ...
200411 18:39:01 [Note] InnoDB: Using mutexes to ref count buffer pool pages
200411 18:39:01 [Note] InnoDB: The InnoDB memory heap is disabled
200411 18:39:01 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
200411 18:39:01 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
200411 18:39:01 [Note] InnoDB: Compressed tables use zlib 1.2.7
200411 18:39:01 [Note] InnoDB: Using Linux native AIO
200411 18:39:01 [Note] InnoDB: Using CPU crc32 instructions
200411 18:39:01 [Note] InnoDB: Initializing buffer pool, size = 4.4G
200411 18:39:02 [Note] InnoDB: Completed initialization of buffer pool
200411 18:39:02 [Note] InnoDB: Highest supported file format is Barracuda.
200411 18:39:02 [Note] InnoDB: 128 rollback segment(s) are active.
200411 18:39:02 [Note] InnoDB: Waiting for purge to start
200411 18:39:02 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 523546041827
200411 18:39:02 [Note] Plugin 'FEEDBACK' is disabled.
200411 18:39:02 [Note] Server socket created on IP: '::'.
200411 18:39:02 [Warning] 'proxies_priv' entry '@% root@site-mariadb' ignored in --skip-name-resolve mode.
200411 18:39:02 [Note] WSREP: Read nil XID from storage engines, skipping position init
200411 18:39:02 [Note] WSREP: wsrep_load(): loading provider library 'none'
200411 18:39:02 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.33-MariaDB-wsrep'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server, wsrep_25.21.rc3fc46e

Any ideas what could be going on?

Best Answer

Rate Per Second = RPS

Suggestions to consider for your my.cnf [mysqld] section

max_connect_errors=10  # from 1 Million to frustrate hackers/crackers at 10 attempts
innodb_lru_scan_depth=100  # from 1024 to conserve 90% of CPU cycles used for function
read_buffer_size=256K # from 128K to reduce handler_read_next RPS of 13,569
aria_pagecache_age_threshold=900  # from 300 to delay age out and reduce aria_pagecache_reads RPS of 1
connect_timeout=20  # from 10 to reduce aborted_connects RPhr of 60

There are more opportunities to improve your configuration. Make contact, please.

Related Question