Re: max_user_connections problem after upgrading

2003-11-15 Thread Matt W
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

Re: max_user_connections problem after upgrading

2003-11-14 Thread Joe Lewis
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]

Re: max_user_connections problem after upgrading

2003-11-13 Thread Joe Lewis
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

Re: max_user_connections problem after upgrading

2003-11-13 Thread Henrik Skotth
gt; - Original Message - > From: "Joe Lewis" > Sent: Wednesday, November 12, 2003 11:41 AM > Subject: Re: max_user_connections problem after upgrading > > >> We're experiencing the same issues, but not neccesarily after an >> upgrade. We're usin

Re: max_user_connections problem after upgrading

2003-11-13 Thread Matt W
Message - From: "Joe Lewis" Sent: Wednesday, November 12, 2003 11:41 AM Subject: Re: max_user_connections problem after upgrading > 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&#x

Re: max_user_connections problem after upgrading

2003-11-12 Thread Henrik Skotth
>>>> >>>>>I have tested this now, and that isn't the case. Any other ideas? >>>>> >>>>>-- Henrik >>>>> >>>>> >>>>>Michael McTernan skrev: >>>>> >>>>>

Re: max_user_connections problem after upgrading

2003-11-12 Thread William R. Mussatto
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 >

Re: max_user_connections problem after upgrading

2003-11-12 Thread Joe Lewis
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

Re: max_user_connections problem after upgrading

2003-11-12 Thread Henrik Skotth
>> > 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 >> > >> >>

Re: max_user_connections problem after upgrading

2003-11-12 Thread Pete Harlan
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

RE: max_user_connections problem after upgrading

2003-11-11 Thread Henrik Skotth
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

RE: max_user_connections problem after upgrading

2003-11-10 Thread Michael McTernan
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

Re: max_user_connections problem after upgrading

2003-11-10 Thread Henrik Skotth
That's new for 4.0? Hadn't noticed it... Anyway, it's set to 0 so there is no limit to exceed. Also, we aren't getting the error messages ALL the time, they start to appear after a day or two and gets more and more frequent untill I restart mysql. Any other ideas? -- Henrik gerald_clark skrev: >

Re: max_user_connections problem after upgrading

2003-11-10 Thread gerald_clark
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" error...

Re: max_user_connections problem after upgrading

2003-11-10 Thread Henrik Skotth
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, >> >>We recently upgraded to 4.0, it went >

Re: max_user_connections problem after upgrading

2003-11-10 Thread gerald_clark
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 th