reduce number of open files ?

reduce number of open files ?

am 08.05.2009 09:43:12 von walter harms

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org