illegalprelude

I noticed I’m getting quite a bit of this in MySQL logs:

/home7/sonyrumo/tmp/mysql_slow_queries/20120217-15.log
# Fri Feb 17 15:58:27 2012
# Query_time: 3.432624 Lock_time: 0.001020 Rows_sent: 16 Rows_examined: 80
use sonyrumo_wrd1;
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’, ‘author’) AND tr.object_id IN (3009) ORDER BY t.name ASC

With query times over 2 seconds. Could this be the cause?

No. It’s far more likely that the server you are using is now over-loaded. Try speaking to your hosts about this.

Hey esmi, thanks for the quick response. I use Bluehost as my host so should I be investigating anything particular? The site isn’t hitting any kind of peak traffic so that cannot be the cause of it. I’ve had the site have triple the traffic in a day and not receive an error.

However, if you believe that it can be caused by an overload which is probable, where/what should I be looking/asking for?

I’m wondering the same thing

bump?