View Single Post
Old 18 Mar 2006, 01:45
drew010's Avatar
drew010 drew010 is offline
Join Date: Nov 2005
Real name: Drew
Originally Posted by RedWingFan
One dedicated server for now--7200 members, 1.5million+ posts. We've hit as many as 970 users online and haven't had any performance issues, although a majority of the guest users were Yahoo Slurp at the time. Normal activity is now about 650 members/non-members online during peak hours, still no major issues.

I did get our server configured with 3.25G of memory, which has helped. Well, that and George (aka "eva2000") having helped configure my.cnf to keep it running efficiently. I have four tables as InnoDB, which really cleared up the table locking problems we've had. We're running a Celeron 2.8GHz right now, which isn't ideal, but it IS working well for us, and within our budget (fueled 100% by donations).
wow , mind sharing some of the my.cnf file? ive been getting deadlocks every few days it seems and i usually only have 50-60 members online at once. and the forum is the only major site on the server with heavy database usage.

either way, im running a P4 2.8 ghz w/ HT, 1024mb ram, 120 sata single drive and it runs smoothly, just get that deadlock once in a while for some reason.
Reply With Quote