Solved

max_connections issue with mysql 4.1.15

Posted on 2014-04-29
6
508 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

 

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
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…

717 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