Re: Win32 MySQL vs. Linux MySQL - Peter Carter - com.mysql.lists.win32

8 messages in com.mysql.lists.win32Re: Win32 MySQL vs. Linux MySQL

From	Sent On	Attachments
Robert Bütof	26 Jul 1999 02:30
Robert Bütof	27 Jul 1999 03:54
Christopher R. Jones	28 Jul 1999 07:49
Simson L. Garfinkel	28 Jul 1999 08:21
Peter Carter	28 Jul 1999 11:44
Simson L. Garfinkel	28 Jul 1999 12:15
Peter Carter	28 Jul 1999 13:35
Michael Widenius	01 Aug 1999 19:13

Subject:	Re: Win32 MySQL vs. Linux MySQL
From:	Peter Carter (pet...@pbc.ottawa.on.ca)
Date:	07/28/1999 01:35:16 PM
List:	com.mysql.lists.win32

At 03:15 PM 7/28/99 -0400, you wrote:

Peter,

Nice analysis, Peter. A few things, though:

1) MySQL does not require a super-fast file system. The application cache's the data quite well. Drive IO is not a big factor in choosing a platform.

I disagree. I'm running a database with 8 million records. We're seeing somewhere between 5% and 10% CPU utilization on inserts, becuase of drive IO issues.

My thought on this was more along the lines of comparing file system pigs like oracle etc... But on large scale operations I will give you this one ;)

Linux's strength is a super fast drive system. NT's strength is a transaction-based file system (NTFS), which means it can be recovered (rolled back). Since speed is not an issue, I would have a preference for the latter.

Having lost considerably more data on NTFS than on Unix filesystems, I think that your preference is misplaced.

Point taken.