List:Cluster« Previous MessageNext Message »
From:Serdyn du Toit Date:May 17 2013 8:43am
Subject:Re: connect to data node
View as plain text  
Thanks Andrew, appreciated :)

MySql reference on EXPLAIN PARTITIONS:
http://dev.mysql.com/doc/refman/5.6/en/partitioning-info.html


On Thu, May 16, 2013 at 3:59 PM, Andrew Morgan <andrew.morgan@stripped>wrote:

> One simple approach is...
>
> mysql> EXPLAIN PARTITIONS <you're query>;
>
> That will tell you which partitions need to be queried in order to satisfy
> the query - if you're query is a primary-key lookup then that should be
> just the partition holding that row.
>
> Andrew.
>
> > -----Original Message-----
> > From: Serdyn du Toit [mailto:dutoitns@stripped]
> > Sent: 16 May 2013 13:58
> > To: cluster@stripped
> > Subject: connect to data node
> >
> > Hi,
> >
> > New to MySql Cluster - how can I connect to the data node to see what's
> on
> > there?  I want to visually see the partitions data.  Or can one query
> MySql
> > somehow so that it shows you from which data node each row originated?
> >
> > Many thanks,
> > Serdyn du Toit
>

Thread
connect to data nodeSerdyn du Toit16 May
  • RE: connect to data nodeAndrew Morgan16 May
    • Re: connect to data nodeSerdyn du Toit17 May