what data is removed during DEFRAG

[Rinse Lemstra]

My databases (mvstore) are growing rapidly, much more than I would expect based on the entered data. I also see CPU usage increasing.

Performing a DEFRAG reduces the database size significantly, sometimes by 60-70%. Running SCRIPT TO / RUNSCRIPT also has a similar effect.

How can I identify what 'pollution' is consuming so much space? Browsing through the INFORMATION_SCHEMA has not provided any clues.

We recently started using "CREATE MEMORY LOCAL TEMPORARY TABLE IF NOT EXISTS" more frequently. Could this be related to the problem?

[Andrei Tokar]

Plaese see nice recent message here. I hope it will help to manage your expectations about database file size.

[Yusuf Welder]

paypal.me/yusufwelding