[mysql option max_user_connections doesn"t seem to work]

>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.
>Fix:
a
code fix?

>Submitter-Id:
>Originator:
>Organization:

RightNow Technologies
>MySQL support: [ extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.47 (Source distribution)

>Environment:

System: Linux dbsc01.rightnowtech.com 2.4.17 #2 SMP Fri Jan 4 17:47:51 EST 2002 i686 unknown
Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make

Compilation info: CC='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc' CXXFLAGS='-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 15 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4103980 Jul 31 2000 /lib/libc-2.1.3.so
Configure command: ./configure --prefix=/usr/local/pkg/mysql/mysql-3.23.47 --enable-assembler --with-mysql-ldflags=-all-static --disable-shared --with-extra-charsets=complex


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12145@lists.mysql.com
To unsubscribe, e-mail

Re: [mysql option max_user_connections doesn"t seem to work]

rhuddleston@rightnow.com 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 huge query then send 250 updates separately to that same table.
> >Fix:
> a
> code fix?
>
> >Submitter-Id:
> >Originator:
> >Organization:
>
> RightNow Technologies
> >MySQL support: [ extended email support ]
> >Synopsis:
> >Severity:
> >Priority:
> >Category: mysql
> >Class:
> >Release: mysql-3.23.47 (Source distribution)

Hi!

I just tested it with 3.23.51 and it worked like a charm.

If you have the same problem with our 3.23.51 binary, send us your my.cnf.


--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12146@lists.mysql.com
To unsubscribe, e-mail

Re: [mysql option max_user_connections doesn"t seem to work]

rhuddleston@rightnow.com 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 huge query then send 250 updates separately to that same table.
> >Fix:
> a
> code fix?
>
> >Submitter-Id:
> >Originator:
> >Organization:
>
> RightNow Technologies
> >MySQL support: [ extended email support ]
> >Synopsis:
> >Severity:
> >Priority:
> >Category: mysql
> >Class:
> >Release: mysql-3.23.47 (Source distribution)

Hi!

I just tested it with 3.23.51 and it worked like a charm.

If you have the same problem with our 3.23.51 binary, send us your my.cnf.


--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php