Buy Percona ServicesBuy Now!

Prefix Index Queries Optimization

Percona Server has ported Prefix Index Queries Optimization feature from Facebook patch for MySQL.

Prior to this InnoDB would always fetch the clustered index for all prefix columns in an index, even when the value of a particular record was smaller than the prefix length. This implementation optimizes that case to use the record from the secondary index and avoid the extra lookup.

Status Variables

variable Innodb_secondary_index_triggered_cluster_reads
Version Info:
Variable Type:

Numeric

Scope:

Global

This variable shows the number of times secondary index lookup triggered cluster lookup.

variable Innodb_secondary_index_triggered_cluster_reads_avoided
Version Info:
Variable Type:

Numeric

Scope:

Global

This variable shows the number of times prefix optimization avoided triggering cluster lookup.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.