hi all
in the mysql.user table, what is the difference between max_connections
and mac_user_connections? or to put it simply, if i want each user
except root to only be able to have only one connection to the server at
any one time, which field should i set to 1?
--
PO Box 26453 00504
Nairobi
Hi,
One of our enterprise database servers (MySQL 4.0.16-max on Solaris 9)
recently refused connections with a 1203 error, "User [username] has
already more than 'max_user_connections' active connections".
Show variables lik
ber 14, 2003 11:28 AM
Subject: Re: max_user_connections problem after upgrading
>
> Matt W wrote:
> > I guess you'll have to see if it's fixed in the next release
(4.0.17).
>
> Any clue as to when 4.0.17 will be released?
>
> Joe
--
MySQL General Mailing List
F
Matt W wrote:
I guess you'll have to see if it's fixed in the next release (4.0.17).
Any clue as to when 4.0.17 will be released?
Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
William R. Mussatto wrote:
Joe Lewis said:
We're experiencing the same issues, but not neccesarily after an
upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're
getting max'd connections only on specific users, and the "show
processlist" is returning only the "show processlist" proc
to my site make connections and
access the database through that username and password
which is in the program code. Is that what
max_user_connections is about, connecting using the
same username and password?
Secondly for the purpose of SAFE public viewing could
I have in my settings blanks for us
ecent commit to the source
> tree to correct a problem or problems with max_user_connections
> counting. I think one of them was a race condition if 2 threads tried to
> increase/decrease the counter at once. But it seems like that would
> rarely happen for you guys unless you're getti
Hi guys,
Just wanted to say that I think I remember a recent commit to the source
tree to correct a problem or problems with max_user_connections
counting. I think one of them was a race condition if 2 threads tried to
increase/decrease the counter at once. But it seems like that would
rarely
>>>>
>>>>>I have tested this now, and that isn't the case. Any other ideas?
>>>>>
>>>>>-- Henrik
>>>>>
>>>>>
>>>>>Michael McTernan skrev:
>>>>>
>>>>>
Michael McTernan skrev:
>>>>
>>>>>Hi,
>>>>>
>>>>>Have you tried "netstat -a" on the box with the MySQL server? This
>>>>> command
>>>>>(Linux) will show what is connected to where, and will help you
>
ouble
check
that there really aren't any open connections to the server.
Thanks,
Mike
-Original Message-
From: Henrik Skotth [mailto:[EMAIL PROTECTED]
Sent: 10 November 2003 18:54
To: [EMAIL PROTECTED]
Subject: Re: max_user_connections problem after upgrading
That's new for 4
>> > command
>> > (Linux) will show what is connected to where, and will help you double
>> > check
>> > that there really aren't any open connections to the server.
>> >
>> > Thanks,
>> >
>> > Mike
>> >
>> >>
k
> > that there really aren't any open connections to the server.
> >
> > Thanks,
> >
> > Mike
> >
> >> -Original Message-
> >> From: Henrik Skotth [mailto:[EMAIL PROTECTED]
> >> Sent: 10 November 2003 18:54
> >> To: [EM
ou double
> check
> that there really aren't any open connections to the server.
>
> Thanks,
>
> Mike
>
>> -Original Message-
>> From: Henrik Skotth [mailto:[EMAIL PROTECTED]
>> Sent: 10 November 2003 18:54
>> To: [EMAIL PROTECTED]
>> Subject
Henrik Skotth [mailto:[EMAIL PROTECTED]
> Sent: 10 November 2003 18:54
> To: [EMAIL PROTECTED]
> Subject: Re: max_user_connections problem after upgrading
>
>
> That's new for 4.0? Hadn't noticed it... Anyway, it's set to 0 so there is
> no limit to exceed.
> A
, and the limit is 300, we still get the "already
more than max_user_connections" error...
>>
>>-- Henrik
>>
>>gerald_clark skrev:
>>
>>
>>>Henrik Skotth wrote:
>>>
>>>
>>>
>>>>Hello all,
>>>>
>&
Are you sure you are net exceeding the setting for
maximum connections per hour for that user?
Henrik Skotth wrote:
Hi!
What I meant was that even if there are currently only two user
connections being used, and the limit is 300, we still get the "already
more than max_user_connections&q
Hi!
What I meant was that even if there are currently only two user
connections being used, and the limit is 300, we still get the "already
more than max_user_connections" error...
-- Henrik
gerald_clark skrev:
>
>
> Henrik Skotth wrote:
>
>>Hello all,
>>
>
Henrik Skotth wrote:
Hello all,
We recently upgraded to 4.0, it went
very well and the performance gains have been great.
But now the server has started to act strangely. Every few days, the
server starts to refuse connections, saying
that there is already more than max_user_connections, but
Hello all,
We recently upgraded to 4.0, it went
very well and the performance gains have been great.
But now the server has started to act strangely. Every few days, the
server starts to refuse connections, saying
that there is already more than max_user_connections, but there is really
only one
there is already more than max_user_connections, but there is really
only one or two active connections and our max_user_connections is 300. I
have to take down and restart the server to solve the problem.
Does anyone know of any solution to this?
Regards,
-- Henrik Skotth
--
MySQL General
Stefan Hinz wrote:
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
fr
Michael,
> It would be nice to extend the user permissions table to have per-user
> limits like max_user_connections and the various timeouts applying
> directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt
from my my
On Mon, Feb 17, 2003 at 02:33:05PM -0500, Michael T. Babcock wrote:
> It would be nice to extend the user permissions table to have per-user
> limits like max_user_connections and the various timeouts applying
> directly to specific user/host combinations.
Agreed. We've had a few
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
Just a thought / suggestion.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net
[EMAIL PROTECTED] writes:
> >Description:
>
> I have the max_user_connections set to 150 on every one of my servers but a
>single user is still able to use up to 250 connections. (max_connections=250)
>
> >How-To-Repeat:
>
>execute a hu
>Description:
I have the max_user_connections set to 150 on every one of my servers but a
single user is still able to use up to 250 connections. (max_connections=250)
>How-To-Repeat:
execute a huge query then send 250 updates separately to that same table
Hi,
I have set max_user_connections to 80 on my database. But that doesn't seem to work -
I have more than 130 connections from one user. What can be the reason?
I'm using version 3.23.47
Rafal
-
Before posting, pl
28 matches
Mail list logo
