wp_options is GB in size

by

After executing these:

[root@shop ~]# mysqlcheck -p -c wordpress hihgv_options
wordpress.hihgv_options                            OK
[root@shop ~]# mysqlcheck -p -o wordpress hihgv_options
wordpress.hihgv_options
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK
[root@shop ~]# mysqlcheck -p -a wordpress hihgv_options
wordpress.hihgv_options                            OK

Size is down to 1.6MB, not sure if it was optimize because I’ve done that before from HeidiSQL with no change at all.

Edit:
Also the SQL queries from OP still return the same numbers.

Edit 2:
Just did it again, after executing:


[root@shop wordpress]# mysqlcheck -p -o wordpress wp_options
note : Table does not support optimize, doing recreate + analyze instead
status : OK

It went from 3.9GB to 10MB.
If anyone knows exactly why I’d appreciate an explanation.

Leave a Comment