Maintaining MySQL Connections
View Single Post
07-27-2009, 02:29 PM
Join Date: Oct 2007
Location: Manchester, UK
Originally Posted by
Ok, it doesn't work at all. It connects more than 50 connections at a time, are there anymore solutions? I tried setting max connection in php.ini but still didn't work.
Did you edit your mysql config (typically called my.cnf in /etc), you can't edit mysql server settings via php.ini
you will need to add something like:
[mysqld] set-variable = max_connections=200
of course you will need to restart mysql for this change to be effective.
You could also set it to 0, then mysql wont limit it at all, however this probably isn't a good idea.
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)
View Public Profile
Send a private message to sketchMedia
Visit sketchMedia's homepage!
Find More Posts by sketchMedia