Adam, Friday, September 27, 2002, 8:03:14 AM, you wrote: AE> I am indeed in a very strange situation, to me at least. We've got a AE> good-sized database (about 60gb) over 4k tables. We average about 300 AE> queries per second. We've recently noticed some strange behavior at around AE> 430 connections. We get the "unable to create new thread (errno 11) if you AE> are not out of available ram you may have encountered an OS bug, see the AE> manual." error. When this happens, we usually have a gig or two of ram AE> available. I haven't been able to gleam more details from the manual, so AE> here I am.
AE> Using the formula (key_buffer_size + (record_buffer + AE> sort_buffer)*max_connections) from the docs, it appears that right when the AE> connection count hits about 430, 2gb of ram is being used. AE> After much tweaking of my.cnf, I can get just under 600 connections by AE> reducing record and sort buffers. Conversely, if I set key_buffer to AE> something large (ie. 1gb) I cap out at a couple hundred connections. Is AE> their some kind of limit imposed on allocated memory by mysql? Or should I AE> look elsewhere (Kernel, pthreads)? AE> This question may sound somewhat absurd and if my hosting provider hadn't AE> said "MySQL has a 2gb limit that is very painful to overcome" I wouldn't AE> even ask. But I've been dealing with this for the last two weeks, at this AE> point I'll settle for anything. :) AE> Thank you for your time, AE> Adam Erickson AE> [EMAIL PROTECTED] AE> System specs: AE> 4x700 Xeon (1mb) AE> 4gb Ram AE> Kernel 2.4.9 (SMP, enterprise) AE> MySQL-max v3.23.52 (MySQL AB binary release) It's not a regular situation. What I would suggest: first, upgrade kernel to 2.4.19. Second: what is the table type of the database - InnoDB, BDB or MyISAM? This is important. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
