MySQL Forums
Forum List  »  Performance

InnoDB Performance help
Posted by: Phoenix Kiula
Date: April 12, 2009 08:48AM

Hi,

My phpmyadmin is showing me the following in red --

Innodb_buffer_pool_reads  	5,506  	
The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read. 

Handler_read_rnd  	785 k  	
The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.

Handler_read_rnd_next 	295 M 	
The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.

Any recommendations on improving the performance?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB Performance help
3006
April 12, 2009 08:48AM
1738
April 12, 2009 04:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.