Yes they are very high, also key_buffer_size is a global parameter
shared by all threads, it is recommended to be around 25% of your RAM,
I would suggest since you have 2GB ram the following
key_buffer_size = 500M ( greatly improves speed )
> sort_buffer_size= 2M
> read_buffer_size=2M
> write_buffe
Since I can't get the book until this evening ...
In most sample my.cnf files online I see the following
setup:
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer=16M
write_buffer = 16M
If these are per thread -- aren't they a bit high?
thanks.
erin
--- Kishore Jalleda <[EMAIL PROTECTED
Yes you are right, these are Thread specific settings, leave them at
1M or 2M, atleast that's what I set on our productions systems, else
you risk at running out of memory under high loads, and it works
great, the other parameters as cited in the book High performance
Mysql , by Jeremy Zawodny says
