Mysql restarting

December 21, 2017 10:29
check the /etc/my.cnf file where you can find the parameters configured, you can increase it however it may still cause high server resource usages.
0
Atmsrl
December 21, 2017 10:35
but a standard value exists?
0
24x7server
December 21, 2017 15:12
Hi, Check the error logs defined "--log-error=host.err " for more information to investigate the issue properly. Check if you are seeing any error on it and update the error here..
0
Atmsrl
December 21, 2017 16:02
i tried to look in file .err.... during mornig at 06:40 mysql service it has reset... paste the lines of the log here: Tnx for support
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:27:02 16542 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:27:04 16542 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:27:04 16542 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:27:04 16542 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:27:04 16542 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:27:04 16542 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:27:04 16542 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:27:04 16542 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:27:04 16542 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:27:04 16542 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:27:05 16542 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:27:05 16542 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2401653313
2017-12-21 06:27:05 16542 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:27:05 16542 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:27:05 16542 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:27:12 16542 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:27:12 16542 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2401672324
2017-12-21 06:27:17 16542 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
2017-12-21 06:27:17 16542 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:27:17 16542 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:27:17 16542 [Note] InnoDB: 5.6.38 started; log sequence number 2401672324
2017-12-21 06:27:17 16542 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:27:17 16542 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:27:17 16542 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:27:19 16542 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:27:19 16542 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:29:43 17313 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:29:43 17313 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:29:43 17313 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:29:43 17313 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:29:43 17313 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:29:43 17313 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:29:43 17313 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:29:43 17313 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:29:43 17313 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:29:43 17313 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:29:43 17313 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:29:43 17313 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2401685697
2017-12-21 06:29:43 17313 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:29:43 17313 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:29:43 17313 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:29:49 17313 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:29:49 17313 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2401698417
2017-12-21 06:29:52 17313 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
2017-12-21 06:29:52 17313 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:29:52 17313 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:29:52 17313 [Note] InnoDB: 5.6.38 started; log sequence number 2401698417
2017-12-21 06:29:52 17313 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:29:52 17313 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:29:52 17313 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:29:53 17313 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:29:53 17313 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:32:37 18207 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:32:37 18207 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:32:37 18207 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:32:37 18207 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:32:37 18207 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:32:37 18207 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:32:37 18207 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:32:37 18207 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:32:37 18207 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:32:38 18207 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:32:38 18207 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:32:38 18207 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2401729778
2017-12-21 06:32:38 18207 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:32:38 18207 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:32:38 18207 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:32:39 18207 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:32:39 18207 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2401730414
InnoDB: 2 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 2 row operations to undo
InnoDB: Trx id counter is 28262400
2017-12-21 06:32:41 18207 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
2017-12-21 06:32:41 18207 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:32:41 18207 [Note] InnoDB: Waiting for purge to start
InnoDB: Starting in background the rollback of uncommitted transactions
2017-12-21 06:32:41 7f9fd2184700  InnoDB: Rolling back trx with id 28261893, 1 rows to undo
2017-12-21 06:32:41 18207 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:32:41 18207 [Note] InnoDB: 5.6.38 started; log sequence number 2401730414
2017-12-21 06:32:41 18207 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:32:41 18207 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:32:41 18207 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:32:42 18207 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:32:42 18207 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:32:43 18207 [Note] InnoDB: Rollback of trx with id 28261893 completed
2017-12-21 06:32:43 7f9fd2184700  InnoDB: Rolling back trx with id 28261892, 1 rows to undo
2017-12-21 06:32:46 18207 [Note] InnoDB: Rollback of trx with id 28261892 completed
2017-12-21 06:32:46 7f9fd2184700  InnoDB: Rollback of non-prepared transactions completed
2017-12-21 06:33:15 18781 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:33:17 18781 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:33:17 18781 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:33:17 18781 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:33:17 18781 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:33:17 18781 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:33:17 18781 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:33:17 18781 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:33:17 18781 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:33:17 18781 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:33:17 18781 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:33:17 18781 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2401759298
2017-12-21 06:33:17 18781 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:33:17 18781 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:33:17 18781 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:33:17 18781 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:33:17 18781 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2401760247
2017-12-21 06:33:20 18781 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 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
2017-12-21 06:33:20 18781 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:33:20 18781 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:33:20 18781 [Note] InnoDB: 5.6.38 started; log sequence number 2401760247
2017-12-21 06:33:20 18781 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:33:20 18781 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:33:20 18781 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:33:20 18781 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:33:20 18781 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:35:12 19521 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:35:14 19521 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:35:14 19521 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:35:14 19521 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:35:14 19521 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:35:14 19521 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:35:14 19521 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:35:15 19521 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:35:15 19521 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:35:15 19521 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:35:15 19521 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:35:15 19521 [Note] InnoDB: The log sequence numbers 2313954400 and 2313954400 in ibdata files do not match the log sequence number 2401809623 in the ib_logfiles!
2017-12-21 06:35:15 19521 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:35:15 19521 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:35:15 19521 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:35:22 19521 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:35:22 19521 [Note] InnoDB: from the doublewrite buffer...
2017-12-21 06:35:26 19521 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:35:26 19521 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:35:26 19521 [Note] InnoDB: 5.6.38 started; log sequence number 2401809623
2017-12-21 06:35:26 19521 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:35:26 19521 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:35:26 19521 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:35:26 19521 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:35:26 19521 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:36:43 20238 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:36:43 20238 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:36:43 20238 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:36:43 20238 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:36:43 20238 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:36:43 20238 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:36:43 20238 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:36:43 20238 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:36:43 20238 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:36:43 20238 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:36:44 20238 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:36:44 20238 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2401817312
2017-12-21 06:36:44 20238 [Note] InnoDB: Database was not shutdown normally!
2017-12-21 06:36:44 20238 [Note] InnoDB: Starting crash recovery.
2017-12-21 06:36:44 20238 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-12-21 06:36:47 20238 [Note] InnoDB: Restoring possible half-written data pages
2017-12-21 06:36:47 20238 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 2401819418
2017-12-21 06:36:48 20238 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 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
2017-12-21 06:36:49 20238 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:36:49 20238 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:36:49 20238 [Note] InnoDB: 5.6.38 started; log sequence number 2401819418
2017-12-21 06:36:49 20238 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:36:49 20238 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:36:49 20238 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:36:49 20238 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:36:49 20238 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2017-12-21 06:36:50 20238 [Note] /usr/sbin/mysqld: Normal shutdown

