Posts: 929
Threads: 135
Joined: Sep 2009
Reputation:
0
Hi guys. After i converted my script to the new mysql version [ From R6 to R17 ] i have some problems with the connections... This new version make my server block cuz the max connections to the mysql database get exced but with R6 not. What can be the problem?
Posts: 47
Threads: 0
Joined: Sep 2011
Reputation:
0
See mysql_log to view the possible error to have too many connections and give some more information, to get a more accurate answer
Posts: 929
Threads: 135
Joined: Sep 2009
Reputation:
0
I don't have errors in the mysql structure. I just get that message in the log with the max_connection ... that value is se to "10".
Posts: 10
Threads: 4
Joined: Dec 2012
Reputation:
0
1- Make sure you are not using persistent connections
2- Close the conenction (mysql_close) at the end of USAGE.
3- Checkout the my.cnf, and set this values:
set-variable = max_connections=500
set-variable = max_connect_errors=5000
and execute "SET GLOBALmax_connections = 500".
4- do flush-hosts
5- Use SQLite!!!!
Posts: 929
Threads: 135
Joined: Sep 2009
Reputation:
0
At the end of each queru or what?
Posts: 1,177
Threads: 27
Joined: Sep 2011
Reputation:
0
Any revision above 7 isn't made by BlueG and it has most likely been poorly tested/coded. I would not recommend using anything above 7.
Posts: 929
Threads: 135
Joined: Sep 2009
Reputation:
0
Ok then I will try using r7 and done. I think that each query open a connection but the connection don't stop after the query it's done
Posts: 860
Threads: 107
Joined: Dec 2010
Reputation:
0
I had the same problem. Just check if you have enabled cache in "mysql_function_query" function, when you use cache functions.
Posts: 929
Threads: 135
Joined: Sep 2009
Reputation:
0
Ok I think I have some problems at tjat part of.the mysql-insert-id.
