Re: Left Join slow on Windows

[SGreen]

I think the "set-variable=" format is deprecated (but that depends on your 
version). I would try changing your my.ini file to look like:

[mysqld-nt]
myisam_max_sort_file_size=2147483647
myisam_max_extra_sort_file_size=268435456

and if that doesn't work:

[mysqld-nt]
myisam-max-sort-file-size=2147483647
myisam-max-extra-sort-file-size=268435456

I think you will also need to cycle (stop then restart) your MySQL service 
to get those changes to take effect. 

I would also check to see if you have a "my.cnf" file anywhere on your 
system. If you do. Delete it or rename it.  You only need the my.ini file.

I would also compare the results of SHOW CREATE TABLE xxx  between your 
two servers to make sure there are no additional indexes on your Linux 
copy.

Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine




John McQuillen <john@stripped> wrote on 07/23/2004 01:18:41 AM:

> 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_" ;-)
> > 
> > Petr Vileta, Czech republic
> > 
> 
> 
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/win32?unsub=1
>