Hi.
On Thu, Feb 01, 2001 at 01:33:06PM -0800, [EMAIL PROTECTED] wrote:
>
> I was under the impression ulimit controlled this, but someone just told me
> that by default, the linux kernel only supports 256 simultaneous
> connections, thus MySQL is limitd to 256 connections unless running on a
> modified kernel.
This depends on the kernel version and the distribution, but
basically, this statement is correct. (this limit is per process, by
the way)
> This does not sound right to me so
May I ask why? It's everything but normal that an (user) application
would need so much connection, woudn't it?
And on a server, it is always a good idea to tweak the OS to fit your
needs.
> I thought I would ask here. We are currently performance testing
> MySQL on RH 6.2.
I have no RH 6.2 system by hand, but I know that e.g. Halloween 6.1
(based on RH 6.1) already had 1024 sockets per process.
> I have rebuilt the kernels to allow more shared memory (for some
> other apps) but have done nothing that would affect a limit such as
> this.
If you are already building the kernel yourself, is there any problem
to simply change that config and recompile?
> I know I have some Oracle
> databases running on the same kernels (2.2.18smp) that allow more than 256
> connections.
Hm. Two possibilities come to my mind: Either you already have a
higher connection limit or Oracle uses several processes to overcome
that limit.
Bye,
Benjamin.
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
