RE: MySQL support for AMD64
Hi there, I have had good success with gentoo (full source install/compile) and MySQL's binaries on Opteron systems. We're running 2 opteron boxes (1 with 16 gigs of RAM, 1 with 32 gigs of RAM) with no problems. We are running at about 1000-2000 queries per second (mostly inserts). Cheers, Mark Steele Implementation Director CDT Inc. -Original Message- From: Lynn Bender [mailto:[EMAIL PROTECTED] Sent: November 30, 2004 2:23 PM To: [EMAIL PROTECTED] Subject: MySQL support for AMD64 I just received a box with the following specs: Dual AMD64 8G ram Two 3ware 2.4 terabyte RAID 5 arrays. My company has been using Redhat for most of its production machines. 1. Does anyone have any success/horror stories running MySQL 4.0.x on RHES 3/ AMD64? 2. Does anyone have alternate recommendations for running MySQL databases in the terabyte range on AMD64? Thanks Lynn Bender UnsubCentral Secure Email List Suppression Management Neutral. Bonded. Trusted. You are receiving this commercial email from a representative of UnsubCentral, Inc. 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 To cease all communication with UnsubCentral, visit http://www.unsubcentral.com/unsubscribe or send an email to [EMAIL PROTECTED] smime.p7s Description: S/MIME cryptographic signature
RE: MySQL support for AMD64
I have 400 AMD 64 box 60 of which have 8 GB of data use for databases. Each server does about 5K qps and many of our clusters do > 30K qps. We use Suse Enterprise Linux 8. I've done numerous benchmarks to know that AMD Operton is a better platform over XEONS period. DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: Donny Simonton [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 01, 2004 12:04 PM > To: 'Steve Poirier'; 'Lynn Bender'; [EMAIL PROTECTED] > Subject: RE: MySQL support for AMD64 > > I've got 3 amd64 machines running mysql. One with 32 gigs of memory and 2 > with 16gigs. All of them are quad 848's. We use fedora core 2 on all of > our boxes. > > 2 of the boxes are pushing over 3000 queries per second. And one is over > 4k > per second. > > Personally, I have about 30 mysql boxes, and I will never buy a non-64 bit > machine again. > > Donny > > > -Original Message- > > From: Steve Poirier [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 01, 2004 8:29 AM > > To: 'Lynn Bender'; [EMAIL PROTECTED] > > Subject: RE: MySQL support for AMD64 > > > > I would recommend Raid 10 over Raid 5 even if it's kinda a big hit on > your > > storage cabality. > > http://www.experts-exchange.com/Storage/Q_20640972.html > > > > > > I'm successfully running a Master/Slave setup with the following > machines: > > Quad Opteron 64 / 32G RAM > > Dual Opteron 64 / 16G RAM > > > > Using gentoo compiled from scratch (stage 1) > > > > 100% stability around 1000 queries / second > > > > > > _ > > Steve > > > > > -Original Message- > > > From: Lynn Bender [mailto:[EMAIL PROTECTED] > > > Sent: November 30, 2004 2:23 PM > > > To: [EMAIL PROTECTED] > > > Subject: MySQL support for AMD64 > > > > > > I just received a box with the following specs: > > > > > > Dual AMD64 > > > 8G ram > > > Two 3ware 2.4 terabyte RAID 5 arrays. > > > > > > My company has been using Redhat for most of its production machines. > > > > > > 1. Does anyone have any success/horror stories running MySQL > > > 4.0.x on RHES 3/ AMD64? > > > > > > 2. Does anyone have alternate recommendations for running > > > MySQL databases in the terabyte range on AMD64? > > > > > > Thanks > > > Lynn Bender > > > > > > > > > > > > > > > UnsubCentral > > > Secure Email List Suppression Management Neutral. Bonded. Trusted. > > > > > > You are receiving this commercial email > > > from a representative of UnsubCentral, Inc. > > > 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 > > > > > > To cease all communication with UnsubCentral, visit > > > http://www.unsubcentral.com/unsubscribe > > > or send an email to [EMAIL PROTECTED] > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL support for AMD64
Hey, I haven't used AMD64's, but we're running our production on a machine with a 3ware 9508 running RAID10 with RHES 3. It's a beautiful setup. The 3ware cards are an excellent choice, but as other posts say, use RAID 10. If possible put your InnoDB logs onto a seperate array as well. out. On Tue, 30 Nov 2004 13:23:05 -0600, Lynn Bender <[EMAIL PROTECTED]> wrote: > I just received a box with the following specs: > > Dual AMD64 > 8G ram > Two 3ware 2.4 terabyte RAID 5 arrays. > > My company has been using Redhat for most of its production machines. > > 1. Does anyone have any success/horror stories running MySQL 4.0.x > on RHES 3/ AMD64? > > 2. Does anyone have alternate recommendations for running MySQL > databases in the terabyte range on AMD64? > > Thanks > Lynn Bender > > > > UnsubCentral > Secure Email List Suppression Management > Neutral. Bonded. Trusted. > > You are receiving this commercial email > from a representative of UnsubCentral, Inc. > 13171 Pond Springs Road, Austin, TX 78729 > Toll Free: 800.589.0445 > > To cease all communication with UnsubCentral, visit > http://www.unsubcentral.com/unsubscribe > or send an email to [EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL support for AMD64
I've got 3 amd64 machines running mysql. One with 32 gigs of memory and 2 with 16gigs. All of them are quad 848's. We use fedora core 2 on all of our boxes. 2 of the boxes are pushing over 3000 queries per second. And one is over 4k per second. Personally, I have about 30 mysql boxes, and I will never buy a non-64 bit machine again. Donny > -Original Message- > From: Steve Poirier [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 01, 2004 8:29 AM > To: 'Lynn Bender'; [EMAIL PROTECTED] > Subject: RE: MySQL support for AMD64 > > I would recommend Raid 10 over Raid 5 even if it's kinda a big hit on your > storage cabality. > http://www.experts-exchange.com/Storage/Q_20640972.html > > > I'm successfully running a Master/Slave setup with the following machines: > Quad Opteron 64 / 32G RAM > Dual Opteron 64 / 16G RAM > > Using gentoo compiled from scratch (stage 1) > > 100% stability around 1000 queries / second > > > _ > Steve > > > -Original Message- > > From: Lynn Bender [mailto:[EMAIL PROTECTED] > > Sent: November 30, 2004 2:23 PM > > To: [EMAIL PROTECTED] > > Subject: MySQL support for AMD64 > > > > I just received a box with the following specs: > > > > Dual AMD64 > > 8G ram > > Two 3ware 2.4 terabyte RAID 5 arrays. > > > > My company has been using Redhat for most of its production machines. > > > > 1. Does anyone have any success/horror stories running MySQL > > 4.0.x on RHES 3/ AMD64? > > > > 2. Does anyone have alternate recommendations for running > > MySQL databases in the terabyte range on AMD64? > > > > Thanks > > Lynn Bender > > > > > > > > > > UnsubCentral > > Secure Email List Suppression Management Neutral. Bonded. Trusted. > > > > You are receiving this commercial email > > from a representative of UnsubCentral, Inc. > > 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 > > > > To cease all communication with UnsubCentral, visit > > http://www.unsubcentral.com/unsubscribe > > or send an email to [EMAIL PROTECTED] > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL support for AMD64
I would recommend Raid 10 over Raid 5 even if it's kinda a big hit on your storage cabality. http://www.experts-exchange.com/Storage/Q_20640972.html I'm successfully running a Master/Slave setup with the following machines: Quad Opteron 64 / 32G RAM Dual Opteron 64 / 16G RAM Using gentoo compiled from scratch (stage 1) 100% stability around 1000 queries / second _ Steve > -Original Message- > From: Lynn Bender [mailto:[EMAIL PROTECTED] > Sent: November 30, 2004 2:23 PM > To: [EMAIL PROTECTED] > Subject: MySQL support for AMD64 > > I just received a box with the following specs: > > Dual AMD64 > 8G ram > Two 3ware 2.4 terabyte RAID 5 arrays. > > My company has been using Redhat for most of its production machines. > > 1. Does anyone have any success/horror stories running MySQL > 4.0.x on RHES 3/ AMD64? > > 2. Does anyone have alternate recommendations for running > MySQL databases in the terabyte range on AMD64? > > Thanks > Lynn Bender > > > > > UnsubCentral > Secure Email List Suppression Management Neutral. Bonded. Trusted. > > You are receiving this commercial email > from a representative of UnsubCentral, Inc. > 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 > > To cease all communication with UnsubCentral, visit > http://www.unsubcentral.com/unsubscribe > or send an email to [EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL support for AMD64
I don't have your configuration but I do have 2 servers running with 3ware controllers (800 or so megs in RAID 5 on each). They are stable and performance is good. I don't run MySQL on these however. I also have an AMD64 box running Fedora/AMD64/MySQL and everything is stable. My AMD64 box is not a production box (sadly I usually buy DELL for servers and they may never offer an Opteron solution). There are others on the list who can tell you what you need to know about running high end MySQL installs but I can tell you RAID5 is probably going to limit your performance. Also you might want to calculate the possible size of indeces as that can affect how much ram you really need. hth, Jason McKnight Mgr. Information Services The InSite Group,LLC Lynn Bender wrote: I just received a box with the following specs: Dual AMD64 8G ram Two 3ware 2.4 terabyte RAID 5 arrays. My company has been using Redhat for most of its production machines. 1. Does anyone have any success/horror stories running MySQL 4.0.x on RHES 3/ AMD64? 2. Does anyone have alternate recommendations for running MySQL databases in the terabyte range on AMD64? Thanks Lynn Bender UnsubCentral Secure Email List Suppression Management Neutral. Bonded. Trusted. You are receiving this commercial email from a representative of UnsubCentral, Inc. 13171 Pond Springs Road, Austin, TX 78729 Toll Free: 800.589.0445 To cease all communication with UnsubCentral, visit http://www.unsubcentral.com/unsubscribe or send an email to [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL support for AMD64
Lynn, - Original Message - From: "Lynn Bender" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, November 30, 2004 9:22 PM Subject: MySQL support for AMD64 I just received a box with the following specs: Dual AMD64 8G ram Two 3ware 2.4 terabyte RAID 5 arrays. My company has been using Redhat for most of its production machines. 1. Does anyone have any success/horror stories running MySQL 4.0.x on RHES 3/ AMD64? 2. Does anyone have alternate recommendations for running MySQL databases in the terabyte range on AMD64? both MyISAM and InnoDB can handle terabyte size databases. About AMD64 + Linux: there seem to be quite a few problems still. I do not know whether it is buggy drivers, bugs in the AMD64 port of the Linux kernel, hardware manufacturing flaws, or even design flaws in AMD64. Some people are happily running Linux on AMD64, some people had to abandon it because of too many problems. Linux developers are working to fix the bugs. Thanks Lynn Bender Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL support for AMD64
Hi Lynn, If you look in the archives you will find some strong recommendations agianst RH and for Suse (performance reasons). (Look for "AMD 64 bit" or "perfomance") I am personally using Debian (sid) which you may not want to do for your production ;-). Suse 9.2 unfortunately seems to be quite buggy (mostly obvious things) That starts with the installation itself. http://www.be-known-online.com/ http://www.be-known-online.com/modules/newbb/viewforum.php?forum=46 Shows some of my personal notes. Dont expect anything spectacular. Anyway I hope that you may find the info useful. BTW I am not running anything near Terabyte operations. Best regards Nils Valentin Tokyo/ Japan > I just received a box with the following specs: > > Dual AMD64 > 8G ram > Two 3ware 2.4 terabyte RAID 5 arrays. > > My company has been using Redhat for most of its production machines. > > 1. Does anyone have any success/horror stories running MySQL 4.0.x > on RHES 3/ AMD64? > > 2. Does anyone have alternate recommendations for running MySQL > databases in the terabyte range on AMD64? > > Thanks > Lynn Bender > > > > > UnsubCentral > Secure Email List Suppression Management > Neutral. Bonded. Trusted. > > You are receiving this commercial email > from a representative of UnsubCentral, Inc. > 13171 Pond Springs Road, Austin, TX 78729 > Toll Free: 800.589.0445 > > To cease all communication with UnsubCentral, visit > http://www.unsubcentral.com/unsubscribe > or send an email to [EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]