Page 1 of 1

Database Issue

Posted: Wed Jul 27, 2016 10:01 pm
by 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!

Re: Database Issue

Posted: Thu Jul 28, 2016 3:17 pm
by bbunge
Linux distro and version?

Re: Database Issue

Posted: Thu Jul 28, 2016 9:24 pm
by adam_T
I am running Ubuntu 16.04 LTS. Thanks

Re: Database Issue

Posted: Thu Jul 28, 2016 9:28 pm
by 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