GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Handler_read Increments with Covering Index?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Handler_read Increments with Covering Index?

    Has anyone noticed that Handler_read_key and Handler_read_next will get incremented even on a query that never reads any rows (i.e. has a covering index)?

    I've been trolling source and can't quite find the method before ha_myisam::index_read() is called where a covering index check is performed to prevent row read.

  • #2
    How are you finding this? From SHOW STATUS? SHOW STATUS will itself create a temp table and insert into it, then read back from it.

    Comment

    Working...
    X