Database sizes

ramrajone

For some reason, my database size on the original DB is smaller than what used the same DB to restore on the Test server

This is the same Database:
https://forum.osticket.com/d/92935-upgrade-from-1101-to-1104/11

KevinTheJedi

ramrajone

I have a feeling MySQL isn't clearing the space on the disk on delete. Usually you can enable MySQL's innodb_file_per_table setting to help with this. When MySQL isn't returning the space to the disk you need to dump it and import it to a new database and you’ll see the true size which is what I believe happened in your case. You can research this online for more information.

Cheers.