morten444
asked on
max_connections issue with mysql 4.1.15
Hi
We have a delphi made application that uses mysql 4.1.15
We will first get it upgraded to Mysql 5 in some month
All users are logged onto mysql using root (this happens in the background coding)
When about 30 are logged in we get a ERROR 1040 : Too Many Connections
In my.ini file i have set:
max_connections = 500
I still get the problem
I have read some more about max_user_connections but not sure if this can be used with MYSQL 4.1.15?
I tried to to add the follwing statement:
Hoping to see what the max_user_connection setting was but it return the error
ERROR 1054: Unknown column 'max_user_connections' in 'field list'
My question is
Should i be able to use 'max_user_connection' with MYSQL 4.1.15?
If not is there a work around I can use
We have a delphi made application that uses mysql 4.1.15
We will first get it upgraded to Mysql 5 in some month
All users are logged onto mysql using root (this happens in the background coding)
When about 30 are logged in we get a ERROR 1040 : Too Many Connections
In my.ini file i have set:
max_connections = 500
I still get the problem
I have read some more about max_user_connections but not sure if this can be used with MYSQL 4.1.15?
I tried to to add the follwing statement:
SELECT max_user_coennections FROM mysql.user
WHERE user='db_user' AND host='localhost';
Hoping to see what the max_user_connection setting was but it return the error
ERROR 1054: Unknown column 'max_user_connections' in 'field list'
My question is
Should i be able to use 'max_user_connection' with MYSQL 4.1.15?
If not is there a work around I can use
ASKER
Hi
Thank you for the feedback
Yea sorry about. It was a spelling mistake in the site i took the code from, but i did fix it when i inserted it
Please see the screenshot attached
Does it look right?
Any idea?
Update:
I have also attached a screenshot of availabe columns
mysql-max-user-connection.PNG
columns-in-mysql.PNG
Thank you for the feedback
Yea sorry about. It was a spelling mistake in the site i took the code from, but i did fix it when i inserted it
Please see the screenshot attached
Does it look right?
Any idea?
Update:
I have also attached a screenshot of availabe columns
mysql-max-user-connection.PNG
columns-in-mysql.PNG
looks like the error message is right because Max_user_connections is not available in the table, the only relevant column you have for your purposes is max_connections
The Ref links i posted above are in regards to the system variables, which i realize are not much of a help to you
The Ref links i posted above are in regards to the system variables, which i realize are not much of a help to you
ASKER
Hi
Thanks for comming back to me
So i guess I am left with 2 solutions:
1. Set high max_connections and get it made so we can maybe create 3 or 4 different mysql users. Me assuming that if there is a max somehow pr user, if I have 4 username, i should be better off.
2. Wait until we have an updated version that runs on MYSQL 5 where max_user_connection will be supported
Do you agree with this conclusion? I have to present my findings so good with a 2nd opinion
Thanks
Thanks for comming back to me
So i guess I am left with 2 solutions:
1. Set high max_connections and get it made so we can maybe create 3 or 4 different mysql users. Me assuming that if there is a max somehow pr user, if I have 4 username, i should be better off.
2. Wait until we have an updated version that runs on MYSQL 5 where max_user_connection will be supported
Do you agree with this conclusion? I have to present my findings so good with a 2nd opinion
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for following through
SELECT max_user_connections FROM mysql.user
WHERE user='db_user' AND host='localhost';
Yes, you should be able to use the stmt because the system variable was added in 3.23.34
Ref:
http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#sysvar_max_user_connections
http://dev.mysql.com/doc/refman/4.1/en/show-variables.html