MySQL Forums
Forum List  »  Partitioning

Re: I divided table on two parts, but MySQL scanning full table
Posted by: Rick James
Date: February 08, 2012 05:45PM

The EXPLAIN PARTITIONS is saying two things:
1. _only_ p2 will be used.
2. _approximately_ 100000 rows will need to be scanned.
#1 can be trusted; #2 is often rather inaccurate.

If you do this before and after the SELECT, I think you will find a _difference_ of 30000 (or maybe 30001) for one of the values:
SHOW SESSION STATUS;
(probably in the Handler% and/or Innodb% values)

If you don't find that, then show us what you got, and we will dig further.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I divided table on two parts, but MySQL scanning full table
1937
February 08, 2012 05:45PM


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.