I am trying to diagnose some performance issues, and I have no idea if our current, ridiculous MySQL server load is normal...
With less that 10 people on the front end, no-one on the backend, and all cronjobs disabled, we are averaging 1000 queries per second. That's with NGINX and Apache, NGINX caching and Redis, behind a CDN.
To check this, I have enabled the MySQL general log for approx 30 seconds
SET GLOBAL general_log = 1;
SET GLOBAL log_output = 'table';
And then look at the results of
SELECT DATE_FORMAT(event_time,'%H:%i:%s'), COUNT(*) FROM general_log GROUP BY DATE_FORMAT(event_time,'%H:%i:%s')
Average is about 1000, fluctuating from 10 to 2500 queries in a single second. With my software developer hat on, this is ridiculous, but is it normal for Magento?
