Daily Archives - May 9, 2017

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