Hello.
I'm not directly answering on your questions, but this link sounds to be helpful: http://hashmysql.org/index.php?title=Opteron_HOWTO Have a look here as well: http://dev.mysql.com/doc/mysql/en/compile-and-link-options.html I'm using official binaries of MySQL in most cases, so I suggest you to do the same. RV Tec <[EMAIL PROTECTED]> 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
