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)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘Optimizing some queries’ is closed to new replies.