RE: Increasing max_connections and table_cache on Solaris 8
Hi, Hm, using ulimit on my own Ultra Sparc w/ Solaris 8, I can raise ulimit to max. 1024. Probably not quite enough. More study will be required :-/ Martijn > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: donderdag 23 juni 2005 16:27 > To: mysql@lists.mysql.com > Subject: Re: Increasing max_connections and table_cache on Solaris 8 > > 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/SOLTUNEPAR > > AM > > 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 -- 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: Increasing max_connections and table_cache on Solaris 8
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]
Increasing max_connections and table_cache on Solaris 8
Hi, This applies to 4.1.10 on Solaris 8, with 1 GB of RAM. 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 = 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 -- 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]
increasing max_connections
Hi... I need to increase my max_connection variable on mysql DB. Her value now is 100... I must to increase to 500. (Mysql 3.23.49 on Red Hat 8. My server is a IBM Pentium 4, 1.6 Ghz, HD 40G, 1G of RAM) What do I have to do for balance my DB and my server in this case? Which others elements or variables should be measured, studied? Is there an equation that can I have a base for this decision? I'd be very thankful for any assistance! Regards []'s Marcelo Mazon - [EMAIL PROTECTED] Diretoria de Informática - UNESC Universidade do Extremo Sul Catarinense Criciúma - Santa Catarina - Brasil