Unsual (WP_Post) Table Size in my SQL Database

  • Resolved lexjunkie

    (@lexjunkie)


    4 years, 3 months ago

    Hi,
    Please help !
    I am still in the designing phase of my website and i noticed today that my (WP_Post) Table has swelled up to about 45 MB. My host currently allows 50 MB limit.

    I am concerned as to why did this happen when i have ZERO POSTS and ZERO COMMENTS with just 13 PAGES.

    I tired clearing and optimizing my Database with WP DB Cleaner Plugin. It cleaned but the size did not shrink.

    I also ran sql query to delete the revision posts.

    Kindly help ! I don’t wish to delete my WordPress installation and start over AGAIN.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter lexjunkie

    (@lexjunkie)

    ” 21. wp_postmeta TABLE OPTIMIZED MyISAM 523 960.2 KB
    22. wp_posts TABLE OPTIMIZED MyISAM 70 45.6 MB ”

    Table has only 70 rows.

    Hi, @lexjunkie!

    You can try using this plugin

    https://www.ads-software.com/plugins/wp-reset/

    as there is definitely something wrong with the database. You should first backup your database in case anything goes wrong. This plugin will delete:

    • all posts, pages, custom post types, comments, media entries, users
    • all default WP database tables
    • all custom database tables that have the same prefix table prefix as the one defined in wp-config.php and used by default tables

    You might also want to scan your wp with a security plugin (such as Wordfence) for malware if size keeps increasing.

    Hope this helps.
    Kind regards,
    Vlad.

    You can also manually scan wp_posts table for unusual content.

    Also check for custom post types – maybe there are many of those.

    If nothing helps, maybe a fresh installation is the better option.

    Thread Starter lexjunkie

    (@lexjunkie)

    Thank You for your time Vlad.
    After putting in a few hours i figured that elementor templates were causing the issue.
    After i deleted them everything went back to normal.
    Regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Unsual (WP_Post) Table Size in my SQL Database’ is closed to new replies.