How to configure "my.ini" to get the best out of my pc?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to configure "my.ini" to get the best out of my pc?

Postby PJB » 04. May 2010 17:42

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
PJB
 
Posts: 1
Joined: 04. May 2010 17:11

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests