> I have tried twice again to execute the query you gave me, during the night
> after a fresh database restart, but still both times the database crashed.
Need to see what the mysql error log says about that.
> What I can say about the server being overloaded, is that it currently hosts
> a multitenant application in which each database is copied, under a different
> name, for each different customer.
Still missing something big ...
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21542 mysql 20 0 28.9g 14.5g 1980 S 0.0 93.5 2:20.33 mysqld
MySQL claiming 29G of virtual mem whilst asleep, yikes, and I've not been able to find what is doing that. Just a hunch, did you try turning off performance_schema?
> we do not use the Aria storage engine
Then innodb_buffer_pool_size should be 70-75% of RAM available to MySQL.
Edited 1 time(s). Last edit at 03/14/2019 10:56AM by Peter Brawley.