MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:tinys xuefer Date:July 25 2004 12:26pm
Subject:what does Rows_examined mean exactly?
View as plain text  
slow.log:
# Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327
SELECT * FROM `post` LIMIT 771297, 30;
i dp have privmary key on table `post`
does 'Rows_examined: 771327' means mysqlserver read through those 771327 
rows to get 30 rows?
it takes 14 seconds!

possible to show 'Rows_examined' in a explain or other commands? slow log is 
hard to debug..

and possible to optimize?

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

Thread
what does Rows_examined mean exactly?tinys xuefer25 Jul
  • Re: what does Rows_examined mean exactly?Michael Stassen25 Jul
Re: what does Rows_examined mean exactly?tinys xuefer26 Jul