Mysql.ini CPU High Optimization method

MySQL tutorial. ini CPU High optimization method

The greater the tmp_table_size=200m tmp_table_size, the greater the probability of being converted to disk TMP table

Small

PHP Tutorial Program page MySQL closed in time

Set the MySQL timeout time

Low-priority-updates set query and update priority and

Low_priority_updates = no; set Read priority

Wait_timeout = 10; It'll take about 10 seconds.

The larger the table_cache=1024 physical memory, the larger the setting. Defaults to 2402, to 512-1024 best

According to the general MySQL Memory computing company:
1) system use, assuming that 800m is reserved;
2 thread exclusive, about 4.5GB = 151 * (10m + 10m + 5m + 5m + 512k), the composition is approximately as follows:
sort_buffer_size:10m
join_buffer_size:10m
Read_buffer_size:5m
Read_rnd_buffer_size:5m
thread_stack:512kb
3) MyISAM Key cache
Key_buffer_size 2.4g
4 InnoDB buffer pool: ignored, the system currently does not have a InnoDB storage engine table.