InnoDB Performance help
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!
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.