mysql 8.0: "No tables are Innodb", innodb_buffer_pool data size = 0B

donko

hello i have a problem with cpanel and mysql 8.0.

i had high CPU usage issues then i did lot of changes to my.cnf file now after restart i notice there are still a little high load average and now mysql tunner says this

[!!] No tables are Innodb
[OK] InnoDB buffer pool / data size: 32.0G / 0B

i don't understand why my innodb buffer pool is at 0B, earlier it was 48GB aprox

i tried restarting and placing default my.cnf but nothing happen

mysqltunner

-------- InnoDB Metrics ---------------
[--] InnoDB is enabled.
[!!] No tables are Innodb
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB Buffer Pool size ( 32.0G ) under limit for 64 bits architecture: (17179869184.0G )
[OK] InnoDB buffer pool / data size: 32.0G / 0B
[OK] Ratio InnoDB Redo Log Capacity / InnoDB Buffer pool size: 100.0M/32.0G should be equal to 25%
[OK] InnoDB buffer pool instances: 32
[--] Number of InnoDB Buffer Pool Chunk: 256 for 32 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 100.00% (74235732396 hits / 74237270435 total)
[!!] InnoDB Write Log efficiency: 69.31% (6657598 hits / 9605687 total)
[OK] InnoDB log waits: 0.00% (0 waits / 2948089 writes)

my.cnf

https://pastebin.mozilla.org/ADrqm1FM

ScreenReader

what's the output of SHOW TABLE STATUS; ?

if there's a high cpu usage you should check the mysql logs too. high unlikely this is a simple problem like permission/ownership problem

Levi

Your fucked. This means that you have no innodb index table or it is corrupted. Try to fix, if not, press disasster recovery button.

WebProject

@LTniger said:
Your fucked. This means that you have no innodb index table or it is corrupted. Try to fix, if not, press disasster recovery button.

It’s sounds corrupted, 48Gb of database, it’s big database so I hope OP has backup

donko

before some investigation i found something related to my issue in this link https://groups.google.com/g/percona-discussion/c/YRoM4g4NjAM

this mades me think that i don't have any corruption

but i still found weird that there is no memory allocation in to the innodb_buffer_pool value

my show engine innodb status

---

BUFFER POOL AND MEMORY

Total large memory allocated 0
Dictionary memory allocated 32614628
Buffer pool size 3145446
Free buffers 2062616
Database pages 1035544
Old database pages 383194
Modified db pages 2613
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 142, not young 0
0.12 youngs/s, 0.00 non-youngs/s
Pages read 1033930, created 1614, written 57729
388.75 reads/s, 0.12 creates/s, 42.86 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 225.67/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1035544, unzip_LRU len: 0

I/O sum[0]:cur[144], unzip sum[0]:cur[0]