Database Issue

[adam_T]

I need some help.
for some reason my Zoneminder database is reporting an on disk size of 17Gb /var/lib/mysql/zm = 17Gb
PHPMyadmin tells me that the total size of the database is only 107Mb. That is a huge difference! The issue is that I am running out of disk space. 98% full and I need that 17 Gig freed.
I have run zmaudit and cleaned out any errant entries.. Something is missing and I don't know what to do about it. Any suggestions please!

[bbunge]

Linux distro and version?

[adam_T]

I am running Ubuntu 16.04 LTS. Thanks

[bbunge]

http://stackoverflow.com/questions/1152 ... sbytes-row

If you are having problems with MySQL you may want to consider switching to Mariadb:
https://wiki.zoneminder.com/Ubuntu_Serv ... _installed