Mysql restarting

A

Atmsrl

Member
Dec 21, 2017
5
0
1
italy
cPanel Access Level
Root Administrator
Hi all....

I have a vps with centos 6.9 with cpanel 68.0.20.

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.


can someone help me to resolve this problem?

Tnx.
 
Last edited by a moderator:
Eminds

Eminds

Well-Known Member
Nov 10, 2016
319
33
28
India
cPanel Access Level
Root Administrator
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.
 
24x7server

24x7server

Well-Known Member
Apr 17, 2013
1,912
99
78
India
cPanel Access Level
Root Administrator
Twitter
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..
 
A

Atmsrl

Member
Dec 21, 2017
5
0
1
italy
cPanel Access Level
Root Administrator
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

Code: 
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.
 
cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,261
463
Atmsrl said:
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.
Click to expand...
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M mysql Lock wait timeout exceeded; try restarting transaction Databases 7
K MySQL Restarting - Note -usr-sbin-mysqld: Normal shutdown Databases 12
W SOLVED Prevent MySQL service from restarting? Databases 4
Samet Chan Restarting MySQL Server failed and slow restarting. Databases 15
N Mysql Always Restarting During Full Backup Restore Databases 4
Similar threads
mysql Lock wait timeout exceeded; try restarting transaction
MySQL Restarting - Note -usr-sbin-mysqld: Normal shutdown
SOLVED Prevent MySQL service from restarting?
Restarting MySQL Server failed and slow restarting.
Mysql Always Restarting During Full Backup Restore
Top Bottom