I have my ulimt -n set for Websphere to 8000 On 3/2/07, David wrote: > > On Fri, 2 Mar 2007, Alex Dean wrote: > > > I've been reading about how it's possible to raise this limit by setting > > 'ulimit -n' to some higher number. It's currently at 1024. The only > > thing this machine does is MySQL, so there are no concerns about other > > users, etc. Before I make any changes, though, I was hoping someone > > might help me figure out a reasonable way to increase this number. > >This > > is new territory, so I'm wanting to tread cautiously. > > generally you can set the limits on a per-user basis, which is better > anyway. > > Not sure about other distros, but for redhat, put the changes in > /etc/security/limits.conf > i.e.: > mysqluser soft nproc 2047 > mysqluser hard nproc 32768 > mysqluser soft nofile 4096 > mysqluser hard nofile 524288 > mysqluser hard stack 65536 > mysqluser hard memlock 3145728 > > Then, in the users .profile (or equivilant) > ulimit -u 32768 -n 524288 -l 3145728 -s 65536 > > One thing to be aware of, from the bash manpage: > A hard limit cannot be increased once it is set; a soft limit may be > increased up to the value of the hard limit. > > This is what I use for my oracle servers, anyway. > David > > -- > "I find your lack of faith disturbing." > --Darth Vader > --- > 09:52:01 up 10 days, 22:11, 2 users, load average: 0.00, 0.02, 0.00 > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change you mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss >