List:Cluster« Previous MessageNext Message »
From:umapathi b Date:September 22 2011 1:09pm
Subject:Re: join queries
View as plain text  
Andrew,

Is there any expected date / time limit for the GA ?

On Thu, Sep 22, 2011 at 9:07 AM, Andrew Morgan <andrew.morgan@stripped>wrote:

> 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