Re: Optimize Query for ndb 7.2.1....
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
Subject
Views
Written By
Posted
2770
October 18, 2011 01:21AM
988
October 26, 2011 03:35AM
1098
October 26, 2011 06:46AM
Re: Optimize Query for ndb 7.2.1....
1150
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.