RE: Relationship between 'table_cache' and 'max_connections'

2005-02-02 Thread Mark
> -Original Message- > From: Dathan Pattishall [mailto:[EMAIL PROTECTED] > Sent: donderdag 3 februari 2005 1:21 > To: Mark; mysql@lists.mysql.com > Subject: RE: Relationship between 'table_cache' and 'max_connections' > > Max_connections rel

RE: Relationship between 'table_cache' and 'max_connections'

2005-02-02 Thread Dathan Pattishall
Table_cache is a pool of file descriptors held open, so the over head of opening table is not necessary since the open is cached. Max_connections relates to table_cache because they both use descriptors. Thus at least the sum of the 2 is used by mySQL to set the ulimit of file descriptors higher