List:Cluster« Previous MessageNext Message »
From:umapathi b Date:September 22 2011 1:04pm
Subject:Re: join queries
View as plain text  
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

Thread
join queriesumapathi b22 Sep
  • Re: join queriesMat Keep22 Sep
    • Re: join queriesumapathi b22 Sep
      • Re: join queriesAndrew Morgan22 Sep
        • Re: join queriesumapathi b22 Sep
          • Re: join queriesMat Keep22 Sep
  • Re: join queriesVinay Joosery16 Feb