MySQL 4.1 alpha very slow

------=_NextPart_000_0001_01C32A7E.58C669F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
=20
I installed MySQL 4.1 alpha because I need to make sub-selects in my
queries. This function seems to work perfectly.
=20
But, there is a big difference between MySQL 4.0 and MySQL 4.1. Requests
to the MySQL server slow down considerably.
Version 4.1 returns data about 4 or five times slower than version 4.0.
=20
I remark that this problem occurs only when my connection is on a
distinct computer on my Local Area Network.
If I install the version 4.1 on localhost with same databases, all seems
to work normally.
=20
=20
Thanks for you support
=20
=20
Patrice Soucy
Junior Engineer
LoGEXia inc.
Montr=E9al
Canada

------=_NextPart_000_0001_01C32A7E.58C669F0--

RE: MySQL 4.1 alpha very slow

Are the connection machines (clients) running Windows? =20

There is a known-problem with the 4.1 protocol and Windows clients.=20
If you try to connect via a Linux, or any non-Windows based machine,=20
you should not find the problem. This is issue #485.

You can see that the queries are being performed just as quickly as =
4.0,=20
by connecting locally. =20

This problem is being addressed.

-----Original Message-----
From: Patrice Soucy [mailto:patrice.soucy@logexia.com]
Sent: Wednesday, June 04, 2003 9:48 AM
To: bugs@lists.mysql.com
Subject: MySQL 4.1 alpha very slow


Hi,
=20
I installed MySQL 4.1 alpha because I need to make sub-selects in my
queries. This function seems to work perfectly.
=20
But, there is a big difference between MySQL 4.0 and MySQL 4.1. =
Requests
to the MySQL server slow down considerably.
Version 4.1 returns data about 4 or five times slower than version 4.0.
=20
I remark that this problem occurs only when my connection is on a
distinct computer on my Local Area Network.
If I install the version 4.1 on localhost with same databases, all =
seems
to work normally.
=20
=20
Thanks for you support
=20
=20
Patrice Soucy
Junior Engineer
LoGEXia inc.
Montr=E9al
Canada

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: MySQL 4.1 alpha very slow

Patrice Soucy writes:
> Hi,
> =20
> I installed MySQL 4.1 alpha because I need to make sub-selects in my
> queries. This function seems to work perfectly.
> =20
> But, there is a big difference between MySQL 4.0 and MySQL 4.1. Reque=
sts
> to the MySQL server slow down considerably.
> Version 4.1 returns data about 4 or five times slower than version 4.=
0.
> =20
> I remark that this problem occurs only when my connection is on a
> distinct computer on my Local Area Network.
> If I install the version 4.1 on localhost with same databases, all se=
ems
> to work normally.
> =20
> =20
> Thanks for you support
> =20
> =20
> Patrice Soucy
> Junior Engineer
> LoGEXia inc.
> Montr=E9al
> Canada

HI!

This list is dedicated to bug reports with fully repeatable test
cases.=20

Your report does not provide us with sufficient info on how to
reproduce and measure that.

So far we have only one such report, which we are investigating, and
it is concerning Windows to Windows communication.

--=20

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org