In this recipe, we will cover some simple techniques to get the most performance out of storage nodes in a MySQL Cluster.
This recipe assumes that your cluster is already working and configured, and discusses specific and simple tips to improve performance.
MySQL Cluster supports a conditional pushdown feature, which allows for a significant reduction in the amount of data sent between SQL and storage nodes during the execution of a query. In typical storage engines, a WHERE
query is executed at a higher level than the storage engine. Typically, this is a relatively cheap operation as the data is being moved around in memory on the same node. However, with MySQL Cluster, this effectively involves moving every row in a table from the storage nodes that they are stored on to the SQL node where most of the data is potentially discarded. Conditional Pushdowns move this filtering of unnecessary rows into the storage engine. This means that the WHERE...