> InnoDB 4682006528 3599335424 8281341952
So all InnoDB ops in RAN needs innodb_buffer_pool_size=8GB, plus somefor growth.
> I guess I'd need to use the slow query log for those, right?
Yes.
>> 3 Nearly a thousand hrs between InnoDB log rotations is way too lomg
> Isn't that done automatically when needed? I'll lookup how to do it.
Best adjust log size such that it rotates every 30-60 mins,
https://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/
> didn't try to lower the swappiness,
Right, first get swap use down to
zero.
What do the mysql log and syslog say when that db size query crashes the server?
How much RAM is the app using? Other processes?