I have a bunch of tables (InnoDB) within several databases (MySQL 8), that I run Garbage Collect scripts on, on daily basis, removing stale records that are no longer needed. All tables do have indexes on them.
Would it make sense / be at all beneficial to optimize all tables, say every week, to increase performance? If so, is there are good command to run, to do so?
I tried doing
sudo mysqlcheck -o --all-databases
But get the following error message:
note : Table does not support optimize, doing recreate + analyze instead status : OK