What value to use for system variable table_cache

[Ananth Reddy]

Hi,

I am wondering if anyone can shed some light on the appropriate values to use for variable table_cache

We have a database with almost 400-500 tables. All of them are MyISAM and some of them are created on the fly and also dropped by application.
We have not tuned this variable and here are what we have in production

table_cache | 357 |

Here are status values related to this variable


| Created_tmp_disk_tables | 2 |
| Created_tmp_tables | 115265 |
| Open_tables | 357 |
| Opened_tables | 21656 |

Also would like to know how this is related to system resources like memory, file descriptors etc..

Appriciate any help

TIA


ananth