Apache Friends Support Forum

Hi,

I've installed Xampp for Windows version 1.7.2 and located the settings file at C:\xampp\mysql\bin\my.ini

I've got a large database (20 million records) and am running PHP scripts (I've adjusted php.ini) that are quite demanding - e.g. updaing or looping through all records.

I'd really appreciate any advice people could give as to changing the settings of my.ini to speed things up as much as possible - unfortunately I don't really know much about memory sizes.

The values that I (think) I might need to change are:

Code: Select all

skip-locking
key_buffer              = 16M
max_allowed_packet      = 1M
table_cache             = 64
sort_buffer_size        = 512K
net_buffer_length       = 8K
read_buffer_size        = 256K
read_rnd_buffer_size    = 512K
myisam_sort_buffer_size = 8M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


(In case it helps, I have a Windows Vista 32bit, Dual Core Processor with 3.5GB RAM). Could anyone recommend what settings I should change and the possible values that they can go up to? Thanks