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
>
