Welcome to WebmasterWorld Guest from 54.145.209.34

Forum Moderators: open

Mysql handler variables

   
1:14 pm on Apr 25, 2011 (gmt 0)

5+ Year Member



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.
8:45 pm on May 5, 2011 (gmt 0)

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 5+ Year Member



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.
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month