Pandora FMS Community

/dev/sda2 disk space

fonta · 22 mar 2013, 13:44 · 15 mensajes · 85 visitas

  1. Inicio del debate

    Hi, i have a little problem with my /dev/sda2 disk space, its always grow up and i don't know ho to free some space... pandora402:/home/admin # df -h Filesystem            Size  Used Avail Use% Mounted on rootfs                58G  50G  5.2G  91% / devtmpfs            1003M  100K 1003M  1% /dev tmpfs                1006M  4.0K 1006M  1% /dev/shm /dev/sda2              58G  50G  5.2G  91% / /dev/sda3              20G  173M  19G  1% /home How can i resolve this problem? Thanks

    [

    ](//pandorafms.com/community/media/forum/0/14797=416-IMM1.jpg)

  2. Hello Have you configured to run every day pandora_db.pl tool? (Link not available anymore) Regards

  3. hi mario, i'm using the vm image and that script already exists on it! i try to run the script but the result is always the same... pandora402:/etc/cron.daily # df -h Filesystem            Size  Used Avail Use% Mounted on rootfs                58G  50G  5.2G  91% / devtmpfs            1003M  100K 1003M  1% /dev tmpfs                1006M  4.0K 1006M  1% /dev/shm /dev/sda2              58G  50G  5.2G  91% / /dev/sda3              20G  173M  19G  1% /home

  4. Check your Setup - Performance configuration and decreases the days if you don't need so much information. Then run pandora_db.pl, and check if decreases the size. If you need a lot of information i recommend you a history database in other PC. ((Link not available anymore)) Regards

  5. I'd try to decrease the days and run the script but the free disk space don't change. now i can decrease /dev/sda3 and assign some free space to /dev/sda2 but i don't know what i have to do if pandora continue to eats space.

  6. Hello Have you checked the pandora_console/attachment size? (Link not available anymore). You can delete this temporaly files if this folder has very large size Regards

  7. Hi Mario, i'd deleted all the files in that directory but free space not increase... admin@pandora402:~> df -h Filesystem            Size  Used Avail Use% Mounted on rootfs                58G  51G  4.4G  92% / devtmpfs            1003M  100K 1003M  1% /dev tmpfs                1006M  4.0K 1006M  1% /dev/shm /dev/sda2              58G  51G  4.4G  92% / /dev/sda3              20G  173M  19G  1% /home

  8. Have you checked the pandora logs size ( /srv/www/htdocs/pandora_console/pandora_console.log, /var/log/pandora_server.log and  .error)? Check if you have configurated verbosity to 10, in pandora_server.conf, and change it to 1. Regards

  9. nothing to do, the log flie is some KB and the verbosity is sets to 1 now i reduce /dev/sda3  and assign some other GB to /dev/sda2...

  10. Hi What is the space occupied by the pandora database? You can see it with this query: SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ; Are you using this server to another function? Regards

  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

  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

  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??

  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

  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

Entra en tu cuenta para publicar.