Re: Linux+AMD64+MySQL.
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]
Re: Linux+AMD64+MySQL.
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]
Linux+AMD64+MySQL.
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
