Pandora FMS Community

Tip: How much time maintenance db is taking?

daniels · 18 feb 2009, 9:46 · 3 mensajes · 58 visitas

  1. Inicio del debate

    Hi guys, I think that the next pandora release will come with a maintenance script that gives the start/end time as output. Meanwhile, I'm using a very simple script to do the job and want to share this tip. It runs everyday at 22:00hs. Cronjob: 00 22 * * * /home/pandora/manut.db.sh 2>&1 | /bin/mail -s "Pandora DB" "my_[email protected]" The /home/pandora/manut.db.sh scrit: echo "--------------------------------------" echo "Starting Database Maintanence: ";date echo "--------------------------------------" perl /var/www/pandora_server/util/pandora_db.pl /etc/pandora/pandora_server.conf echo "--------------------------------------" echo echo "Finished of the Database Maintanence: ";date echo "--------------------------------------" Make sure to alter the location of the pandora_db.pl (in manut.db.sh script) to match your local installation. Just this. Regards.

  2. You're a script maniac eh ? ;) It gives 25 secs for me (demo system)

  3. :-) I like scritps (maybe, more than I should...) For me took 00:01:04 (1 min 4 sec), but my database has only 1 month of data. (I lost the historical data playing with scripts (not a good idea at all)) By the way, I recovered some old data (from the last year) and replicate the pandora_console to access the old year 2008 data (still working with this). I think this would be good for database performance and could be a good feature request.... Anyone here has performance problems after one year of collected data?

Entra en tu cuenta para publicar.