?
Solved

max_connections issue with mysql 4.1.15

Posted on 2014-04-29
6
Medium Priority
?
567 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

599 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