[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

max_connections issue with mysql 4.1.15

Posted on 2014-04-29
6
Medium Priority
?
561 Views
Last Modified: 2014-04-30
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:
SELECT max_user_coennections FROM mysql.user
WHERE user='db_user' AND host='localhost';

Open in new window


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
0
Comment
Question by:morten444
  • 3
  • 3
6 Comments
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 40029647
There's an spelling error in the column name, correct the spelling and try it again

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
0
 

Author Comment

by:morten444
ID: 40029796
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
0
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 40029926
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
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:morten444
ID: 40030143
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
0
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 2000 total points
ID: 40032348
I think you can still set max_connections per user using the system variable but i am not sure how to retrieve the value.... did you try using Show variables command to see the list of all available variables

http://dev.mysql.com/doc/refman/4.1/en/show-variables.html


I strongly recommend you to upgrade your MySQL to the latest version specially to take advantage of the new features
0
 

Author Closing Comment

by:morten444
ID: 40033233
Thanks for following through
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question