High MySQL usage after upgrade to 10.3.1

[dmcubed]

After I upgraded from 10.1 to 10.3.1 I started to get health warnings about high MySQL CPU usage with no increase in site traffic. I have a number of questions.

1. What is SYSTEM TIME (the green part of the chart)? Since the upgrade this is now 40 to 50 times more than the user time (red part). Before the upgrade they were about the same.

2. Is there a bug that anyone knows about?

3. Is plesk causing this issue by trying to monitor and record too much information?

Thanks,

David

 

[EdwardDekker]

Check your logs!

/var/log/mysqld.log
/var/log/messages
/var/log/secure

 

[dmcubed]

Can I get to the logs via Plesk? What are the menu picks? I don't have root access to my server to load them directly (part of the support contract!).

 

[EdwardDekker]

Can I get to the logs via Plesk? What are the menu picks? I don't have root access to my server to load them directly (part of the support contract!).

Get a SSH connection to your webserver.

If you don't have access then you could get this by selecting a "tcsh" or "sh" shell into your domain preferences. Do not selecting a crooted environment. Than you can't see anything at your web-server (Your server creates a secured environment by a crooted shell)
Be aware that you are not have the full rights as root, but you can try only read some files by typing "sudo 'execute commando'".

Read also "man sudo" at your web-server.

- Linux commands at your client, or (download and) use Putty for Windows based systems:

ssh -p 22 [email protected]

Put then this at you command-line to watch your log-files:

sudo less /var/log/messages
sudo less /var/log/secure
sudo less /var/log/mysqld.log

By typing "sudo ls -aclh /var/log/" can you actually see all log-files.