MySQL Forums
Forum List  »  Partitioning

Partitions by key alternatively empty
Posted by: Mat N
Date: December 10, 2010 06:24AM

Hello,

I've a question concerning the partitioning by key of a large table.

Here is the create table :

CREATE TABLE `IREP_TOOLONE_TRANSACTIONS_P_OLD` (
`Key_Id` char(35) NOT NULL,
`TRANSACTION` varchar(40) DEFAULT NULL,
`TYPE` varchar(1) DEFAULT NULL,
`REQNO_ORDERNR_TRANSACTION` varchar(8) DEFAULT NULL,
`STORE` varchar(4) DEFAULT NULL,
`TNINO_TNRNO` decimal(22,0) DEFAULT NULL,
`NSN` varchar(18) DEFAULT NULL,
`QTY` decimal(22,0) DEFAULT NULL,
`IR` varchar(1) DEFAULT NULL,
`RECURRENT` varchar(1) DEFAULT NULL,
`TRANSDATE` date DEFAULT NULL,
PRIMARY KEY (`Key_Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
/*!50100 PARTITION BY KEY (key_id)
PARTITIONS 10 */

My problem is the following :

mysql> select partition_name,table_rows from partitions where table_name = 'IREP_TOOLONE_TRANSACTIONS_P_OLD';
+----------------+------------+
| partition_name | table_rows |
+----------------+------------+
| p0 | 2883072 |
| p1 | 0 |
| p2 | 2887036 |
| p3 | 0 |
| p4 | 2884609 |
| p5 | 0 |
| p6 | 2886056 |
| p7 | 0 |
| p8 | 2883555 |
| p9 | 0 |
+----------------+------------+

What's the reason of all the empty partitions?
I've been seraching in the doc but was unable to find an answer.

Thanks for help
Mat



Edited 1 time(s). Last edit at 12/11/2010 05:26AM by Mat N.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitions by key alternatively empty
2709
December 10, 2010 06:24AM
1324
December 11, 2010 02:04PM
1280
December 13, 2010 08:01AM


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.