Comments on: MariaDB Handler_icp_% Counters: What They Are, and How To Use Them https://www.percona.com/blog/mariadb-handler_icp_-counters-what-they-are-and-how-to-use-them/ Thu, 11 May 2017 21:56:18 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Agustín https://www.percona.com/blog/mariadb-handler_icp_-counters-what-they-are-and-how-to-use-them/#comment-10968070 Thu, 11 May 2017 21:38:57 +0000 https://www.percona.com/blog/?p=43355#comment-10968070 Hi Øystein!

Indeed, I may have chosen incorrect wording while trying to be brief. Thanks! I’ll have it edited so it can point to your comment.

]]> By: Øystein Grøvlen https://www.percona.com/blog/mariadb-handler_icp_-counters-what-they-are-and-how-to-use-them/#comment-10968069 Wed, 10 May 2017 08:56:26 +0000 https://www.percona.com/blog/?p=43355#comment-10968069 Hi Agustín,
Thanks for bringing attention to Index condition pushdown.

I would not say that the main advantage of Index Condition Pushdown (ICP) is that ‘the rows that were “saved” from being checked in the server layer’. The major benefit is that the storage engine may skip look-ups into the main table. In your example, a table look-up on primary key is needed to find the value of f3 since that column is not in the index. Using ICP, this look-up is avoided for rows where the condition on f2 is false.

]]>