Re: Server just hanging (Copying to tmp table)

[Shawn Hogan]

Another thing I just realized, and might actually be the problem... Mac OS X Server imposes a limit of 1,024 open files per user (by default):

x2:~ root# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) 6144
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 100
virtual memory (kbytes, -v) 14336