> Error code 9: Bad file descriptor - so you might need to increase your file
> descriptors even more, I've seen them over 32,000 for some things.
> It might not be that directory thats the problem, it my just be having a
> problem allocating temp space. If the error code doesn't explain enough you
> could try launching the mysqld daemon with --tempdir=path with path being a
> volume that the mysql user can read/write too that has a lot of free space.
> > or this:
OK, I tried those suggestions, still no dice.
I put tmpdir on a partition with 5 GB free, where mysql had full
read/write to the directory. I kicked up maxfiles to 32,000:
sysctl -w kern.maxfiles=32000
Also of interesting note, I compiled PostgreSQL 7.4.2 from source, and ran
sql-bench against that (sql-bench can run against MySQL, Postgres, mSQL,
and Solid Server)
Most of the tests died with:
Bus error (core dumped)
Next, I'm going to try a ports-compiled PostgreSQL.
Tony
|