MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize Query for ndb 7.2.1....
Posted by: Ole John Aske
Date: October 26, 2011 08:40AM

In order for us to provide any usefull feedback on this query, can you please provide some more information about your schema, Cluster configuration and the query plan calculated by the optimizer.

To be specific, it would be helpfull to have:

1. EXPLAIN output for that query, both for myISAM and Cluster.

2. Definition of the involved tables and its indexes.

3. ~number of rows in the different tables (If they differs from the EXPLAIN)

4. How was your cluster configured.
- ndbd or ndbmtd
- Number of servers used for deploying these NDB datanodes
- mysqld colocated with NDB or on seperate server.

BTW: Did you run ANALYZE on the NDB tables after they had been created
and filled with data?

Ole John, Cluster team

Options: ReplyQuote

Written By
October 26, 2011 03:35AM
Re: Optimize Query for ndb 7.2.1....
October 26, 2011 08:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.