Is your host reporting problems?
Also, please list all plugins being used.
Thread Starter
earcos
(@earcos)
– Akismet
– Customizable post listings
– Democracy
– Markdown
– Smartypants
– sSend2Friend
– Feedburner feed replacement
– Related posts
– WP-Cache
– Weighted Categories
– Search Hilite
– Database backup
well, first, looks like multiple big selects per pageload potentially. Could be related-posts or customizable post listings or something. Things like recent posts or related posts can either be cached or otherwise optimized to not impact things.
second, Mint is obviously doing inserts on visits. My own CG-Referrer tracking library does something similar, so I know that it both has impact AND can be done and not kill a decent shared box.
My guess is that some of the plugins could be caching results either on a timed check or on hooks into new posts/comments and update only at those points.
Without knowing what queries are causing the load issues, what queries are being hit in a given visit, really hard to look at a long list of queries and tell much more than the above. 😉
-d
Thread Starter
earcos
(@earcos)
Seems Customizable post listings was the culprit. Thanks a lot.
