LinHES Forums http://forum.linhes.org/ |
|
My backups have become HUGE! http://forum.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/ |