I was forced to move the mysql server off my dedi box, it was using a fair bit of CPU when the database got big... And there are a lot of inneficient mysql queries in hlstatsx. I now have a VPS only running mysql for hlstatsx. On the VPS for the last week of the month im constantly bursting 120+% CPU.
bl4nkeh, I look forward to this plugin :) On 6/11/08, Mike Stiehm <[EMAIL PROTECTED]> wrote: > > Do you max the CPU or something? I run 9 servers I do log the chat > I think I log everything. My perl daemon sits around 1% cpu when the > servers > max out. I delete users after 30 days and never once cleared the stats > in over 6 months. 400Meg database size. I was thinking that is a large > database guess i was wrong :) > > > --------------------Yeah started off with a simple mysql server on one of > the dedis, then hadto move it to a VPS... And its doesnt cope well at month > end. It was covering 10 gameservers in May, we have 14 now... And I dont > logchats, or admin chat... > > _______________________________________________ > 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
