New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Same issue, mysql schema updates rely on, surprise surprise, disk I/O.
Don't over-complicate it for no reason, this may warrant SQLite at best - MySQL is overkill times 9001.
And no, even if done every second, it's not gonna cause any noticeable load at all.
Agree with earlier comments about separating data collection from presentation...
Recommend using collectd ping plugin for data collection...which will write to rrd format files...which can be read by modules in various scripting languages. Not only can your php script then list hostnames and ping times but you can easily add graphs later to show ping response per time. This is a very lightweight combination...
I'll probably use SQLite, is there a noticeable difference in resource consumption between SQLite and MySQL? I've never used SQLite.
SQLite and MySQL are completely different in function. MySQL is a full-fledged database system, while SQLite is basically an indexed flat-file database system that gets interacted-with via SQL.
http://stackoverflow.com/questions/3630/sqlite-vs-mysql has good info.
After reading http://www.sqlite.org/whentouse.html I will probably just use mysql because there are more features that will be implemented.