WordPress.org

Ready to get started?Download WordPress

Forums

Mysql Errors (8 posts)

  1. wcosshall
    Member
    Posted 4 years 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 years ago #

    when that issue came out?

  3. wcosshall
    Member
    Posted 4 years 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 years ago #

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

  5. wcosshall
    Member
    Posted 4 years 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 years ago #

    Did you reach space usage limits?

  7. bh_WP_fan
    Member
    Posted 4 years 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 years 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.

Topic Closed

This topic has been closed to new replies.

About this Topic