I am running some very high volume message boards (WWWThreads) using PHP/MySQL and last night got the "too many connections" error so my sys admin changed the max_connections variable from 100 to 1000.
I saw on the offical MySQL site that Linux servers can have this variable set between 500-1000 if there is enough memory. This particular server is a PIII 700 with 512 RAM and good quality SCSI hard drives (not sure of exact specs). It is a dedicated box and I am running persistent connections.
Is it this simple? Are there other things I should be thinking about? I'm just now learning PHP & MySQL and want to make sure I'm doing what is best long term. Thanks for any help!
Bryan
I saw on the offical MySQL site that Linux servers can have this variable set between 500-1000 if there is enough memory. This particular server is a PIII 700 with 512 RAM and good quality SCSI hard drives (not sure of exact specs). It is a dedicated box and I am running persistent connections.
Is it this simple? Are there other things I should be thinking about? I'm just now learning PHP & MySQL and want to make sure I'm doing what is best long term. Thanks for any help!
Bryan