Freeing up MySQL Database Memory
I mass deleted 250,000 unapproved comments via phpMyAdmin as I am unable to upload new content in Wordpress due to reaching my db memory limit.
Unfortunately I didn't check the size of wp_comments prior to deletion but despite only having a few hundred genuine comments left the size displayed is over 500mb which doesn't seem right, plus after deleting a few genuine comments that number hasn't changed.
Is there a period of time I need to wait before that deletion takes effect, or is there something else I'm missing?
Also, can I delete the wp_commentmeta table that has tens of thousands of pages of askimet failed comment check reports without jeopardising anything? as that takes 300mb too! Thanks for any help
EDIT - After further research it seems that merely deleting spam doesn't actually free up rows in the table until it has been optimised, which sods law, phpMyAdmin doesn't seem to be letting me do for some unknown reason.
Unfortunately I didn't check the size of wp_comments prior to deletion but despite only having a few hundred genuine comments left the size displayed is over 500mb which doesn't seem right, plus after deleting a few genuine comments that number hasn't changed.
Is there a period of time I need to wait before that deletion takes effect, or is there something else I'm missing?
Also, can I delete the wp_commentmeta table that has tens of thousands of pages of askimet failed comment check reports without jeopardising anything? as that takes 300mb too! Thanks for any help
EDIT - After further research it seems that merely deleting spam doesn't actually free up rows in the table until it has been optimised, which sods law, phpMyAdmin doesn't seem to be letting me do for some unknown reason.