Hi
google hosting. ssd drivers. 4 core xeon. 16gb mem. 60 ppl com to site & sql completle down site. plz look https://www.dropbox.com/s/ub5zog4485wggcp/Screenshot%202019-02-23%2021.22.28.png?dl=0
Can you give me some advice??
SQL_CALC_FOUND_ROWS did this.
https://www.dropbox.com/s/9ofl5x2x4x3mfn3/Screenshot%202019-02-24%2003.13.10.png?dl=0
any advice?
a lot of taxonomy & posts.
Google cloud. 8vcpu.60gb memory. ssd. php7.0/opcache/w3total cache/memcached/nginx
& 60 users online i i got this 100% cpu load https://www.dropbox.com/s/qxjd6pm4h3kyxh8/Screenshot%202019-02-24%2019.44.19.png?dl=0
its ridiculous. i have a lot of high load wordpress sites but this i see first time…Can you help me?
Little bit investigation, seems to be query like this kill all :
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1
AND ( wp_term_relationships.term_taxonomy_id IN (44) )
AND wp_posts.post_type = ‘post’
AND ((wp_posts.post_status = ‘publish’))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 5
Hi,
Please keep in mind that we only use the default WordPress function wp_query() and also, we do not make any SQL Select for pagination, sorry! To improve your site performance you can try to reduce the number of queries (fewer blocks on the page, reduce the elements which use ajax requests/pagination like mega menus/load more/infinite load). By removing the ajax drop-down filter, content preloading and ajax pagination: http://screencast.com/t/gG1jdJsjT – http://screencast.com/t/NkM3ldIDEqY the number of queries it will be significantly reduced. Also, consider using a cache plugin and to improve the loading speed look the MySQL query cache: http://dev.mysql.com/doc/refman/5.1/en/query-cache.html We also use it on our demo. If you haven’t already, you can try a caching plugin, like WP Super Cache or Cloudflare CDN.
Thanks for your understanding!
Also, consider using a cache plugin and to improve the loading speed look the MySQL query cache: http://dev.mysql.com/doc/refman/5.1/en/query-cache.html
Not help this link 🙂 https://www.dropbox.com/s/wpbqz429ft0ytjb/Screenshot%202019-02-25%2015.05.07.png?dl=0
Can you be more specific how you use & what to cache query in mysql.
I disabled almost all…..
I am use cloudflare pro + zend cache. w3 total. its not helps much with problem with mysql. I try tune mysql query cache if you send here more details. Tnx.
Hi,
It seems that the link does not work, sorry! You can read more about query cache here -> https://www.percona.com/blog/2015/01/02/the-mysql-query-cache-how-it-works-and-workload-impacts-both-good-and-bad/ and here -> https://dev.mysql.com/doc/refman/5.7/en/query-cache.html Also, our caching recommended plugin is WP Super Cache plugin.
Thanks for your understanding!
