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
