MySQL Forums
Forum List  »  Partitioning

Mysql 5.5 Partittioning row field
Posted by: Shubham Jain
Date: June 24, 2015 10:19PM

I have created a partition on my table based on a column value. I am using mysql 5.5

ALTER TABLE tab partition by list(ARCHIVE) (partition p0 values in (0), partition p1 values in (1));

Now when I am running following commands:-

1. select count(*) from tab where archive=0;
In this, no of rows is coming as 198182

2. explain partitions select count(*) from tab where archive=0;
In output of this command, in row field I am getting 195934

Can someone explain why there is a difference between 2 results? Is rows field in explain partitions mean something else?

Please explain.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 5.5 Partittioning row field
1521
June 24, 2015 10:19PM


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.