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