OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
reduce number of open files ?

From: walter harms (wharmsbfs.de)
Date: Fri May 08 2009 - 02:43:12 CDT

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