From: Andrew Morgan
Date: September 22 2011 1:07pm
Subject: Re: join queries
List-Archive: http://lists.mysql.com/cluster/8117
Message-Id: <BFCBF4B1-AA51-4993-A6ED-BBE621A699C7@oracle.com>
MIME-Version: 1.0 (iPhone Mail 8J2)
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable

MySQL cluster 7.2 is not yet GA and so e wouldn't recommend using it in a pr=
oduction environment. Customers have tried it out but not gone live with it=20=


Regards, Andrew.=20




On 22 Sep 2011, at 14:04, umapathi b <umapathi.b@stripped> wrote:

> Hi All,
>=20
> Is there anybody using cluster 7.2 version in production ?
>=20
> Mat,
> Can we use it on production ?
>=20
> - Umapathi.
>=20
> ---------- Forwarded message ----------
> From: Mat Keep <mat.keep@stripped>
> Date: Thu, Sep 22, 2011 at 6:24 AM
> Subject: Re: join queries
> To: umapathi b <umapathi.b@stripped>
> Cc: cluster@stripped
>=20
>=20
> Hi Umapathi
> The MySQL Cluster 7.2 Development Release would be the best place to start=

> as this includes the Index Statistics function which works with the SQL
> optimizer to create execution plans that push JOIN operations down to the
> cluster data nodes, rather than being resolved in the server - this giving=

> much lower latency
>=20
> This new capability is called Adaptive Query Localization (AQL), and you c=
an
> learn more about it here:
> http://www.clusterdb.com/**mysql-cluster/dramatically-**
> increased-mysql-cluster-join-**performance-with-adaptive-**
> query-localization/<http://www.clusterdb.com/mysql-cluster/dramatically-in=
creased-mysql-cluster-join-performance-with-adaptive-query-localization/>
>=20
> We do also have a performance optimization guide which provides best
> practices on query optimization (note, it does not yet reflect AQL), and
> this can be downloaded from here (registration required):
> http://mysql.com/why-mysql/**white-papers/mysql_wp_cluster_**perfomance.ph=
p<http://mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php>
>=20
> Would be very interested in hearing your results
>=20
>=20
>=20
>=20
> On 22/09/2011 11:00, umapathi b wrote:
>=20
>> Hi All,
>>=20
>> Can anybody share any resources/links which will be useful to optimize
>> cluster
>> environment ..especially the queries with joins ..
>>=20
>> I am trying to migrate my existing environment(MYISAM)  with the same
>> queries and tables to mysql cluster.
>> But a straight forward query which runs in MYISAM within 0.1 seconds take=
s
>> around 30 seconds in Cluster.
>>=20
>> Help is highly appreciated/needed.
>>=20
>> Thanks,
>> Umapathi.
>> umapathi.b@stripped
>> 80191 33653
>>=20
>>=20
> --=20
> Regards
>=20
> Mat Keep
> MySQL Cluster&  HA Programs
> Oracle Corp.
> +44 (0)7765 898-605