Solved

max_connections issue with mysql 4.1.15

Posted on 2014-04-29
6
493 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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…

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now