MySQL 4.0 Server: wp_options table Overhead

  • cfcoder2

    (@cfcoder2)


    19 years ago

    My WP v1.5 suddenly refused to let me post or edit to my blog. I first thought it was WP so I went into MySQLAdmin and tried to edit there, only to find that it too would not post or edit. Well, I could make a small test posting but it refused to let me edit it, not even the category or post date or content.

    After much time playing around trying to figure out what was going on, checking for corrupt tables, checking the wp_post2cat and wp_post and wp_categories tables and finding nothing amiss, I eventually noticed in MySQLAdmin that the wp_options table had a Overhead value that was like 200k+ in size and in red text. I don’t know what this means. It had a Optimize link beside it so I clicked it, making the Overhead line dissappear. It didn’t immediately fix the problem I was having but that was last night. Today the problem has vanished…I can post again in WP, edit, change post dates, content, categories, etc.

    What was that all about? Can anyone explain? Hopefully this helps someone else out.

Viewing 1 replies (of 1 total)
  • MichaelH

    (@michaelh)

    Interesting question. I checked four WordPress blogs and found all four, in phpMyAdmin, under Structure, Space usage, presented Overhead in red. One was 3,000 bytes, 4,708 bytes, and 132,140 bytes, and 110,360 bytes. In all four cases after clicking Optimize Table the ‘Overhead’ no longer displayed.

    Two of those blogs are just test blogs with no traffic. In none of those cases, do I experience the problem you saw.

    So, based on doing a little searching with space+usage+overhead+phpmyadmin, I found there are a number of reasons (e.g. types of data in a table, amount of free or wasted space in a field) for the red Overhead information. I even read it could be that the tables might have been “poorly created” (whatever that means).

    The Bottom line is you might have had a host related problem that has nothing to do with the Overhead. But, doing the Optimize Table is the recommended procedure when you do see those red numbers.

    Maybe your host or logs might have something to report…

    Let us know.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL 4.0 Server: wp_options table Overhead’ is closed to new replies.

Tags