WordPress.org

Forums

[resolved] wp_comments db overhead (2 posts)

  1. dirkhaim
    Member
    Posted 7 years ago #

    Looking at my MYSQL server I can see that wp_comments is huge (over 10MB), and I don't have that much comments, so I gather that somehow it keeps the spam. It has a overhead of around 9.5MB, what ever this overhead means.

    anyway I can reduce the size of this monster to its real size?

    Thanks

  2. dirkhaim
    Member
    Posted 7 years ago #

    ok, got it:

    OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.

Topic Closed

This topic has been closed to new replies.

About this Topic