Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Livecycle database maintenance


Level 1

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:-

-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

0 Replies