Support » Fixing WordPress » wp_comments db overhead

  • Resolved dirkhaim


    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?


Viewing 1 replies (of 1 total)
  • 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.

Viewing 1 replies (of 1 total)
  • The topic ‘wp_comments db overhead’ is closed to new replies.