Re: Left Join slow on Windows - John McQuillen - com.mysql.lists.win32

6 messages in com.mysql.lists.win32Re: Left Join slow on Windows

From	Sent On	Attachments
John McQuillen	22 Jul 2004 17:19
Petr Vileta	22 Jul 2004 17:51
John McQuillen	22 Jul 2004 22:18
SGr...@unimin.com	23 Jul 2004 05:44
Gerhard Brauckmann	05 Aug 2004 01:50
Cesar Vega	05 Aug 2004 06:54

Subject:	Re: Left Join slow on Windows
From:	John McQuillen (jo...@mcquillen.bur.st)
Date:	07/22/2004 10:18:19 PM
List:	com.mysql.lists.win32

All of the max_* variables agree between the servers, however, the windows server does not have "max_seeks_for_key".

There are two variables that appear relevant and do disagree significantly however.

myisam_max_sort_file_size=256 on windows myisam_max_sort_file_size=268435456 on linux

myisam_max_extra_sort_file_size=2047 on windows myisam_max_sort_file_size=2147483647 on linux

If I add the new values into my.ini the old variable values seem to remain. My.ini looks like this:

[WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe QueryInterval=10

[mysqld-nt] set-variable = myisam_max_sort_file_size=2147483647 set-variable = myisam_max_extra_sort_file_size=268435456

The new values don't seem to be accepted. Am I doing something wrong?

Regards,

John...

On Fri, 2004-07-23 at 10:52, Petr Vileta wrote:

I am experiencing problems with a query which is slow (16sec) on Windows but not on Linux (2sec).

Can anyone suggest why the query would be so slow on Windows, and perhaps recommend a solution? I am having problems with PHP timing out before it can display the results of this particular query.

Because Bill Gates :-) Have you the same MySQL configuration on both PCs? Compare SHOW VARIABLES on both ant take look to every what begin "max_" ;-)