my.cnf für grosse / viele Datenbanken

[fulltilt]

Hat jemand von Euch eine gute my.cnf config für grosse Datenbanken - bzw. einen Vorschlag um die unten angegebenen Settings zu optimieren ...
vor allem Table cache und max open files - wie weit kann ich da gehen?
Tuning Primer sagt es sollte so ziemlich alles hochgeschraubt werden:

Code:

Mem:   4117176k total,  3976032k used,   141144k free,   466076k buffers
Swap:  4200988k total,        0k used,  4200988k free,  2248012k cached

Code:

TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 29715 temp tables, 77% were created on disk

OPEN FILES LIMIT
Current open_files_limit = 5006 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
You currently have open more than 75% of your open_files_limit
You should set a higher value for open_files_limit in my.cnf

TABLE CACHE
Current table_cache value = 2048 tables
You have a total of 10177 tables
You have 2048 open tables.
Current table_cache hit rate is 2%, while 100% of your table cache is in use
You should probably increase your table_cache