ispCP - Board - Support
my.cnf für grosse / viele Datenbanken - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega International Area (/forum-22.html)
+--- Forum: German Corner (/forum-26.html)
+---- Forum: Plauderecke (/forum-49.html)
+---- Thread: my.cnf für grosse / viele Datenbanken (/thread-8647.html)

my.cnf für grosse / viele Datenbanken - fulltilt - 12-03-2009 08:58 PM

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