Issue high SQL cpu and possible slowlog issue?

[Coopsy]

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?

 

[weltonw]

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

 

[Coopsy]

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: ....

 

[weltonw]

That is a pretty generic PHP error message. Looks like it timed out.