-
编辑 删除
Performance tuning
InnoDB buffer pool instances: Tune innodb_buffer_pool_instances (InnoDB Disk I/O) to increase read/write threads, and divide InnoDB buffer pool in regions for more performanceThe number of regions that the InnoDB buffer pool is divided into. For systems with buffer pools in the multi-g...
-
编辑 删除
optimize table
SELECT table_name, data_free * 100 / data_length , data_free, data_length FROM information_schema.TABLES WHERE table_schema='dbschemename' Some delete often table will have much fragments, if it's too high and the table data is not too much, could defragment. For INNODB table do...
-
编辑 删除
mysql configurations
Configurations:# Set buffer pool size to 50-80% of your computer's memoryinnodb_buffer_pool_size=256Minnodb_additional_mem_pool_size=20M## Set the log file size to about 25% of the buffer pool sizeinnodb_log_file_size=64Minnodb_log_buffer_size=8Mmemory usageinnodb_buffer_pool_size+ k...
