From: walter harms
Date: May 8 2009 7:43am
Subject: reduce number of open files ?
List-Archive: http://lists.mysql.com/mysql/217454
Message-Id: <4A03E290.9090702@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

hi list,
i am wondering if there is a way to reduce the number of open files.
The database has InnoDB and MyISAM. I have a lot a partitions is that a problem ?
(To many open files causes problems for mysqldump)

running is vanilla 5.1.34

 show status like '%open%' ;
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Com_ha_open              | 0     |
| Com_show_open_tables     | 0     |
| Open_files               | 12437 |
| Open_streams             | 0     |
| Open_table_definitions   | 192   |
| Open_tables              | 362   |
| Opened_files             | 14520 |
| Opened_table_definitions | 0     |
| Opened_tables            | 0     |
| Slave_open_temp_tables   | 0     |
+--------------------------+-------+


re,
 walter