MySQL Forums
Forum List  »  Partitioning

Re: Data not balanced in partitions
Posted by: Evan P
Date: November 26, 2011 12:51PM

Got it.

When data are:

mysql> select * from prova;
+------+-------------------+
| NE | ASSERT |
+------+-------------------+
| AAA | test assert for A |
| BBB | test assert for B |
| CCC | test assert for C |
| DDD | test assert for D |
+------+-------------------+

Partitions didn't worked as I expected.

Instead:

mysql> select * from prova;
+----+-------------------+
| NE | ASSERT |
+----+-------------------+
| A | test assert for A |
| D | test assert for D |
| C | test assert for C |
| B | test assert for B |
+----+-------------------+

So any suggestion please on how to partition based on string instead of single char?

Can you also explain why mysql works like that?

Thank you very much,
Evan

Options: ReplyQuote


Subject
Views
Written By
Posted
2633
November 26, 2011 05:41AM
1249
November 26, 2011 12:34PM
Re: Data not balanced in partitions
1561
November 26, 2011 12:51PM
1416
November 28, 2011 11:25AM


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.