homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Mysql handler variables

5+ Year Member

Msg#: 4303598 posted 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:

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?




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

Msg#: 4303598 posted 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.


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

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved