MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<gunmuse Date:June 16 2005 5:17am
Subject:RE: What is best open-source platform alternative to overcome innodb 2Gb memory limit on Linux? FreeBSD?
View as plain text  
I agree The New AMD's (Can't say just opertron) but the 246 and 248 CPU's
are moving data between cpu and Ram at 6 gig per second versus 2gig for the
Xeon's peak right now.

The New opterons communicate with ram better than any other CPU on the
market and with the right MySql setup that is a huge benefit.

My News site platform is going to be moving from Xeon to AMD for that very
reason.  Our software is written to avoid harddrive calls at all cost to
keep our page load super fast.

I would add to his suggestion a RAID 0-1 setup that would double your drive
output speed.

Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.prnewsnow.com  Free content for your website
469 228 2183


-----Original Message-----
From: David Griffiths [mailto:dgriffiths@stripped]
Sent: Wednesday, June 15, 2005 11:17 AM
To: Brady Brown
Cc: mysql@stripped
Subject: Re: What is best open-source platform alternative to overcome
innodb 2Gb memory limit on Linux? FreeBSD?


Why not go AMD-64? Dual Opteron, with 8/16/32 gig of RAM? Get a 3ware
SATA drive, and run Gentoo for AMD-64. You can increase your innodb
buffer pool to use almost all that space. You can make your buffer pool
as large as the physical RAM in your machine can support. No 2.5 gig per
process, 4-gig limit on addressable memory (without the address-extensions).

Your hardware is holding you back more than your operating system.

David





Brady Brown wrote:

> Hi,
>
> I am currently running a large database (around 20Gb) on a 32bit x86
> Linux platform. Many of my larger data-crunching queries are
> disk-bound due to the limitation described in the innodb configuration
> documentation:
>
> *Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
> memory usage too high. |glibc| may allow the process heap to grow over
> thread stacks, which crashes your server. It is a risk if the value of
> the following expression is close to or exceeds 2GB:
>
> Being a responsible citizen, I have my innodb_buffer_pool_size set
> below 2Gb.  But the time has come to scale the application, so I need
> an alternative solution that will allow me to set
> innodb_buffer_pool_size as high as my heart desires (or at least well
> beyond 2Gb).
>
> Do any of you have battle-tested recommendations?
> How about FreeBSD?  From what I can gather, it is a good idea to build
> MySQL on FreeBSD linked with the Linux Thread Library. Would doing so
> re- invoke the 2Gb limit?
>
> I look foward to your collective responses. Thanks!
>
> Brady
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Thread
What is best open-source platform alternative to overcome innodb2Gb memory limit on Linux? FreeBSD?Brady Brown15 Jun
  • Re: What is best open-source platform alternative to overcome innodb2Gb memory limit on Linux? FreeBSD?David Griffiths15 Jun
    • RE: What is best open-source platform alternative to overcome innodb 2Gb memory limit on Linux? FreeBSD?gunmuse16 Jun
      • Need help with a query..Cory Robin16 Jun
        • Re: Need help with a query..Alec.Cawley16 Jun
          • Re: Need help with a query..SGreen16 Jun
            • Re: Need help with a query..Alec.Cawley16 Jun
        • Re: Need help with a query..Frank Bax16 Jun