MySQL Forums
Forum List  »  NDB clusters

Re: engine_condition_pushdown
Posted by: Adam Dixon
Date: October 10, 2006 05:02PM

If you run;
mysql> show variables like '%pushdown%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| engine_condition_pushdown | OFF |
+---------------------------+-------+
1 row in set (0.00 sec)


And its ON, then it probably is using pushdown, you will only actually see whether it is being used by using 'explain' on a few non indexed queries.
explain select c1 from t1 where non_indexed_col = 'abc';

Will say something like WHERE with pushed condition.

Adam

Options: ReplyQuote


Subject
Views
Written By
Posted
3429
October 10, 2006 02:57PM
Re: engine_condition_pushdown
1391
October 10, 2006 05:02PM


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.