Archive for July, 2008

Server Health Statistics script

Tuesday, July 29th, 2008

Today I wrote a script for gathering health statistics on my servers. It gets data from hddtemp and sensors and writes it to a MySQL table.

The script and how-to-use can be found on the wiki: http://wiki.welmers.net/en/Health2MySQL

The MySQL table can easily be analized by (web) scripts to graphs e.d., functionality I still need to write.

Things that already can be done is finding interresting issues like:

SELECT AVG(temp_cpu) FROM health WHERE datetime BETWEEN '2008-07-25 00:00:00' AND '2008-07-30 23:59:59'

SELECT MAX(temp_sda) FROM health

SELECT MIN(rpm_fan) FROM health