• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Issue high SQL cpu and possible slowlog issue?

Just set query_cache_size to 0 and check if it performs better.
And your application should cache results locally instead of performing expensive queries again and again. Checking whether those queries make use of indexes would be a good idea too. (magento2 fails both)
im really stuck how to update this to 0. - could you help?
 
Yeah. it seems to me like you'd be better off disabling QC.

Just put:

query_cache_size=0

in your my.cnf file that you found with Peter's help.

Some more details: How to Fully Disable Query Cache in MySQL - Percona Database Performance Blog
Thanks alot. This guide helped me. Now i see this so ill give it a test

+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
+-------------------------+-------+

Could you help me understand and fix this error?
AH01067: Failed to read FastCGI header, referer: ....
(104)Connection reset by peer: AH01075: Error dispatching request to : , referer: ....
 
Back
Top