SQL High CPU usage error

[ecartz]

Almost every single log entry says "Waiting for table flush". Looking that up I find

https://stackoverflow.com/q/50949417/6660678
https://stackoverflow.com/a/73835892/6660678
https://stackoverflow.com/a/13155778/6660678
https://stackoverflow.com/a/37312413/6660678
https://shatteredsilicon.net/mysql-mari ... ble-flush/

Which gets us back to what Burt said in the first place: your host is screwing things up. CE Phoenix Cart does not flush or analyze tables in normal operation. If this is happening regularly, then it's your host doing it. This is the kind of thing that gets done when taking a database backup or generating usage statistics.

How do we know it's the host? Simple. The logs show no instances of ANALYZE or FLUSH being called. This tells us that your user is not calling it. If it's not your user, it has to be the host.

[radhavallabh]

Almost every single log entry says "Waiting for table flush". Looking that up I find

https://stackoverflow.com/q/50949417/6660678
https://stackoverflow.com/a/73835892/6660678
https://stackoverflow.com/a/13155778/6660678
https://stackoverflow.com/a/37312413/6660678
https://shatteredsilicon.net/mysql-mari ... ble-flush/

Which gets us back to what Burt said in the first place: your host is screwing things up. CE Phoenix Cart does not flush or analyze tables in normal operation. If this is happening regularly, then it's your host doing it. This is the kind of thing that gets done when taking a database backup or generating usage statistics.

How do we know it's the host? Simple. The logs show no instances of ANALYZE or FLUSH being called. This tells us that your user is not calling it. If it's not your user, it has to be the host.

Understood dear, So shall take step forward towards changing them.
One more thing then in cPanel we are not allowed to login to phpmyadmin with our database user. A master user is set for all databases by default. I even confirmed with A2 hosting even they have the same for their cPanel. Even the SQL logs cannot be accessed by us directly on the hosting I have.
So how to check the processes in real time run by the users we have created on the database?
For In case there is any stuck queries by our created users??

Please can you help me with this too? I could then easily decide which host to go with and how to go about it.

Thank you so much for your valuable guidance;
Very warm Regds./
radhavallabh
I order to check if any query was stuck or not.