35MB total. The 3 largest tables are:
"players": (internal playerid, first name used, last name used, IP, Steam ID, connections, last connection), 153,000+ records @ 17.7MB. This is every player who has ever been on any of my servers. "playernames": Every name a player has used and when he last used it. 145,000+ records @ 8.3MB (I started tracking every name a few months after). "playersessions": Every session a player has done on my server, contains their internal playerid, the amount of seconds the session lasted, and the time and date the session ended. 406,000+ records @ 9.5MB, I only started recording this data since March 14th 2008. I use this data to build graphs to keep track of the amount of player hours on a daily basis. Keeping track of players that play on my server has been proven to be quite useful on several occasions. - voogru. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Stiehm Sent: Monday, June 09, 2008 5:18 PM To: Half-Life dedicated Win32 server mailing list Subject: Re: [hlds] Another command to crash servers. Fuckyay. How big is your sql database?> > My whole ban system, player database and admin system my plug-in runs is a> > quite large amount of code, I don't use any 3rd party plug-ins, the only> > thing I use is metamod. _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds _______________________________________________ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
