Hi guys,
since yesterday morning i suddenly see a huge delay in pages loading.
I didn’t change anything to configuration of Apache.
Using VPS and LAMP.
Struggling to identify all day and night long yesterday what is happening…
[url=https://www.webpagetest.org/result/171009_18_be13a9f5d173df1b0b59d32e981aa8e1/1/details/]https://www.webpagetest.org/result/171009_18_be13a9f5d173df1b0b59d32e981aa8e1/1/details/[/url]
Do you have an idea or please give a hint?
mysqltunner gave:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
query_cache_size (> 16M)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)