2017-12-21 06:36:50 20238 [Note] Giving 32 client threads a chance to die gracefully
2017-12-21 06:36:50 20238 [Note] Event Scheduler: Purging the queue. 0 events
2017-12-21 06:36:50 20238 [Note] Shutting down slave threads
2017-12-21 06:36:52 20238 [Note] Forcefully disconnecting 0 remaining clients
2017-12-21 06:36:52 20238 [Note] Binlog end
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'partition'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'ARCHIVE'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_METRICS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_CMP'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'INNODB_TRX'
2017-12-21 06:36:52 20238 [Note] Shutting down plugin 'InnoDB'
2017-12-21 06:36:52 20238 [Note] InnoDB: FTS optimize thread exiting.
2017-12-21 06:36:52 20238 [Note] InnoDB: Starting shutdown...
2017-12-21 06:36:56 20238 [Note] InnoDB: Shutdown completed; log sequence number 2401831156
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'BLACKHOLE'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'MRG_MYISAM'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'CSV'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'MEMORY'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'MyISAM'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'sha256_password'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'mysql_old_password'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'mysql_native_password'
2017-12-21 06:36:56 20238 [Note] Shutting down plugin 'binlog'
2017-12-21 06:36:56 20238 [Note] /usr/sbin/mysqld: Shutdown complete

2017-12-21 06:36:57 20833 [Note] Plugin 'FEDERATED' is disabled.
2017-12-21 06:36:57 20833 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-21 06:36:57 20833 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-21 06:36:57 20833 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-21 06:36:57 20833 [Note] InnoDB: Memory barrier is not used
2017-12-21 06:36:57 20833 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-21 06:36:57 20833 [Note] InnoDB: Using Linux native AIO
2017-12-21 06:36:57 20833 [Note] InnoDB: Using CPU crc32 instructions
2017-12-21 06:36:57 20833 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-21 06:36:57 20833 [Note] InnoDB: Completed initialization of buffer pool
2017-12-21 06:36:57 20833 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-21 06:36:58 20833 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-21 06:36:58 20833 [Note] InnoDB: Waiting for purge to start
2017-12-21 06:36:58 20833 [Note] InnoDB: 5.6.38 started; log sequence number 2401831156
2017-12-21 06:36:58 20833 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-12-21 06:36:58 20833 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-12-21 06:36:58 20833 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-21 06:36:58 20833 [Note] Event Scheduler: Loaded 0 events
2017-12-21 06:36:58 20833 [Note] /usr/sbin/mysqld: ready for connections.
0
cPanelMichael
December 22, 2017 18:28
When i try top or htop i see this error: /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=host.err --open-files-limit=100000 --pid-file=/var/lib/mysql/host.pid On many occasions this cause kill mysql service and sending down my site.
Hello, That's not an error message. That's simply the standard process for the MySQL service. As far as MySQL restarting, can you verify if it was restarted manually, or are you unable to determine the source of the restart? Thank you.
0
Atmsrl
December 22, 2017 22:25
I see any log, but i not determine the source of the restart... with mysql, spamd and clamav are also restarted Restart automatic process. Load Averages: 74.49 43.85 20.56 in 5 minuts Load Averages: 119.73 82.31 40.22
0
cPanelMichael
December 22, 2017 22:30
Load Averages: 74.49 43.85 20.56
The following thread is useful when troubleshooting high load averages (the issue you are facing likely relates to the high load): Troubleshooting high server loads on Linux servers Thank you.
0
Mysql restarting

Comments

Didn't find what you were looking for?
