MySQL Forums :: Partitioning :: Mysql 5.5 Partittioning row field


Advanced Search

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 1351 Shubham Jain 06/24/2015 10:19PM
Re: Mysql 5.5 Partittioning row field 978 Jonathan Stephens 06/25/2015 10:16AM
Re: Mysql 5.5 Partittioning row field 801 Rick James 06/26/2015 12:15AM
Re: Mysql 5.5 Partittioning row field 948 Jonathan Stephens 06/26/2015 02:40AM
Re: Mysql 5.5 Partittioning row field 830 Shubham Jain 06/26/2015 07:02AM


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.