Hello,
For some reason my MariaDB is not responding (so all sites in the server are not responding either). I have rebooted the server and form the mysql status I get:
2-17 19:44:47 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Uses event mutexes
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Number of pools: 1
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Initializing buffer pool, total size = 1.5G, instances = 3, chunk size = 128M
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See
Feb 17 19:44:47 wpress01 mysqld[1292]: 2020-02-17 19:44:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=92684204824
Feb 17 19:45:02 wpress01 mysqld[1292]: 2020-02-17 19:45:02 0 [Note] InnoDB: Read redo log up to LSN=92684205056
And then it never comes out of "[Note] InnoDB: Read redo log up to LSN=92684205056" (at least for 2 hours.
Top shows the mysql process consuming the 100% of the CPU, but I don't thing "[Note] InnoDB: Read redo log up to LSN=92684205056" is something that should take so long. Right?
I do have backups but I'd rather recover the DB to the latest state. Any advice? Should I just wait? (is having "[Note] InnoDB: Read redo log up to LSN=92684205056" for more than 2 hours is expected?)
Thanks