Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Mysql handler variables

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

Junior Member

5+ Year Member

joined:Jan 21, 2009
posts: 69
votes: 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:

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?

8:45 pm on May 5, 2011 (gmt 0)

Senior Member

joined:Nov 12, 2005
votes: 0

I would look into using the EXPLAIN or EXPLAIN EXTENDED syntax for additional information as to how your queries are being executed.


although it does seem strange that the value is off, unless something else is going on behind the scenes.