MySQL DB tuning

MySQL DB tuning:

In installation directory

Ex: C:\Program Files\MySQL\MySQL Server 5.0


open my (Configuration Settings) file then
we need to change as per our table creation type MyISAM/INNODB

Ex: For MyISAM below properties need to change as per our requirement

myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=60M
key_buffer_size=26M
read_buffer_size=64K
read_rnd_buffer_size=512K
sort_buffer_size=512K


then you will feel real difference