apply config slow

[benjaminsmith]

I will check it tomorrow morning and get back to you asap.

Sounds good!

[fsodah]

Please find attached requested info.

Code: Select all

191005 17:08:24 [Note] Event Scheduler: Loaded 0 events
191005 17:08:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
191028 17:10:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
191028 17:10:17 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 2324 ...
191028 17:10:17 InnoDB: The InnoDB memory heap is disabled
191028 17:10:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
191028 17:10:17 InnoDB: Compressed tables use zlib 1.2.7
191028 17:10:17 InnoDB: Using Linux native AIO
191028 17:10:18 InnoDB: Initializing buffer pool, size = 128.0M
191028 17:10:18 InnoDB: Completed initialization of buffer pool
191028 17:10:18 InnoDB: highest supported file format is Barracuda.
191028 17:10:18  InnoDB: Starting crash recovery from checkpoint LSN=6254427440
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
191028 17:10:18  InnoDB: Starting final batch to recover 1 pages from redo log
191028 17:10:19  InnoDB: Waiting for the background threads to start
191028 17:10:20 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 6254428644
191028 17:10:20 [Note] Plugin 'FEEDBACK' is disabled.
191028 17:10:21 [Note] Server socket created on IP: '0.0.0.0'.
191028 17:10:21 [Note] Event Scheduler: Loaded 0 events
191028 17:10:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
191028 17:10:22 [ERROR] mysqld: Table './nagios/nagios_conninfo' is marked as crashed and should be repaired
191028 17:10:22 [Warning] Checking table:   './nagios/nagios_conninfo'
191028 17:10:22 [ERROR] mysqld: Table './nagios/nagios_programstatus' is marked as crashed and should be repaired
191028 17:10:22 [Warning] Checking table:   './nagios/nagios_programstatus'
191028 17:10:22 [ERROR] mysqld: Table './nagios/nagios_hoststatus' is marked as crashed and should be repaired
191028 17:10:22 [Warning] Checking table:   './nagios/nagios_hoststatus'
191028 17:10:22 [ERROR] mysqld: Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired
191028 17:10:22 [Warning] Checking table:   './nagios/nagios_servicestatus'
191028 17:10:23 [ERROR] mysqld: Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired
191028 17:10:23 [Warning] Checking table:   './nagios/nagios_systemcommands'
191028 17:10:23 [ERROR] mysqld: Table './nagios/nagios_eventhandlers' is marked as crashed and should be repaired
191028 17:10:23 [Warning] Checking table:   './nagios/nagios_eventhandlers'
191028 17:10:23 [ERROR] mysqld: Table './nagios/nagios_customvariablestatus' is marked as crashed and should be repaired
191028 17:10:23 [Warning] Checking table:   './nagios/nagios_customvariablestatus'
191107 18:05:49 [Note] /usr/libexec/mysqld: Normal shutdown
191107 18:05:49 [Note] Event Scheduler: Purging the queue. 0 events
191107 18:05:49  InnoDB: Starting shutdown...
191107 18:05:50  InnoDB: Waiting for 58 pages to be flushed
191107 18:05:51  InnoDB: Shutdown completed; log sequence number 8290103823
191107 18:05:51 [Note] /usr/libexec/mysqld: Shutdown complete

191107 18:05:51 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
191107 18:44:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
191107 18:44:32 [Note] /usr/libexec/mysqld (mysqld 5.5.64-MariaDB) starting as process 2304 ...
191107 18:44:35 InnoDB: The InnoDB memory heap is disabled
191107 18:44:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
191107 18:44:35 InnoDB: Compressed tables use zlib 1.2.7
191107 18:44:35 InnoDB: Using Linux native AIO
191107 18:44:35 InnoDB: Initializing buffer pool, size = 128.0M
191107 18:44:35 InnoDB: Completed initialization of buffer pool
191107 18:44:35 InnoDB: highest supported file format is Barracuda.
191107 18:44:35  InnoDB: Waiting for the background threads to start
191107 18:44:36 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 8290103823
191107 18:44:36 [Note] Plugin 'FEEDBACK' is disabled.
191107 18:44:36 [Note] Server socket created on IP: '0.0.0.0'.
191107 18:44:36 [Note] Event Scheduler: Loaded 0 events
191107 18:44:36 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

[benjaminsmith]

Hi,

Thank you. That looks normal. Let me know if you need further assistance or if it's ok to close out this thread.

Benjamin

[fsodah]

Please close the ticket.

[scottwilkerson]

Please close the ticket.

Great!

Locking thread