View Single Post
Old 02-06-2008, 12:44 PM   #2 (permalink)
sagoshawn
Junior Member
 
Join Date: 02-06-08
Location: Tampa, FL
Posts: 4
iTrader: 0 / 0%
Latest Blog:
None

sagoshawn is liked by many
Greetings!

Try this...

Use mysql_connect() instead of mysql_pconnect() unless you have a good reason. In particular, check this setting in third-party scripts (such as osCommerce).

Next, the file /etc/my.cnf typically holds defaults for mysql. Note: You will need to login in the shell as root to make the changes. A line of

[mysqld]
set-variable=max_connections=500

will increase the number of connections allowed to 500. you can change this to your needs. Please note that the instruction should be placed in the [mysqld] section. Otherwise MySQL will ignore it.

After resetting this, restart mysql (you would run "service mysqld restart" as root or issue the MySQL restart via WHM).

Hope this helps.
sagoshawn is offline   Reply With Quote