Hello.
I don't have enough experience with Solaris.. But on most Unixes your could change the limit of file descriptors for process, not for whole system. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html "Martijn van den Burg" <[EMAIL PROTECTED]> wrote: > Hi, > > This applies to 4.1.10 on Solaris 8, with 1 GB of RAM.=20 > > Our internal customer wants to be able to make 1000 concurrent > connections to our database, with a mix of MyISAM and InnoDB tables, but > according to http://dev.mysql.com/doc/mysql/en/table-cache.html and an > online Solaris reference > (http://docsun.cites.uiuc.edu/sun_docs/C/solaris_9/SUNWaadm/SOLTUNEPARAM > REF/p44.html) I would need a table_cache of roughly 1000*2*3 =3D 6000 > (assuming only MyISAM tables are used which need two file descriptors > per table, and three tables per join). > > However, from experience I know that increasing table_cache from 64 to > 256 will already result in 'Too many open files' errors and the database > becoming unaccessible. > > To solve this, and actually allow 1000 connections, should I let the > sysadmin increase the limit of open file descriptors on the Solaris box, > or is there a setting in MySQL that I overlooked? > > Note: max_connections is set to 1000 in the my.cnf file, but when > starting up, MySQL doesn't accept that value and decreases it to 246. > Setting the variable to 1000 whilst MySQL is running /is/ accepted. > > > Kind regards, > > -- > Martijn > ASML ITM&S Application Support / Webcenter > > > -- =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]
