Re: 1024 Max Connection limit- NEED to Up it to 4000+

[Lenz Grimmer]

Chris Schneider Wrote:
-------------------------------------------------------
> I am running into an issue on a dell 2850 (6GB
> RAM, RHLE 4 64bit) server (kernel = 2.6.9-22.ELsmp
> #1 SMP). I keep running into a what seems to be a
> hard limit of 1024 max connections.

Can you elaborate on what happens when you reach this number? How do you tell? What does "SHOW VARIABLES LIKE 'max_connections';" return?

> I am using the mysql-standard-4.1.18-unknown-linux-gnu-x86_64-glibc23 > version of mysql. Is there a way that I
> would be able to get around this hard limit? I am
> trying to get the max connections up to 4000+.

To my knowledge there used to be a limitation to 1024 concurrent threads when using the LinuxThreads library. Newer glibc versions should also provide the NPTL threads library, which supposedly does not have this limitation. You may want to explore into that direction.

Bye,
LenZ