Re: Server just hanging (Copying to tmp table)

[Erin ONeill]

Hey Thomas -
Sorry this post slipped by me....

It seems to me (on this Monday morning) that you've set up the system ulimits but not the user. From my past experience with Oracle on solaris I'd set the ulimits in the Oracle startup script, but mysql has this very cool thing where you can set a user's ulimits in config files. I set them up here:

/etc/security/limits.conf

This is what I used with 4 gb of ram .... if you have more ram you probably want to set it higher.
mysql soft nofile 202860
mysql hard nofile 405720
mysql soft nproc 33792
mysql hard nproc 67584

There you can give different apps, different ulimits. Don't forget that the system needs some (I've read the system needs about 2,000) and that if you are running apache & Mysql on the system you'll want to be sure that neither one of them can crash the system.

Where are you with this?

erin