Solved

max_connections issue with mysql 4.1.15

Posted on 2014-04-29
6
496 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

803 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