Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql restarting

Discussion in 'Database Discussion' started by Atmsrl, Dec 21, 2017.

  1. Atmsrl

    Atmsrl Member

    Joined:
    Dec 21, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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.
     
    #1 Atmsrl, Dec 21, 2017
    Last edited by a moderator: Dec 21, 2017
  2. Eminds

    Eminds Well-Known Member

    Joined:
    Nov 10, 2016
    Messages:
    267
    Likes Received:
    20
    Trophy Points:
    18
    Location:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Atmsrl

    Atmsrl Member

    Joined:
    Dec 21, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    italy
    cPanel Access Level:
    Root Administrator
    but
    a standard value exists?
     
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,880
    Likes Received:
    89
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Atmsrl

    Atmsrl Member

    Joined:
    Dec 21, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Atmsrl

    Atmsrl Member

    Joined:
    Dec 21, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    italy
    cPanel Access Level:
    Root Administrator
    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
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice