| Mysql handler variables
|
Mister_L
msg:4303600 | 1:14 pm on Apr 25, 2011 (gmt 0) |
I have a MyISAM table called products with primary key on the field product_id.The table currently has 47 rows. I'm trying to get an accurate statistics on number of rows that need to be scanned to execute a query.So I did the following:
1. FLUSH STATUS
2. SELECT product_id FROM products
3. SHOW STATUS LIKE "Handler%"
I thought I should be getting Handler_read_next=47, but instead I'm getting Handler_read_rnd_next=10, Handler_write=9,and all rest are zero. Why is that?
Thanks.
|
eelixduppy
msg:4308471 | 8:45 pm on May 5, 2011 (gmt 0) |
I would look into using the EXPLAIN or EXPLAIN EXTENDED syntax for additional information as to how your queries are being executed.
[dev.mysql.com...]
although it does seem strange that the value is off, unless something else is going on behind the scenes.
|
|
|
