07-27-2009, 02:29 PM
|
#9 (permalink)
|
|
The Prestige
Join Date: Oct 2007
Location: Manchester, UK
Posts: 854
Thanks: 32
|
Quote:
Originally Posted by TheOnly92
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:
Code:
[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)
|
|
|
|