LinHES Forums
http://forums.linhes.org/

My backups have become HUGE!
http://forums.linhes.org/viewtopic.php?f=17&t=24180
Page 2 of 2

Author:  mattbatt [ Fri Jun 26, 2015 11:15 pm ]
Post subject:  Re: My database has become HUGE!

Thanks guys I'll keep searching for the culprit.

Author:  mattbatt [ Fri Jun 26, 2015 11:36 pm ]
Post subject:  Re: My backups hve become HUGE!

Thanks to Brfransen (again because she is awesome!) I found one of the culprits. Under driectory /data/srv/mysql/zm I found one culprit Log.MYD is 1.1 GB. I tried opening it but it wasn't readable.
Code:
total 1.3G
-rw-rw---- 1 mysql mysql 1.1G Jun 27 01:28 Logs.MYD
-rw-rw---- 1 mysql mysql 152M Jun 27 01:28 Logs.MYI
-rw-rw---- 1 mysql mysql 119K Apr 22 20:56 Config.MYD
-rw-rw---- 1 mysql mysql  15K Jul 14  2014 Monitors.frm
-rw-rw---- 1 mysql mysql  13K Jul 14  2014 Controls.frm
-rw-rw---- 1 mysql mysql  11K Apr 23 04:04 Config.MYI
...

I am assuming that "zm" stands for Zone Minder and since I don't use it why is it so large?

Author:  mattbatt [ Sat Jul 18, 2015 9:45 am ]
Post subject:  Re: My backups have become HUGE!

Well it happened my /data/srv/mysql partition reached 100% capacity and MythTV stopped working. My partition is 1.9 GB how what is the default size? What is everyone else's size?
I did a
Code:
df -h
to find the partition sizes.

Author:  tscholl [ Sat Jul 18, 2015 10:29 am ]
Post subject:  Re: My backups have become HUGE!

Mine was created from the ISO install when I upgraded to R8.0 using default sizes.
Code:
/dev/sda6       4.7G  224M  4.3G   5% /data/srv/mysql

All mythconverg and mysql databases contain lower case names. So there are no Log.* files in those directorys?
Are you running Zoneminder, or another program that that is creating the log files?

Author:  mattbatt [ Sat Jul 18, 2015 7:17 pm ]
Post subject:  Re: My backups have become HUGE!

Well in zm I found Logs.MYD which was 1.3 GB The culprit. Because I don't use zoneminder and because i have no idea what would happen if I just delete the file, I moved it to a hard drive with space. Now I just need to figure out why it's filling up! I checked the programs in LinHES settings and MythZoneMinder isn't checked as installed?

Page 2 of 2 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/