Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
TheWitness wrote:Post a "ls -l -R" to the web site, let's see what file is growing.
I attached the output of my mysql folder. As you can see the <hostname>-bin.xxx files are the one eating space. It appears they contain logs for sql queries... What can be done to prevent this?
Ok... Maybe I was a bit to fast with my last reply...
I found a log-bin
line my /etc/my.cnf, commented it out and restarted mysql.
It appears that the log does no longer grow now...
But hmm... It was on by default from dawn of days and my database did not show that growth befor upgrading cacti to 0.8.6.
So if removing this line cures the problem it was a stupid configuration problem on the machine itself and not the fault of cacti. So I assume cacti 0.8.6 is doing much more database traffic compared to 0.8.5 which caused the growth.
I have the same question. cacti's diskspace was stable before i upgraded to the latest version.. And when i check the statistic in phpmyadmin, it looks like it works constantly. Why is the SQL traffic so high?
-Sigurd
I have same problem .
It seem mysql Innodb problem when I check mysql data/path (ex: /usr/loca/mysql/var)
drwx------ 2 mysql mysql 4096 Dec 8 20:08 cacti
-rw-rw---- 1 mysql mysql 119 Nov 17 20:27 Cacti-bin.001
-rw-rw---- 1 mysql mysql 4 Nov 17 20:27 Cacti-bin.002
-rw-rw---- 1 mysql mysql 79 Nov 17 20:31 Cacti-bin.003
-rw-rw---- 1 mysql mysql 79 Nov 17 21:07 Cacti-bin.004
-rw-rw---- 1 mysql mysql 79 Nov 17 21:18 Cacti-bin.005
-rw-rw---- 1 mysql mysql 4096 Dec 8 05:35 Cacti-bin.010
-rw-rw---- 1 mysql mysql 0 Dec 8 05:42 Cacti-bin.011
-rw-rw---- 1 mysql mysql 29453 Dec 8 20:59 Cacti-bin.012
-rw-rw---- 1 mysql mysql 1737145 Dec 8 21:39 Cacti-bin.013
-rw-rw---- 1 mysql mysql 100222278 Dec 10 12:21 Cacti-bin.014
Tony wrote:I have same problem .
It seem mysql Innodb problem when I check mysql data/path (ex: /usr/loca/mysql/var)
drwx------ 2 mysql mysql 4096 Dec 8 20:08 cacti
-rw-rw---- 1 mysql mysql 119 Nov 17 20:27 Cacti-bin.001
-rw-rw---- 1 mysql mysql 4 Nov 17 20:27 Cacti-bin.002
-rw-rw---- 1 mysql mysql 79 Nov 17 20:31 Cacti-bin.003
-rw-rw---- 1 mysql mysql 79 Nov 17 21:07 Cacti-bin.004
-rw-rw---- 1 mysql mysql 79 Nov 17 21:18 Cacti-bin.005
-rw-rw---- 1 mysql mysql 4096 Dec 8 05:35 Cacti-bin.010
-rw-rw---- 1 mysql mysql 0 Dec 8 05:42 Cacti-bin.011
-rw-rw---- 1 mysql mysql 29453 Dec 8 20:59 Cacti-bin.012
-rw-rw---- 1 mysql mysql 1737145 Dec 8 21:39 Cacti-bin.013
-rw-rw---- 1 mysql mysql 100222278 Dec 10 12:21 Cacti-bin.014
any known fixes for this issue?
I had the same problem... Switch off binary logging in your mysql conf (my.cnf). See my posting about this in this thread.
Wernicke wrote:btw, I use the new version of CactiD.. Perhaps it talks to much to the SQL..
Do you other ppl with the same problem use cactid?
-Sigurd
No. I don't use cactid. I use the php poller and I also had the problems...
Now, since I switched off binary logging in mysql and deleted the <hostname>-bin.xxx files everything is fine.
It works fine with me too after I turned off logging.. but i think we should fix the cacti problem, not the SQL logging.. if there is a problem
-Sigurd
TheWitness wrote:If you read about the binary log file. It logs all transactions. It's more of a debug option in MySQL. Should have been turned off from the beginning.
I believe this to be a MySQL issue. For Cacti related issues, I would look to the Apache log which holds all PHP related STDERR type output.
I agree with you. Certainly it is a mysql issue in the first point. Logging should be disabled.
BUT: I would also be nice to know why cacti 0.8.5 was not causing a so tremendous increase of the logfile and 0.8.6 is doing this now. In bigger scenarios when monitoring much more than my 20 hosts here sql traffic could become a performance issue.
Here's the statistic from phpmyadmin:(This is statistic for 1 day with 110 hosts)
Query statistics: Since its startup, 3,816,588 queries have been sent to the server.
Total ø per hour ø per minute ø per second
3,816,588 100,460.03 1,674.33 27.91
? Cheeses