Mysql tutorial. ini cpu too high Optimization Method
The larger the tmp_table_size = 200 m tmp_table_size, the more likely it is to be converted to disk tmp table.
Small
Php tutorial program page mysql closed in time
Set mysql timeout
Low-priority-updates
Low_priority_updates = no; set the read priority
Wait_timeout = 10; about 10 seconds.
Table_cache = 1024 the larger the physical memory is, the larger the setting will be. The default value is 2402. The optimal value is adjusted to 512-1024.
According to General mysql memory computing companies:
1) used by the system. Assume that 800 m is reserved;
2) Exclusive thread, about 4.5 gb = 151*(10 m + 10 m + 5 m + 5 m + 512 k), the composition is roughly as follows:
Sort_buffer_size: 10 m
Join_buffer_size: 10 m
Read_buffer_size: 5 m
Read_rnd_buffer_size: 5 m
Thread_stack: 512kb
3) myisam key cache
Key_buffer_size 2.4g
4) innodb buffer pool: Ignore. Currently, the innodb Storage engine table does not exist.