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=arch...@jab.org