List:Cluster« Previous MessageNext Message »
From:Andrew Morgan Date:September 22 2011 1:07pm
Subject:Re: join queries
View as plain text  
MySQL cluster 7.2 is not yet GA and so e wouldn't recommend using it in a production
environment. Customers have tried it out but not gone live with it 

Regards, Andrew. 




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

> 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