WordPress.org

1. wcosshall
   Member
   Posted 4 weeks ago #

   Hi All,

   I've been getting progressively worse sql errors on my WP 2.8.5 site dimagemaker.com. Some of these are from a few of the plugins but most are queries to do with the posts table. An example is below:

   # Sat Oct 31 04:20:45 2009
   # Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
   SELECT *,
   TABLE_SCHEMA AS Db,
   TABLE_NAME AS Name,
   ENGINE AS Engine,
   ENGINE AS Type,
   VERSION AS Version,
   ROW_FORMAT AS Row_format,
   TABLE_ROWS AS Rows,
   AVG_ROW_LENGTH AS Avg_row_length,
   DATA_LENGTH AS Data_length,
   MAX_DATA_LENGTH AS Max_data_length,
   INDEX_LENGTH AS Index_length,
   DATA_FREE AS Data_free,
   AUTO_INCREMENT AS Auto_increment,
   CREATE_TIME AS Create_time,
   UPDATE_TIME AS Update_time,
   CHECK_TIME AS Check_time,
   TABLE_COLLATION AS Collation,
   CHECKSUM AS Checksum,
   CREATE_OPTIONS AS Create_options,
   TABLE_COMMENT AS Comment
   FROM information_schema.TABLES
   WHERE BINARY TABLE_SCHEMA IN ('xyz_wp01')
   LIMIT 250 OFFSET 0

   # Sat Oct 31 04:20:45 2009
   # Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
   use xyz_wp01;
   SELECT *,
   TABLE_SCHEMA AS Db,
   TABLE_NAME AS Name,
   ENGINE AS Engine,
   ENGINE AS Type,
   VERSION AS Version,
   ROW_FORMAT AS Row_format,
   TABLE_ROWS AS Rows,
   AVG_ROW_LENGTH AS Avg_row_length,
   DATA_LENGTH AS Data_length,
   MAX_DATA_LENGTH AS Max_data_length,
   INDEX_LENGTH AS Index_length,
   DATA_FREE AS Data_free,
   AUTO_INCREMENT AS Auto_increment,
   CREATE_TIME AS Create_time,
   UPDATE_TIME AS Update_time,
   CHECK_TIME AS Check_time,
   TABLE_COLLATION AS Collation,
   CHECKSUM AS Checksum,
   CREATE_OPTIONS AS Create_options,
   TABLE_COMMENT AS Comment
   FROM information_schema.TABLES
   WHERE BINARY TABLE_SCHEMA IN ('xyz_wp01')
   LIMIT 250 OFFSET 0

   # Sat Oct 31 04:21:50 2009
   # Query_time: 4 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
   SELECT * FROM xyz_wp01.abc_redirection_logs

   and

   # Thu Oct 29 02:10:56 2009
   # Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
   use xyz_wp01;
   DELETE FROM abc_redirection_logs WHERE created < DATE_SUB(NOW(), INTERVAL 30 DAY)

   Now my concern is whether these are a real issue or whether the fact that the server is showing with a load of 11.24 commonly and a mysql (5.0.81-community-log) Fail on the server status is really the issue.

   Any help would be appreciated. The hosting companies (Blue Host) tech support is suggesting I need an sql specialist to sort out the queries.

   Cheers,

   Wayne

2. wordprest
   Member
   Posted 4 weeks ago #

   when that issue came out?

3. wcosshall
   Member
   Posted 4 weeks ago #

   There have been mysql issues logged since February but it really seemed to pick up about a month ago.

4. wordprest
   Member
   Posted 4 weeks ago #

   when exactly this appear?
   and the site? does it work properly?

5. wcosshall
   Member
   Posted 4 weeks ago #

   It started Feb 12th

   Site works fine. The hosting company has been throttling the account at times because they claim his CPU loads from this blog for the last month. I did have one strange episode a month back with a comment that I couldn't delete without using phpMyAdmin, but aside form that the site is working fine.

6. wordprest
   Member
   Posted 4 weeks ago #

   Did you reach space usage limits?

7. bh_WP_fan
   Member
   Posted 4 weeks ago #

   The given queries in and of themselves are not too bad. Several of them combined could definitely cause issues. If they keep happening, then that's where it starts to be a problem. Either way, some optimizing is always a good thing. There are several good optimization tips on the WordPress forums here that would be worth browsing through. Also read and do the steps in the following article: http://wordpress.shadowlantern.com/?p=7

8. wcosshall
   Member
   Posted 4 weeks ago #

   No, I didn't hit space usage limits. Far from it.

   Thanks re the optimization tips. I'll do a search in the forums and work through the ones in the article. Much appreciated.

Reply

You must log in to post.