MySQL參數設定

1) Startup Variables -- General Parameters

Data Directory

Key buffer --> 64M

Sort buffer size --> 512K

2) Startup Variables -- MyISAM Parameters

Max sort file size --> 512k

Mylsam Sort buffer --> 64M

3) Startup Variables -- Performance

Cache Size --> 64K

4) Startup Variables -- Advanced Networking

Connection timeout --> 30

Max Connections --> 1000