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/
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
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
