next »

[Bakes]

The admin of the community I am in has been put off installing XLRStats and Chatlogger, because he thinks the I/O of the extra SQL Queries would increase the load and as such ping for our clients. This is, he says, because we have a slow hard drive, and the constant SQL pounding of the databases could increase ping. Can anyone confirm or deny whether using these plugins increase ping or load on the servers significantly?

[Courgette]

it all depend on what your hardware can handle.
mysql can suffer from lack of RAM. About HDD, you'd better check mysql stats (can be seem on phpmyadmin) as mysql config can be tweaked to use more ram which avoid too much I/O disk operations.

The server I run has the following specs :
 * Intel(R) Pentium(R) Dual  CPU  E2180  @ 2.00GHz
 * 2GB RAM
 * 100Mb/s network card with unlimited brandwith

This machine runs :
 * 6 UrT servers
 * 2 Left4ded servers
 * 5 B3 bots (4 with chatlogger, and 3 with xlrstats)
 * website (using mysql as well)
 * serves maps through UrT autodownload
 * mysql (set up to take up to 100MB of RAM)

Mysql handles an average of 12 queries/s and had handled up to 130 q/s
with at max 20 simultanous connections. On average 10 q/s are served from mysql cache.

UrT servers have an average of 20 slots taken during the day.
CPU average is 15%
Total RAM used for programs : 1GB (which left 1GB for cache)
Each instance of B3 take ~10MB RAM and less tahn 1% of CPU
And nobody suffers lags

If any doubt about B3 making the system suffer, use monitoring solutions like munin or nagios and watch the graphs when B3 is on for a week, and compare when B3 is off for a week.
Maybe the mysql service handles a lot more things than your B3 databases...

[Bakes]

It's a random dual core, 4gb ram.

His fears are entirely based on database usage, and only b3 databases are hosted. We usually have around 15 people on our servers.

He does not wish to host the databases externally because of the extra latency & lower security. He is worrying about people stealing the GUID's and names of our members.

He does not wish to even try these plugins, purely because A) He doesn't want the server to go all laggy and for everyone to leave, and B) He was burnt by Ultrastats (by the end it was taking 3 hours to parse the logs), and is suspicious of stats.

Would the extra mysql queries from XLRStats and Chatlogger increase the server ping significantly on the server (fairly low load, can run 5 servers, but most are empty, obviously they only use HDD during map changes), and is there a way to theoretically prove this, without trying the plugins?

[Courgette]

It looks like your mysql database has never had the occasion to proove what it can handle
He is probably against the idea of having a mysql database handling queries and against stats. Ping suffering is the excuse he's making up now. If you counter argue that point, he will probably find another reason.

Find a picture of him naked and blackmail him if he doesn't want to try the stuff