List:General Discussion« Previous MessageNext Message »
From:walter harms Date:May 8 2009 7:43am
Subject:reduce number of open files ?
View as plain text  
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
Thread
reduce number of open files ?walter harms8 May