WordPress.org

Support

Support » How-To and Troubleshooting » More number of records in wp_options table

More number of records in wp_options table

  • Hi, Im looking for some help with my wp_options table.

    recently I noticed more than twenty thousand of lines in the table.

    Query Details:

    SELECT COUNT(1) FROM wp_options WHERE option_name=’cron’;

    +———-+
    | COUNT(1) |
    +———-+
    | 11632 |
    +———-+
    1 row in set (0.01 sec)

    SELECT COUNT(1) FROM wp_options WHERE option_name=’_transient_update_core’;
    +———-+
    | COUNT(1) |
    +———-+
    | 4465 |
    +———-+
    1 row in set (0.01 sec)

    SELECT COUNT(1) FROM wp_options WHERE option_name=’_transient_update_plugins’;
    +———-+
    | COUNT(1) |
    +———-+
    | 4463 |
    +———-+
    1 row in set (0.00 sec)

    SELECT COUNT(1) FROM wp_options WHERE option_name=’_transient_update_themes’;
    +———-+
    | COUNT(1) |
    +———-+
    | 4463 |
    +———-+
    1 row in set (0.00 sec)

    Due to these huge number of rows,web pages are not loading.

    WordPress Version:2.8.1

    Can anyone help me to sort this issue

    Regards,
    Coumar

  • The topic ‘More number of records in wp_options table’ is closed to new replies.
Skip to toolbar