[dba-Tech] 64 bit MYSql on 64 bit linux

Gustav Brock gustav at cactus.dk
Sat Jun 30 03:05:33 CDT 2007


Hi John

The Action Pack will contain Windows Server 2003 R2 and 2008 Beta 3 both in 64-bit:
https://partner.microsoft.com/40013779

The /3GB switch allocates more user mode memory but only to certain applications (like Exchange 2003 and SQL Server) prepared for this:
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
A lot more on this can be read here:
http://blogs.msdn.com/oldnewthing/archive/2004/08/05/208908.aspx

/gustav

>>> jwcolby at colbyconsulting.com 30-06-07 0:26 >>>
Yea I hear you.  My issue is that in the 32 bit (windows) world, you only
get 2gb assigned to the application.  When you are trying to join a long (8
byte) from 65 million records with a long on 50 million records...  You can
use up a fair portion of your memory just on getting the join data into
memory, never mind any other data.  Not that I have a clue how SQL Server
actually implements a join but still, you get my point here.

I can afford (and my machines can handle) 8 gbytes but Windows 32 simply
doesn't use it unless you step up to the advanced versions of Windows and
then you start bleeding through the nose in licensing fees.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, June 29, 2007 5:52 PM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] 64 bit MYSql on 64 bit linux

Hi John:

I have been working with a 64bit version of Oracle but it was a nightmare to
install as the hardware and the OS did not like each other and though I
think it now has been changing, the drivers were/are still only 32bit and
not very compatible. I experienced issues with sound, LAN connections, video
displays and even printers.

There were no obvious performance improvements over a 32bit DB version, on
the same 64bit platform but I was only working with files of 100,000 records
and less and not 10 of millions.
 
The latest version of Linux/Vista/Server2003 are supposed have resolved
these issues but I will be taking the wait and see approach before I make
the next foray in the world of the 64bit.

Jim 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, June 29, 2007 1:45 PM
To: 'Access Developers discussion and problem solving'; 'Discussion of
Hardware and Software issues'; dba-sqlserver at databaseadvisors.com
Subject: [dba-Tech] 64 bit MYSql on 64 bit linux

Is anyone using 64 bit database / OS software?  My databases are so large
that having 2 mb memory constraints are killing me (gut feeling here).  But
once I start looking at x64 versions of Windows Server and in particular x64
versions of SQL Server the prices skyrocket.  I will be paying more for the
licenses for those two things (for EACH processor chip) than I will for the
entire machine hardware, and it is pretty heavy duty hardware.

Thus I need to at least examine Linux / MySQL assuming that I can get 64 bit
versions.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com





More information about the dba-Tech mailing list