I'd be interested to know if anyone else has had to make changes to their MySQL config or has advice on
livecycle db maintenance.
Here are some of our largest tables:-
/var/lib/mysql/adobe
-rw-rw---- 1 mysql mysql 32M Jan 22 2010 tb_sc_archive.MYD
-rw-rw---- 1 mysql mysql 416M Oct 19 16:09 EDCREVOKATIONENTITY.ibd
-rw-rw---- 1 mysql mysql 560M Oct 19 16:09 EDCPOLICYENTITY.ibd
-rw-rw---- 1 mysql mysql 2.2G Oct 19 16:09 EDCPOLICYXMLENTITY.ibd
-rw-rw---- 1 mysql mysql 2.4G Oct 19 16:09 EDCPOLICYARCHIVEENTITY.ibd
-rw-rw---- 1 mysql mysql 5.7G Oct 19 16:08 tb_job_instance.MYD
-rw-rw---- 1 mysql mysql 5.9G Oct 19 16:12 ibdata1
The only maintenance I have run is to run this check:-
/usr/bin/mysqlcheck --all-databases --check --auto-repair --optimize