Hello, A new question has been asked in "Spider" by lokeshkumar-p-417: -------------------------------- Hi, We are using Spider storage engine for sharding with MariaDB. MariaDB version - 10.0.10 Spider version - 3.2 Platform - CentOs 6.5 Problem: ---------------- We have a simple scenario, where we have a table with Spider storage engine, which is list partitioned based on a column. Each partition is pointing to a shard. Whenever a query is fired from the Master database with a WHERE clause, the WHERE condition is not being pushed to the shard, instead all the data from shard is being transferred to the DB where Spider storage engine is present. I came to know that this issue has been fixed in the Spider storage engine, and also I verified the MariaDB 10.0.9-spider-3.2 source code and it has cond_push and cond_pop functions. Please let me know how else can I enable this condition pushdown. Regards, -Lokesh Kumar -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/spider-storage-engine-condition-pushdown/