Re: MySQL Max connections?
On Tue, 2004-12-07 at 11:47 -0600, Jacob S wrote: Can anyone tell me if this is the correct way to increase the max number of connections, or how to do it if it's not? I would try to test it myself, but it is a bit hard to do on a busy server and when I would need a huge number of connections. Other replies have spoken about the max_connections mysql settings so I wont repeat. Just wanted to add some Debian Woody specific experience. With mysql 3.23 (or a back-ported 4.0) the maximum connections appear to be around 300, whatever mysql is set to. This can be increased to around 800 by altering the maximum user processes in the safe_mysqld (or mysqld_safe in v4.0) script. We simply added the line: ulimit -u unlimited However if you have InnoDB support enabled in mysqld the maximum still seems to be limited to just over 400 connections. Upgrading libc6 to 2.3 instead of 2.2 was the only 'fix' we found to get the limit, with InnoDB, back up to about 800. Of course the machine isn't strictly Woody then though. Be warned that upgrading libc6 (or especially trying to downgrade it later) is not always the easiest of things to do! Simon -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: 3ware and Debian?
On Thu, Feb 07, 2002 at 11:07:41AM +0800, Jason Lim wrote: Does anyone here run any 3ware IDE RAID cards here, and Debian as well? Yep, we do on a number of boxes. Do you know if 3ware's Web-based RAID Control program works in Debian? We've found that this depends upon the kernel version you're running. Upto about (not sure exactly) 2.4.13 it all works fine, however after that the web interface can't find any adaptors! Apparently this should be fixed shortly, although I don't know if that's a fix in the kernel or the 3ware web package. Simon -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: 3ware and Debian?
On Thu, Feb 07, 2002 at 11:07:41AM +0800, Jason Lim wrote: Does anyone here run any 3ware IDE RAID cards here, and Debian as well? Yep, we do on a number of boxes. Do you know if 3ware's Web-based RAID Control program works in Debian? We've found that this depends upon the kernel version you're running. Upto about (not sure exactly) 2.4.13 it all works fine, however after that the web interface can't find any adaptors! Apparently this should be fixed shortly, although I don't know if that's a fix in the kernel or the 3ware web package. Simon
