Hi All,
Is there anybody using cluster 7.2 version in production ?
Mat,
Can we use it on production ?
- Umapathi.
---------- 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
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
This new capability is called Adaptive Query Localization (AQL), and you can
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-increased-mysql-cluster-join-performance-with-adaptive-query-localization/>
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.php<http://mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php>
Would be very interested in hearing your results
On 22/09/2011 11:00, umapathi b wrote:
> Hi All,
>
> Can anybody share any resources/links which will be useful to optimize
> cluster
> environment ..especially the queries with joins ..
>
> 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 takes
> around 30 seconds in Cluster.
>
> Help is highly appreciated/needed.
>
> Thanks,
> Umapathi.
> umapathi.b@stripped
> 80191 33653
>
>
--
Regards
Mat Keep
MySQL Cluster& HA Programs
Oracle Corp.
+44 (0)7765 898-605
