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.
After some considerations, we have decided to upgrade things in three
steps:
1) Bumped the OS to Gentoo Linux, GCC 3.4.4, glibc 2.4/NPTL, deadline
scheduler, xfs and kernel 2.6.16-gentoo-r7. This, by itself, was already
a great performance improvement. And it is stable/reliable as well.
2) Jumped from 2GB RAM to 16GB, changed RAID card to a dual-channel (so
the database have a channel of its own). This proved that memory was our
greatest bottle neck. I can honestly say that now I'm happy with the
performance.
My question is: key_buffer seems to be the solution to all my problems.
On a 16GB server, I'm using only 37.5% of it to the key_buffer (6144).
If I make this larger, will be a performance improvement or a stability
killer?
With stuff like this I'd suggest a conservative approach. Increase it
slightly, see how the server copes.. increase it slightly again etc
until you find the "sweet spot".
You'll need to run the server for at least a couple of days at each
stage to see what issues the server has with the settings.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
