Re: mysql 8.0.27 went crash

[Peter Brawley]

Not sure why your posts triggered the approval switch.

It's a busy, underpowered system.

> > Slow queries/sec 0
Turn on the slow query log, optimise the slowest queries.

> Full table scans/sec 240.63
> Table scan next row seeks/sec 138037.52
These numbers indicate there are many slow queries where MySQL can't find suitable indexes, ie the queries need optimisation including covering indexes.

> Total InnoDB load / buffer pool size 14.23
InnoDB load is 14 times the buffer pool size. Unsustainable. Until you can arrange for more RAM, bump innodb_buffer_pool_size to 24GB. If it's my system with this load, I want 128GB RAM, buffer pool about 100GB.

> Mins between InnoDB log rotation 4.91
Best is about 30 mins, change settings accordingly.