Reloading MySQL databases

compared with
Current by Groundwork Support
on Nov 03, 2011 16:33.

This line was removed.
This word was removed. This word was added.
This line was added.

Changes (1)

View Page History
When you delete data from MySQL the ibdata1 file never shrinks. This can be a problem if you delay in implementing a data retention policy.

The ibdata1 file grows to a very large size causing performance & ?potentially and potentially other database problems in GroundWork. To deal with these problems you must implement a data retention policy and trim a lot of records from the database, but the filesize of the ibdata1 file does not shrink.

h3. Solution: