RE: Increasing max_connections and table_cache on Solaris 8

2005-06-27 Thread Martijn van den Burg
t; 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. > > Se

Re: Increasing max_connections and table_cache on Solaris 8

2005-06-23 Thread Gleb Paharenko
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,

Increasing max_connections and table_cache on Solaris 8

2005-06-22 Thread Martijn van den Burg
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

increasing max_connections

2005-04-05 Thread Marcelo Mazon
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