16 messages in com.mysql.lists.win32Re: MySQL 3.23.56 slow on win32?
FromSent OnAttachments
Jon Martin Solaas21 Apr 2004 08:10 
Petr Vileta21 Apr 2004 15:26 
Jon Martin Solaas21 Apr 2004 15:42 
Randy Clamons21 Apr 2004 16:35 
Jon Martin Solaas21 Apr 2004 16:49 
Petr Vileta21 Apr 2004 16:53 
Jon Martin Solaas21 Apr 2004 17:07 
Randy Clamons21 Apr 2004 17:33 
Petr Vileta21 Apr 2004 19:49 
Raúl D. Pittí Palma21 Apr 2004 21:13 
Raul pitti21 Apr 2004 21:37 
Jon Martin Solaas22 Apr 2004 01:09 
Jon Martin Solaas22 Apr 2004 01:14 
Jon Martin Solaas22 Apr 2004 01:18 
Mike M Brando22 Apr 2004 10:23 
Jon Martin Solaas22 Apr 2004 22:34 
Subject:Re: MySQL 3.23.56 slow on win32?
From:Jon Martin Solaas (jon.@objectlabs.no)
Date:04/21/2004 05:07:09 PM
List:com.mysql.lists.win32

Hi Petr

It's generally useful to know how to make quick backups/imports/exports, however the main problem is the speed of my queries, not importing data.

The differences in speed I experience suggests that MySQL almost doesn't run at all on Win32, which is pretty weird, and not what most other users experience (I hope)...

Thanks anyway.

-- Jon Martin Solaas

On Thu, 2004-04-22 at 01:54, Petr Vileta wrote:

Thanks, this is useful, but still it doesn't answer my question, why is MySQL so slow on Windows, and it doesn't run my massage script either, which is written in php, by the way...

Importing the dump on my P4 3.06 GHz Linux machine took under one minute today, as opposed to many hours (and still not finished) on a WinXP P4 1.8 GHz.

EWeek had a benchmark some time ago, testing several databases (and jdbc-drivers) on Win32, MySQL was about as fast as Oracle, so clearly MySQL will perform well on Win32 given certain conditions I obviously don't know about ...

If you use the same version of MySQL on both platform, you can use a "brute force" backup ;-) 1) copy tables on Linux to another (unused) database with indexes 2) stop mysql server on Windows 3) simple copy all files from Linux (*.frm, *.MYD, *.MYI) to appropriate directory on Windows 4) start mysql server on Windows

Nothing is more quickly then this :-)

Petr Vileta, Czech republic