Jim Lawrence
accessd at shaw.ca
Fri Jun 29 18:53:34 CDT 2007
Hi John: I hate to say it but the 64bit Linux OS; http://www.ubuntu.com/news/Ubuntu704Beta and http://releases.ubuntu.com/feisty/ might be the OS on which to go for and that may have you losing .Net though I have heard Mono http://www.mono-project.com/Main_Page might be worth investigating and then you would have to go with the 64bit MySQL Community Server: http://dev.mysql.com/downloads/mysql/5.0.html (son-in-law is running a site with approximately 38 million records on MySQL.) or you could try the full 64bit Oracle Enterprise version http://www.oracle.com/technology/software/products/database/oracle10g/index. html, download and run for free but if you need help you have to patch up and pay up. And then there is the 64bit MS SQL trial version (180 days) http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx Here is a list of the top computer site and their OS of choice: http://www.top500.org/stats/list/29/osfam Then there is always VMWare (and its testing capability software: http://www.petri.co.il/virtual_run_a_64_bit_guest_operating_system_in_vmware .htm) and that will allow the use of Windows apps. HTH 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 3:26 PM To: 'Discussion of Hardware and Software issues' Subject: Re: [dba-Tech] 64 bit MYSql on 64 bit linux 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