WordPress.org

Ready to get started?Download WordPress

Forums

More number of records in wp_options table (1 post)

  1. k.senthilcoumar
    Member
    Posted 4 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic