RE: Increasing max_connections and table_cache on Solaris 8

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

Increasing max_connections and table_cache on Solaris 8

2005-06-23 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

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

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