Partitions by key alternatively empty

[Mat N]

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.