How make database auto restart

trustdee

A number of times ... i find my database will stop working.. i have to restart ..

this can happen in weeks , days .. Please anyway to create auto database restart if database stops ?

zeroinf

You can make a cronjob
http://prntscr.com/s3gcyi
/etc/init.d/mysqld start

trustdee

zeroinf didn't not help , still same issue ... how to monitor if mysqld exited and restart .

I used this systemctl is-active mysqld || systemctl restart mysqld , but works only if you stop mysqld ... Please help

aapanel_user

trustdee I think you need something like Monit

trustdee

aapanel_user the problem is, mysqld is using error code exited how do i check if exited then restart. am currently on the edge of going for another panel , because i have been on this issues for long.

My server spec here.

CentOS 7.7.1908
2G Ram
SSD
2 Core
Just a WordPress site

Here is log i have```

200423 03:26:48 mysqld_safe Number of processes running now: 0
200423 03:26:50 mysqld_safe mysqld restarted
2020-04-23 3:26:53 47405626890624 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 3:26:53 47405626890624 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 19559 ...
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Using Linux native AIO
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 3:26:53 47405626890624 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(140574720 bytes) failed; errno 12
2020-04-23 3:26:53 47405626890624 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-04-23 3:26:53 47405626890624 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-23 3:26:53 47405626890624 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-23 3:26:53 47405626890624 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 3:26:53 47405626890624 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-04-23 3:26:53 47405626890624 [ERROR] Aborting

200423 03:26:54 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 03:54:15 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 3:54:15 47966075287936 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 3:54:15 47966075287936 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 20524 ...
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Using Linux native AIO
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-23 3:54:15 47966075287936 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: The log sequence number 18202938581 in ibdata file do not match the log sequence number 18306956145 in the ib_logfiles!
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: Waiting for purge to start
2020-04-23 3:54:16 47966075287936 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18306956145
2020-04-23 3:54:16 47966455138048 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 3:54:16 47966075287936 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 3:54:16 47966075287936 [Note] Server socket created on IP: '::'.
2020-04-23 3:54:16 47966075287936 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 4:16:21 47966457546496 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 4:16:21 47966457546496 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 4:16:21 47966446733056 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 4:16:21 47966457546496 [Note] InnoDB: Starting shutdown...
2020-04-23 4:16:22 47966457546496 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 4:16:23 47966457546496 [Note] InnoDB: Shutdown completed; log sequence number 18321540915
2020-04-23 4:16:23 47966457546496 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 04:16:23 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 04:16:24 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 4:16:24 47376308013440 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 4:16:24 47376308013440 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 22462 ...
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Using Linux native AIO
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Waiting for purge to start
2020-04-23 4:16:24 47376308013440 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18321540915
2020-04-23 4:16:24 47376897402624 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 4:16:24 47376308013440 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 4:16:24 47376308013440 [Note] Server socket created on IP: '::'.
2020-04-23 4:16:24 47376308013440 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 4:16:41 47376441972480 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 4:16:41 47376441972480 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 4:16:41 47376891098880 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 4:16:41 47376441972480 [Note] InnoDB: Starting shutdown...
2020-04-23 4:16:42 47376441972480 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 4:16:44 47376441972480 [Note] InnoDB: Shutdown completed; log sequence number 18321540925
2020-04-23 4:16:44 47376441972480 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 04:16:44 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 04:16:54 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 4:16:55 47841388792192 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 4:16:55 47841388792192 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 23204 ...
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Using Linux native AIO
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Waiting for purge to start
2020-04-23 4:16:55 47841388792192 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18321540925
2020-04-23 4:16:55 47841768969984 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 4:16:55 47841388792192 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 4:16:55 47841388792192 [Note] Server socket created on IP: '::'.
2020-04-23 4:16:55 47841388792192 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 4:17:25 47841772914432 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 4:17:25 47841772914432 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 4:17:25 47841762666240 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 4:17:25 47841772914432 [Note] InnoDB: Starting shutdown...
2020-04-23 4:17:26 47841772914432 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 4:17:28 47841772914432 [Note] InnoDB: Shutdown completed; log sequence number 18321678727
2020-04-23 4:17:28 47841772914432 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 04:17:28 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 04:18:02 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 4:18:02 47183015340416 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 4:18:02 47183015340416 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 24052 ...
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Using Linux native AIO
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Waiting for purge to start
2020-04-23 4:18:02 47183015340416 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18321678727
2020-04-23 4:18:02 47183604991744 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 4:18:02 47183015340416 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 4:18:02 47183015340416 [Note] Server socket created on IP: '::'.
2020-04-23 4:18:02 47183015340416 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
200423 04:38:37 mysqld_safe Number of processes running now: 0
200423 04:38:38 mysqld_safe mysqld restarted
2020-04-23 4:38:38 47136771361152 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 4:38:38 47136771361152 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 29513 ...
2020-04-23 4:38:39 47136771361152 [ERROR] mysqld: Out of memory (Needed 128663552 bytes)
2020-04-23 4:38:39 47136771361152 [ERROR] mysqld: Out of memory (Needed 96485376 bytes)
2020-04-23 4:38:39 47136771361152 [ERROR] mysqld: Out of memory (Needed 72351744 bytes)
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Using Linux native AIO
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 4:38:39 47136771361152 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(140574720 bytes) failed; errno 12
2020-04-23 4:38:39 47136771361152 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-04-23 4:38:39 47136771361152 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-23 4:38:39 47136771361152 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-23 4:38:39 47136771361152 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 4:38:39 47136771361152 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-04-23 4:38:39 47136771361152 [ERROR] Aborting

200423 04:38:39 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 05:35:10 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 5:35:10 47681829607808 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 5:35:10 47681829607808 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 11855 ...
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Using Linux native AIO
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 5:35:10 47681829607808 [Note] InnoDB: The log sequence number 18321678727 in ibdata file do not match the log sequence number 18331326128 in the ib_logfiles!
2020-04-23 5:35:11 47681829607808 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 5:35:11 47681829607808 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 5:35:11 47681829607808 [Note] InnoDB: Waiting for purge to start
2020-04-23 5:35:11 47681829607808 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18331326128
2020-04-23 5:35:11 47682418759424 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 5:35:11 47681829607808 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 5:35:11 47681829607808 [Note] Recovering after a crash using tc.log
2020-04-23 5:35:11 47681829607808 [Note] Starting crash recovery...
2020-04-23 5:35:11 47681829607808 [Note] Crash recovery finished.
2020-04-23 5:35:11 47681829607808 [Note] Server socket created on IP: '::'.
2020-04-23 5:35:11 47681829607808 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 6:19:35 47681988445952 [ERROR] mysqld: Table './xenforo1/xf_session' is marked as crashed and should be repaired
2020-04-23 6:19:35 47681988445952 [Warning] Checking table: './xenforo1/xf_session'
2020-04-23 6:47:41 47682422089472 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 6:47:41 47682422089472 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 6:47:41 47682410354432 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 6:47:41 47682422089472 [Note] InnoDB: Starting shutdown...
2020-04-23 6:47:42 47682422089472 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 6:47:43 47682422089472 [Note] InnoDB: Shutdown completed; log sequence number 18358890876
2020-04-23 6:47:43 47682422089472 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 06:47:43 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 06:47:44 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 6:47:44 47968506190208 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 6:47:44 47968506190208 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 19968 ...
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Using Linux native AIO
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 6:47:44 47968506190208 [Note] InnoDB: Waiting for purge to start
2020-04-23 6:47:45 47968506190208 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18358890876
2020-04-23 6:47:45 47969732998912 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 6:47:45 47968506190208 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 6:47:45 47968506190208 [Note] Server socket created on IP: '::'.
2020-04-23 6:47:45 47968506190208 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 7:07:01 47969214125824 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 7:07:01 47969214125824 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 7:07:01 47969726695168 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 7:07:01 47969214125824 [Note] InnoDB: Starting shutdown...
2020-04-23 7:07:02 47969214125824 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 7:07:04 47969214125824 [Note] InnoDB: Shutdown completed; log sequence number 18363239565
2020-04-23 7:07:04 47969214125824 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 07:07:04 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 07:07:34 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 7:07:35 47876247882112 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 7:07:35 47876247882112 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 2094 ...
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Using Linux native AIO
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 7:07:35 47876247882112 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 7:07:36 47876247882112 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 7:07:36 47876247882112 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 7:07:36 47876247882112 [Note] InnoDB: Waiting for purge to start
2020-04-23 7:07:36 47876247882112 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18363239565
2020-04-23 7:07:36 47876247882112 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 7:07:36 47877475092224 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 7:07:36 47876247882112 [Note] Server socket created on IP: '::'.
2020-04-23 7:07:36 47876247882112 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
200423 07:13:01 mysqld_safe Number of processes running now: 0
200423 07:13:02 mysqld_safe mysqld restarted
2020-04-23 7:13:03 47778381035904 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 7:13:03 47778381035904 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 4014 ...
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Using Linux native AIO
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 7:13:05 47778381035904 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 7:13:06 47778381035904 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 7:13:07 47778381035904 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 7:13:07 47778381035904 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18364570861
2020-04-23 7:13:07 47778381035904 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2020-04-23 7:13:08 47778381035904 [Note] InnoDB: Starting final batch to recover 11 pages from redo log
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 7:13:08 47778381035904 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 7:13:08 47778381035904 [Note] InnoDB: Waiting for purge to start
2020-04-23 7:13:08 47778381035904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18364706482
2020-04-23 7:13:08 47779609384704 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 7:13:08 47778381035904 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 7:13:08 47778381035904 [Note] Recovering after a crash using tc.log
2020-04-23 7:13:08 47778381035904 [Note] Starting crash recovery...
2020-04-23 7:13:08 47778381035904 [Note] Crash recovery finished.
2020-04-23 7:13:08 47778381035904 [Note] Server socket created on IP: '::'.
2020-04-23 7:13:08 47778381035904 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
200423 12:27:21 mysqld_safe Number of processes running now: 0
200423 12:27:22 mysqld_safe mysqld restarted
2020-04-23 12:27:23 47291604658560 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 12:27:23 47291604658560 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 7256 ...
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Using Linux native AIO
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 12:27:24 47291604658560 [Note] InnoDB: Initializing buffer pool, size = 384.0M
InnoDB: mmap(421724160 bytes) failed; errno 12
2020-04-23 12:27:24 47291604658560 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-04-23 12:27:24 47291604658560 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-23 12:27:24 47291604658560 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-23 12:27:24 47291604658560 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 12:27:24 47291604658560 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-04-23 12:27:24 47291604658560 [ERROR] Aborting

200423 12:27:24 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 14:31:02 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 14:31:02 46984434342272 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 14:31:02 46984434342272 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 8747 ...
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Using Linux native AIO
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 14:31:02 46984434342272 [Note] InnoDB: The log sequence number 18363239565 in ibdata file do not match the log sequence number 18441908983 in the ib_logfiles!
2020-04-23 14:31:03 46984434342272 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 14:31:03 46984434342272 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 14:31:03 46984434342272 [Note] InnoDB: Waiting for purge to start
2020-04-23 14:31:03 46984434342272 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18441908983
2020-04-23 14:31:03 46984434342272 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 14:31:03 46984434342272 [Note] Recovering after a crash using tc.log
2020-04-23 14:31:03 46985661196032 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 14:31:03 46984434342272 [Note] Starting crash recovery...
2020-04-23 14:31:03 46984434342272 [Note] Crash recovery finished.
2020-04-23 14:31:03 46984434342272 [Note] Server socket created on IP: '::'.
2020-04-23 14:31:03 46984434342272 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 14:54:08 46986541995776 [ERROR] mysqld: Table './xenforo1/xf_session' is marked as crashed and should be repaired
2020-04-23 14:54:08 46986541995776 [Warning] Checking table: './xenforo1/xf_session'
200423 16:13:28 mysqld_safe Number of processes running now: 0
200423 16:13:30 mysqld_safe mysqld restarted
2020-04-23 16:13:32 47609395186048 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 16:13:32 47609395186048 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 14088 ...
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Using Linux native AIO
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 16:13:34 47609395186048 [Note] InnoDB: Initializing buffer pool, size = 384.0M
InnoDB: mmap(421724160 bytes) failed; errno 12
2020-04-23 16:13:34 47609395186048 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-04-23 16:13:34 47609395186048 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-23 16:13:34 47609395186048 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-23 16:13:34 47609395186048 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 16:13:34 47609395186048 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-04-23 16:13:34 47609395186048 [ERROR] Aborting

200423 16:13:34 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 16:42:55 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 16:42:55 47765960702336 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 16:42:55 47765960702336 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 14842 ...
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Using Linux native AIO
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: The log sequence number 18363239565 in ibdata file do not match the log sequence number 18487675536 in the ib_logfiles!
2020-04-23 16:42:55 47765960702336 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 16:42:56 47765960702336 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 16:42:56 47765960702336 [Note] InnoDB: Waiting for purge to start
2020-04-23 16:42:56 47765960702336 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18487675536
2020-04-23 16:42:56 47767187924736 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 16:42:56 47765960702336 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 16:42:56 47765960702336 [Note] Recovering after a crash using tc.log
2020-04-23 16:42:56 47765960702336 [Note] Starting crash recovery...
2020-04-23 16:42:56 47765960702336 [Note] Crash recovery finished.
2020-04-23 16:42:56 47765960702336 [Note] Server socket created on IP: '::'.
2020-04-23 16:42:56 47765960702336 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-04-23 16:44:53 47766679713536 [ERROR] mysqld: Table './xenforo1/xf_session' is marked as crashed and should be repaired
2020-04-23 16:44:53 47766679713536 [Warning] Checking table: './xenforo1/xf_session'
2020-04-23 17:02:00 47767195973376 [Note] /www/server/mysql/bin/mysqld: Normal shutdown
2020-04-23 17:02:00 47767195973376 [Note] Event Scheduler: Purging the queue. 0 events
2020-04-23 17:02:00 47767179519744 [Note] InnoDB: FTS optimize thread exiting.
2020-04-23 17:02:00 47767195973376 [Note] InnoDB: Starting shutdown...
2020-04-23 17:02:01 47767195973376 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2020-04-23 17:02:02 47767195973376 [Note] InnoDB: Shutdown completed; log sequence number 18506708100
2020-04-23 17:02:02 47767195973376 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

200423 17:02:02 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 17:02:28 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 17:02:28 47641345116544 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 17:02:28 47641345116544 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 2077 ...
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Using Linux native AIO
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 17:02:28 47641345116544 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 17:02:29 47641345116544 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 17:02:29 47641345116544 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 17:02:29 47641345116544 [Note] InnoDB: Waiting for purge to start
2020-04-23 17:02:29 47641345116544 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18506708100
2020-04-23 17:02:29 47641345116544 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 17:02:29 47642504627968 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 17:02:29 47641345116544 [Note] Server socket created on IP: '::'.
2020-04-23 17:02:29 47641345116544 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
200423 19:16:39 mysqld_safe Number of processes running now: 0
200423 19:16:40 mysqld_safe mysqld restarted
2020-04-23 19:16:41 47235623172480 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 19:16:41 47235623172480 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 13998 ...
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Using Linux native AIO
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 19:16:41 47235623172480 [Note] InnoDB: Initializing buffer pool, size = 384.0M
InnoDB: mmap(421724160 bytes) failed; errno 12
2020-04-23 19:16:41 47235623172480 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2020-04-23 19:16:41 47235623172480 [ERROR] Plugin 'InnoDB' init function returned error.
2020-04-23 19:16:41 47235623172480 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-04-23 19:16:41 47235623172480 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 19:16:41 47235623172480 [ERROR] Unknown/unsupported storage engine: InnoDB
2020-04-23 19:16:41 47235623172480 [ERROR] Aborting

200423 19:16:41 mysqld_safe mysqld from pid file /www/server/data/website.com.pid ended
200423 19:33:45 mysqld_safe Starting mysqld daemon with databases from /www/server/data
2020-04-23 19:33:46 47069394467200 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2020-04-23 19:33:46 47069394467200 [Note] /www/server/mysql/bin/mysqld (mysqld 10.1.44-MariaDB) starting as process 14885 ...
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: The InnoDB memory heap is disabled
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Using Linux native AIO
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Using SSE crc32 instructions
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Highest supported file format is Barracuda.
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18563796078
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2020-04-23 19:33:46 47069394467200 [Note] InnoDB: Starting final batch to recover 3 pages from redo log
InnoDB: Last MySQL binlog file position 0 92481708, file name ./mysql-bin.000085
2020-04-23 19:33:47 47069394467200 [Note] InnoDB: 128 rollback segment(s) are active.
2020-04-23 19:33:47 47069394467200 [Note] InnoDB: Waiting for purge to start
2020-04-23 19:33:47 47069394467200 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.46-86.2 started; log sequence number 18563796427
2020-04-23 19:33:47 47070621017856 [Note] InnoDB: Dumping buffer pool(s) not yet started
2020-04-23 19:33:47 47069394467200 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 19:33:47 47069394467200 [Note] Recovering after a crash using tc.log
2020-04-23 19:33:47 47069394467200 [Note] Starting crash recovery...
2020-04-23 19:33:47 47069394467200 [Note] Crash recovery finished.
2020-04-23 19:33:47 47069394467200 [Note] Server socket created on IP: '::'.
2020-04-23 19:33:47 47069394467200 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.1.44-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution

aaPanel_Jose

trustdee
I think you mysql auto stop is because you share too much RAM to mysql

you can try to adjust your mysql and observe its running status

trustdee

Please sir , is it possible to capture when mysql exited and restart .. i need it ... i have tried everything , i reduced the ram ... yet i'm still having the problem

kaz050457

trustdee

use monit to check ur mysql services.. Monit will notify u realtime thru mail/pushover/slack everytime ur mysql will stop or start.. and add a script to automatic restart it when down..

trustdee

kaz050457

You care to help me with this log .. i used monit pre-defined template as was mentioned in this post : https://www.howtoforge.com/tutorial/how-to-install-and-configure-monit-on-debian-9/


/etc/monit/conf-enabled/mysql:4: Program does not exist: '/etc/init.d/mysql'
/etc/monit/conf-enabled/mysql:5: Program does not exist: '/etc/init.d/mysql'
checksum: file /usr/sbin/mysqld is not regular file
/etc/monit/conf-enabled/mysql:13: Cannot compute a checksum for file /usr/sbin/mysqld 'mysql'
checksum: file /etc/init.d/mysql is not regular file
/etc/monit/conf-enabled/mysql:17: Cannot compute a checksum for file /etc/init.d/mysql 'mysql'
Control file syntax OK

aaPanel_Jose

Hello
trustdee
is/etc/init.d/mysqld not /etc/init.d/mysql

trustdee

aaPanel_Jose

Great ... i think i solved it with

check host myserver with address 127.0.0.1
   if failed port 3306 protocol mysql with timeout 15 seconds then restart

thank you guys