18. MyISAM of MySQL memory optimization

1.Key_buffer index block size set global Hot_cache. key_buffer_size =1024x768; //set Size show variables like'key_buffer_size'; View size PS::cannot delete the default Key_buffer size cacheIndexEMP in Hot_cache; //Assigning an Hot_cache index block to an EMP table==========================================Pre-loading of key_buffer via configuration file:; ==========================================key_buffer_size=2G Setting Size E1. key_buffer_size =1G Set the size named E1 E2. key_buffer_size =1G Set the size named E2 Init_file= C:/init.SQL startup load SQL file init. SQL,The contents are as follows: CacheIndexWww.E1 in E1; assigning E1 to E1 table cacheIndexWww.E2 in E2; assigning E2 to E2 table loadIndexinto Cache www.e1,www.E2; start preload2.Key_cache_division_limit Control Cache Scale set global Hot_cache. Key_value_division_limit = -; set Size