I've got MariaDB instance in the cloud which I put live about 2 months ago. I'm new to the DBA business and I got the impression the people at the company who I run it through are learning on the hoof as well.
All is going well except that I saw CPU utilisation spiked on Tuesday to 95% for now apparent reason.
I requested performance stats after a user complained of a long running query. It turns out they were doing regular hourly queries on unindexed fields and the table scans involved suddenly took a lot longer. I am now looking at indexing this column so they can run their queries faster.
I'd like to know whether their queries could be the cause of the CPU utilisation, or whether whatever caused the CPU utilisation had just grabbed all the cache and caused their table scanning query to suddenly take far longer.
What should I be doing to capture information that will show what is going on and why the CPU utilisation spiked, and if it's a concern?
and the only other chart that correlated with it:
The scales on the chart are probably the key, right?
The other charts provided (database connections, write IOPS, disk queue depth) didn't show any correlation.
I'm also puzzled why the normal pattern has totally changed. The usage is around a million queries per day, and has been for 2 months now.