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?
3) Upgrade MySQL 4.0.27 to MySQL 5.0 -- this is going to be painful, but
it is already on the way.
Thanks a lot!
RV
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]