Tag - ICP

ICP Counters in information_schema.INNODB_METRICS

ICP Counters

In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series. 
As mentioned in the previous post, in this blog we will look at how to check on ICP counters on MySQL and Percona Server for MySQL. This also applies to […]

Read more

MariaDB Handler_icp_% Counters: What They Are, and How To Use Them

Handler_icp_% counters

In this post we’ll see how MariaDB’s Handler_icp_% counters status counters (Handler_icp_attempts and Handler_icp_matches) measure ICP-related work done by the server and storage engine layers, and how to see if our queries are getting any gains by using them.
These counters (as seen in SHOW STATUS output) are MariaDB-specific. In a later post, we will […]

Read more