ä¿®æ¹è¿ä¸ä¸ªåæ°ç大å°ï¼å¨my.inié
ç½®æ件ä¸ï¼
performance_schema_max_table_instancesãtable_definition_cacheãtable_open_cacheã
é»è®¤å¼å¦ä¸ï¼
performance_schema_max_table_instances 12500
table_definition_cache 1400
table_open_cache 2000
解éï¼
performance_schema_max_table_instances :The maximum number of instrumented table objects.
table_definition_cache:
The number of table definitions (from .frm files) that can be stored in the definition cache
table_open_cache:The number of open tables for all threads.
ä¿®æ¹ä¸ºï¼
performance_schema_max_table_instances 2500
table_definition_cache 400
table_open_cache 400
å
å使ç¨éä¼ä¸éä¸å°ã
è®°å¾ä¿®æ¹å°iniæ件ä¸
追é®ä¸ç®¡ç¨ï¼ï¼ï¼è¿ä¸ªè§£å³æ¹æ¡æå°è¯è¿å¾å¤æ¬¡äºããå°±æ¯ä¸èµ·ä½ç¨å¦