We recently started getting "Can't create thread" errors since switching to Debian.
On Red Hat 8.0 we were able to spawn more than 400 mysql threads and never encountered this error. mysql 3.23.56 compiled from source, stock kernel. (2GB of RAM)
Now we get it all the time on Debian and the MySQL AB 3.23.58 binary around 245 threads, linux 2.4.23 custom kernel. (3GB of RAM, not that it matters)
Are we missing a setting?
Does Red Hat have some kind of userland address space hack that we're not aware of?
Do you have any special kernel config options that you did not use before?
Also, it could be an issue in the MySQL build itself. Try stress testing both binaries on the old box if it is still around or on some other machine with the same kernel and glibc. It would also be nice to test the only binary on the new box or on another box with the same kernel and glibc.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]