RE: Connections and open files weirdness?
Hi, > 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 Thanks for the link, I already knew of it ;) It is low and I intend to raise it, but my operating system's ulimit is still 256 at the moment so I can't go above that yet (I am working ongetting it raised). However, even with the 236 connections opened, the number of Open_files is only 5, which is far less than the limit of 256. So, /which/ files are opened by mysqld if I don't see the value of Open_files increase? Kind regards, Martijn > > > "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. > > -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connections and open files weirdness?
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]
Connections and open files weirdness?
Hi, I'm running out of resources even though I think I shouldn't. The open_files_limit=256, max_connections=246, and table_cache=64 and 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=264MB. Tables are flushed before I start making the connections. Thanks for your time. -- Martijn -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]