Re: Reaching max between 1456-1458 connections
"Brian Austin" says: > Have you read the following page in the Manual on their site? > http://www.mysql.com/doc/en/Linux.html > > This gives you some tips to increase thread allocation. Especially > interesting is the part about the LinuxThreads hack. That's where I started, and it's why I compiled my own MySQL. However, the constants mentioned on that page are no longer defined as of 2.4 kernels and 2.3 glibcs. It looks like Linux has been somewhat reengineered to remove hard limits on threads since that page was written. And indeed, I don't run into a limit at 1024 threads. So that's why I'm asking here, in case someone has more recent information than the MySQL website. > Hope this helps, Thanks, I hope someone has the latest info. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reaching max between 1456-1458 connections
I'm baffled by reaching a limit of between 1456 and 1458 connections, at which point I can no longer make new connections. I've tried compiling my own MySQL and using the stock MySql RPM's. I've experimented with ulimits, values in my.cnf, and kernel parameters, and all the permutations of the above that seemed relevant. I've tried this on RedHat 8 and 9 systems with a 2.4 kernel and a glibc-2.3. I very much want to get this MySql installation to scale significantly higher, and I can no longer find any hard-coded limits that seem to be affecting the number of connections I can make. The two different boxes on which I have tested are different enough that it doesn't seem possible that the hardware could be the limiting factor and still turn out uniformally to reach the same maximum. They have very different amounts of RAM, and one box has just one significantly slower processor, whereas the other has two much faster processors. But both top out at between 1456 and 1458 connections, both The error I'm seeing is "Can't create a new thread (errno 11)." Can anyone suggest a way to get to the bottom of this problem and to increase whatever resource is limiting the number of threads I can create? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 3 and 4 side by side?
I'm trying to get both MySQL 3 and 4 running on the same machine, ideally from RPM packages. The MySQL 4 RPM complains of a conflict with the installed MySQL 3. Can anyone tell me if this installation is possible from RPM's, or will I have to compile MySQL 4? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
glibc 2.3.2 compatibility?
I'm trying to upgrade the glibc on some machines that do not yet have glibc2 in order to support > 1000 threads. It seems that some of the instructions concerning setting a pthread maximum for older glibc's are no longer pertinent. I wonder if the glibc 2.3.2 is known to be compatible with MySQL 4 and also if it is known to support > 1000 threads? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]