my.cnf optimizing MySQL

[pelowe]

Just wondering if anybody has a suggestion for tweaking the my.cnf file to reflect my server set-up.

I'm running Dual pentium III 550, 1G Ram, mirrored 8G SCSI HD.

Connections to the server are all through PHP about 90% SELECTS and 10% INSERTS/UPDATES.
It is a college sports site so I get some pretty heavy traffic on game days the rest of the time it's moderate to semi-heavy.

Currently I'm using the default settings but get major slow downs on game days.

Any help would be greatly appreciated.

Thanks,
pelowe

[Odysseus]

Visit the "server configuration" forum and ask eva2000 for help. :)
Provide all necessary data as requested here: http://www.vbulletin.com/forum/showthread.php?t=70117

90% SELECTS and 10% INSERTS/UPDATES.
Most likely, you will be able to take advantage of MySQL 4's query cache feature, so you should consider updating to MySQL 4.0.16 if you currently have 3.23.x installed.

[eva2000]

hi pelowe

Please enter your vBulletin.com forum registered email address on the form on this page to receive support for this issue: http://www.vbulletin.com/members/forums.php
- you will need your vB license customer number and password to access this form.