Re: Data not balanced in partitions

[Evan P]

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