In MySQL 5.7.3 index condition pushdown is also working on partitioned tables as stated here https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html.

Previously, index condition pushdown was not supported for partitioned tables. This limitation was removed in MySQL 5.7.3.

Can't find any information about MariaDB 10.2. I know it is in RC stage but maybe somebody knows about it.

In 10.1 without partitioning: Extra: Using index condition; Using where; Using filesort

In 10.1 with partitioning on: Extra: Using where; Using filesort


  • Nothing in the changelogs through 10.2.4.
    – Rick James
    Mar 31, 2017 at 22:46

1 Answer 1


Support for ICP on partitioned tables was added on this MySQL commit:

You can check reliably if there is support for in a particular version of MySQL or MariaDB by running the corresponding test.

I do not see such code backported on MariaDB's 10.2-tagged git nor on the offered source downloads.

However, the code doesn't look like insanely crazy, so I would suggest to file a ticket on MariaDB's Jira and ask to backport it. I have searched it briefly and failed to see a similar request. I am a heavy MariaDB and partitioning user and that would be indeed a nice feature to have.

  • Please comment here if you do it with the ticket number- otherwise, I will file it myself.
    – jynus
    Mar 30, 2017 at 9:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.