Re: A first table partitioning exercise.

[patrick flaherty]

Stopped and restarted mysql and it seems to be working now. Although it can't just be this stop and restart because I'd already rebooted a number of times only to once again see the old behavior.

A script for non-partitioned first (10X) then the same for partitioned.

mysql> use test
Database changed
mysql> source d:\\projects\\mysql\\test_selects_no_part_tab.sql
+---+----------+
| 1 | count(*) |
+---+----------+
| 1 |   795181 |
+---+----------+
1 row in set (6.81 sec)

+---+----------+
| 2 | count(*) |
+---+----------+
| 2 |   795181 |
+---+----------+
1 row in set (6.56 sec)

+---+----------+
| 3 | count(*) |
+---+----------+
| 3 |   795181 |
+---+----------+
1 row in set (5.55 sec)

+---+----------+
| 4 | count(*) |
+---+----------+
| 4 |   795181 |
+---+----------+
1 row in set (3.42 sec)

+---+----------+
| 5 | count(*) |
+---+----------+
| 5 |   795181 |
+---+----------+
1 row in set (3.44 sec)

+---+----------+
| 6 | count(*) |
+---+----------+
| 6 |   795181 |
+---+----------+
1 row in set (3.45 sec)

+---+----------+
| 7 | count(*) |
+---+----------+
| 7 |   795181 |
+---+----------+
1 row in set (3.44 sec)

+---+----------+
| 8 | count(*) |
+---+----------+
| 8 |   795181 |
+---+----------+
1 row in set (3.45 sec)

+---+----------+
| 9 | count(*) |
+---+----------+
| 9 |   795181 |
+---+----------+
1 row in set (3.45 sec)

+----+----------+
| 10 | count(*) |
+----+----------+
| 10 |   795181 |
+----+----------+
1 row in set (3.48 sec)

mysql> source d:\\projects\\mysql\\test_selects_part_tab.sql
+---+----------+
| 1 | count(*) |
+---+----------+
| 1 |   795181 |
+---+----------+
1 row in set (0.40 sec)

+---+----------+
| 2 | count(*) |
+---+----------+
| 2 |   795181 |
+---+----------+
1 row in set (0.39 sec)

+---+----------+
| 3 | count(*) |
+---+----------+
| 3 |   795181 |
+---+----------+
1 row in set (0.38 sec)

+---+----------+
| 4 | count(*) |
+---+----------+
| 4 |   795181 |
+---+----------+
1 row in set (0.39 sec)

+---+----------+
| 5 | count(*) |
+---+----------+
| 5 |   795181 |
+---+----------+
1 row in set (0.40 sec)

+---+----------+
| 6 | count(*) |
+---+----------+
| 6 |   795181 |
+---+----------+
1 row in set (0.44 sec)

+---+----------+
| 7 | count(*) |
+---+----------+
| 7 |   795181 |
+---+----------+
1 row in set (0.42 sec)

+---+----------+
| 8 | count(*) |
+---+----------+
| 8 |   795181 |
+---+----------+
1 row in set (0.46 sec)

+---+----------+
| 9 | count(*) |
+---+----------+
| 9 |   795181 |
+---+----------+
1 row in set (0.47 sec)

+----+----------+
| 10 | count(*) |
+----+----------+
| 10 |   795181 |
+----+----------+
1 row in set (0.43 sec)

mysql>
mysql>