RV Tec wrote:
Folks,
I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give
Linux a shot, to see if I could gain some serious performance. The
server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320.
CentOS 4.1 x86_64 seems to be a good OS.
Although I thought that the most interesting thing in running
Linux+MySQL was the fact that LinuxThreads is available, the binaries
are using pthreads.
When I try to compile my own MySQL (pretty much the same way as the RPM
is created, except that I'm trying LinuxThreads), everything goes
smoothly, but the servers crashes with Signal 11 every 10, maybe 5
minutes. When I compile it with pthreads, everything is back to normal.
I'm trying with MySQL 4.1.10a (I've tried the 4.0.25, 4.1.14 as well),
with Centos 4.1 x86_64, Kernel 2.6.9-11.ELsmp.
So, I've a few questions, maybe you guys can help:
1) pthreads is safer, but LinuxThreads is way faster?
2) What's the best io scheduler for 20GB MyISAM DB? I'm currently using
cfq.
3) Does anyone have any tips on running MySQL+AMD64+Linux?
Thanks a lot!
Best regards,
RV
We fought this exact setup for some time. Some things I learned and our
setup:
- gcc 3.4 (we are using 3.4.3)
- glibs 2.4.4 (w/ NPTL)
- deadline scheduler
- xfs for filesystem
- 2.6 kernel
- custom build of mysql 4.1
Everything else was either non-performant or unstable. Also, stay away
from Fedora. We ended up switching to Gentoo and had massive
performance and stability gains from the switch, but the reasons are
more to do w/ gcc and glibc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]