Optimizing some queries

  • Hello,

    My hosting company is asking frequently to optimize my website which is using WordPress because it’s “overloading” the server. If I won’t fix this issue, they will have to put it on a “quarantine server”. I’m checking everyday my slow logs and I’m having always the same thing (I guess). I removed from the DB all tables created by uninstalled plugins. I removed also all the plugin that are overloading the server with queries. I’m also using a cache plugin. These steps were good but not that enough since I still have some slow queries in the log file. Anyway, here the slowlog:

    # Time: 131205 22:35:33
# User@Host: XXXXXX[XXXXXX] @ XXXXXX [XXXXXX]
# Query_time: 6.183516  Lock_time: 0.000159 Rows_sent: 379  Rows_examined: 421
use XXXXXX;
SET timestamp=1386279333;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 131205 22:36:33
# User@Host: XXXXXX[XXXXXX] @ XXXXXX [XXXXXX]
# Query_time: 61.768671  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
use XXXXXX;
SET timestamp=1386279393;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 131205 22:37:03
# User@Host: XXXXXX[XXXXXX] @ XXXXXX [XXXXXX]
# Query_time: 93.286015  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
use XXXXXX;
SET timestamp=1386279423;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 131205 22:37:03
# User@Host: XXXXXX[XXXXXX] @ XXXXXX [XXXXXX]
# Query_time: 95.438348  Lock_time: 5.071881 Rows_sent: 0  Rows_examined: 1
SET timestamp=1386279423;
DELETE FROM wp_options WHERE option_name = 'rewrite_rules';
# Time: 131205 22:37:15
# User@Host: XXXXXX[XXXXXX] @ XXXXXX [XXXXXX]
# Query_time: 32.109220  Lock_time: 20.174740 Rows_sent: 378  Rows_examined: 420
use XXXXXX;
SET timestamp=1386279435;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';

    Can someone help me figure out what’s going wrong and what is taking so much time to be done?
    Thanks guys!

Viewing 3 replies - 1 through 3 (of 3 total)

  • Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the default theme to rule out any theme-specific problems.

    – resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

    Thread Starter heddo

    (@heddo)

    Hello esmi,

    Thanks for the reply.
    When I deactivate all the plugins, how much time I should wait to see if this resolves the problem?
    Is there any plugin to check if the theme is causing this? Turning my site to the default will ruin it and it’s busy these days on my site :/
    Thanks again.

    There is no magic bullet in these situations. This is just the start of basic troubleshooting and is a process of elimination deliberately designed to locate the root cause as quickly as possible by first removing the most obvious and common culprits via a series of (often) temporary steps.

    Your theme & plugin settings are saved in your database and should be retained for future use.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Optimizing some queries’ is closed to new replies.