Hello.
Your value 256 for open_files_limit is too low. Set it at least to several thousands. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html "Martijn van den Burg" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm running out of resources even though I think I shouldn't. > > The open_files_limit=3D256, max_connections=3D246, and table_cache=3D64 a= > nd > I'm trying to actively create 'Too many open file errors' with this > configuration, to be able to quantify the effect of raising the > filesystem's ulimit, and the variables mentioned above. > > The first problem is this: I can only make 236 connections and not 246 > (Threads_connected). > > Further, with the 236 connections opened: as soon as I do the first > table join (just two tables), I get the 'Too many open files' error. > But... Open_files is only 5 and Open_tables is 1. > > So even though it appears that my resources aren't spent, I still have > an unuseable system. Why? > > MySQL 4.1.10, Solaris 8, 1 GB RAM, key_buffer_size=3D264MB. Tables are > flushed before I start making the connections. > > > Thanks for your time. > > > -- > Martijn > > > -- =0D > The information contained in this communication and any attachments is co= > nfidential and may be privileged, and is for the sole use of the intended= > recipient(s). Any unauthorized review, use, disclosure or distribution i= > s prohibited. If you are not the intended recipient, please notify the se= > nder immediately by replying to this message and destroy all copies of th= > is message and any attachments. ASML is neither liable for the proper and= > complete transmission of the information contained in this communication= > , nor for any delay in its receipt. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
