RV Tec wrote:
Folks,
A few months ago, I came here asking for directions on how I could
improve performance of MySQL. Back then, I was using OpenBSD on a dual
Opteron 248 with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was
(still is) 4.0.27, the database is MyISAM, reaching 50GB.
Af
RV, you may find that increasing the size of the key_buffer could have
a negative effect on performance. You want to make sure that there's
enough physical RAM for all the processes on the machine, to avoid
paging/swapping to disk, which is very slow.
Here's a an interesting note:
http://dev.mys
Folks,
A few months ago, I came here asking for directions on how I could improve
performance of MySQL. Back then, I was using OpenBSD on a dual Opteron 248
with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was (still is)
4.0.27, the database is MyISAM, reaching 50GB.
After some consid
