Bug #30288 There is no Handler_read_rnd_init counter.
Submitted: 7 Aug 2007 22:18 Modified: 27 Aug 2007 9:28
Reporter: Sergey Petrunya Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Geir H√łydalsvik CPU Architecture:Any

[7 Aug 2007 22:18] Sergey Petrunya
The server has Handler_rnd_next counter but there is no Handler_rnd_init counter (that would count # of scan initializations). This makes it impossible to figure out the average number of scanned records within one table scan.

How to repeat:

Suggested fix:
Introduce two more status variables:

 Handler_rnd_init      - incremented at random-probes table scan intitalization
 Handler_rnd_init_seq  - incremented at sequential table scan intitalization

which would allow to figure out how many records on average are scanned within one sequential table scan and random-probes table scan.