Welcome to WebmasterWorld Guest from 54.162.164.247

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:

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)

Senior Member

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

joined:Nov 12, 2005
posts:5966
votes: 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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members