Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
/dev/sda2 disk space
#11
I try that query, this is the result

information_schema 0.00781250 MB
pandora 382.08541489 MB

i use Pandora FMS 4.0.2 vm image only for monitoring servers and routers

Total agents 358
Monitor checks 1723

thank
 Reply
#12
Ok

Your database size is normal and isnt the size problem.

Check it "ls -l  /var/lib/mysql" and see if you have mysql-bin files.

Regards
 Reply
#13
Bingo!!
there are a lot of mysql-bin.0000xxx files..
...
-rw-rw---- 1 mysql mysql 1.1G Jul 31  2012 mysql-bin.000011
-rw-rw---- 1 mysql mysql 1.1G Aug  8  2012 mysql-bin.000012
-rw-rw---- 1 mysql mysql 1.1G Aug 16  2012 mysql-bin.000013
-rw-rw---- 1 mysql mysql 1.1G Aug 23  2012 mysql-bin.000014
-rw-rw---- 1 mysql mysql 1.1G Aug 30  2012 mysql-bin.000015
-rw-rw---- 1 mysql mysql  21M Aug 30  2012 mysql-bin.000016
-rw-rw---- 1 mysql mysql 151M Aug 31  2012 mysql-bin.000017
-rw-rw---- 1 mysql mysql 1.1G Sep  6  2012 mysql-bin.000018
-rw-rw---- 1 mysql mysql 341M Sep  8  2012 mysql-bin.000019
-rw-rw---- 1 mysql mysql 121M Sep  9  2012 mysql-bin.000020
-rw-rw---- 1 mysql mysql 137M Sep 10  2012 mysql-bin.000021
-rw-rw---- 1 mysql mysql 1.6K Sep 10  2012 mysql-bin.000022
-rw-rw---- 1 mysql mysql 5.1K Sep 10  2012 mysql-bin.000023
-rw-rw---- 1 mysql mysql  15M Sep 10  2012 mysql-bin.000024
-rw-rw---- 1 mysql mysql 1.1G Sep 16  2012 mysql-bin.000025
-rw-rw---- 1 mysql mysql 1.1G Sep 22  2012 mysql-bin.000026
...

pandora402:/var/lib/mysql # du -h
4.0K    ./test
988K    ./mysql
1000K  ./pandora
49G    .

Can i delete it all??
 Reply
#14
Ok, you can delete this binary logs.

To delete all binary logs older than 7 days (for example ) you can use this query:

mysql> PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY);

Regards
 Reply
#15
ok, you have solved my problem, thank a lot!!

pandora402:/var/lib/mysql # df -h
Filesystem            Size  Used Avail Use% Mounted on
rootfs                58G  4.8G  50G  9% /
devtmpfs            1003M  100K 1003M  1% /dev
tmpfs                1006M  4.0K 1006M  1% /dev/shm
/dev/sda2              58G  4.8G  50G  9% /
/dev/sda3              20G  173M  19G  1% /home
 Reply


Users browsing this thread: 1 Guest(s)


(c) 2006-2018 Artica Soluciones Tecnológicas. Contents of this wiki are under Create Common Attribution v3 licence. | pandorafms.com | pandorafms.org

Theme © MyBB Themes