Taxonomy Error Slowing Site –

Posted in: Newsmag
Post count: 21
keypractices
#40921
Mar 11, 2015 at 1:18 am

Hi there, it seems that the error

# Tue Mar 10 17:00:05 2015
# Thread_id: 1639025 Schema: redcarp8_wrd3 Last_errno: 0 Killed: 0
# Query_time: 1.498023 Lock_time: 0.000180 Rows_sent: 22716 Rows_examined: 67993 Rows_affected: 0 Rows_read: 67993
# Bytes_sent: 1649559
use redcarp8_wrd3;
SET timestamp=1426028405;
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’) ORDER BY t.name ASC

is creating a HUGE slowdown of my site – I have essentially deleted most or all of the plugins and my site had degraded daily – spent hours with my hosting site on tech and they tell me it is the site theme.

Please – please – please help. They are threatening to close my site due to the overhead this is causing

http://www.redcarpetreporttv.com

  • This topic was modified 11 years by keypractices. Reason: forgot URL
  • This topic was modified 11 years by keypractices.
Post count: 1291
Emil G
#41022
Mar 11, 2015 at 3:27 pm

Hi,

The theme doesn’t have direct queries on the database, all queries are made trough wordpress. This may appear do to a large number of categories or tags.
Try to repair the database, check this guide – http://www.maketecheasier.com/fix-corrupted-wordpress-database-2/
Before doing this backup the database.

Thank you, Emil G.

Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic.