Verified with recent Percona server 5.5.28 also:
... mysql> explain partitions SELECT * FROM test_nico WHERE time_id >= '2012-10-09 00:00:00' AND time_id < '2012-10-16 00:00:00' AND cid = 'TpqiCvy6S9af5KbEL5fQ'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: test_nico partitions: PM_2010_01_31,PM_2010_02_28,PM_2010_03_31,PM_2010_04_30,PM_2010_05_31,PM_2010_06_30,PM_2010_07_31,PM_2010_08_31,PM_2010_09_30,PM_2010_10_31,PM_2010_11_30,PM_2010_12_31,PM_2011_01_31,PM_2011_02_28,PM_2011_03_31,PM_2011_04_30,PM_2011_05_31,PM_2011_06_30,PM_2011_07_31,PM_2011_08_31,PM_2011_09_30,PM_2011_10_31,PM_2011_11_30,PM_2011_12_31,PM_2012_01_31,PM_2012_02_29,PM_2012_03_31,PM_2012_04_30,PM_2012_05_31,PM_2012_06_30,PM_2012_07_31,PM_2012_08_31,PM_2012_09_30,PM_2012_10_31,PM_2012_11_30,PM_2012_12_31 type: ref possible_keys: PRIMARY key: PRIMARY key_len: 20 ref: const rows: 36 Extra: Using where; Using index 1 row in set (0.00 sec)
mysql> show variables like '%ver%'; +----------------------------------+------------------------------+ | Variable_name | Value | +----------------------------------+------------------------------+ | character_set_server | utf8 | | collation_server | utf8_unicode_ci | | innodb_force_recovery | 0 | | innodb_recovery_stats | OFF | | innodb_recovery_update_relay_log | OFF | | innodb_show_verbose_locks | 0 | | innodb_version | 1.1.8-29.0 | | log_slow_verbosity | | | myisam_recover_options | OFF | | protocol_version | 10 | | relay_log_recovery | OFF | | rpl_recovery_rank | 0 | | server_id | 0 | | slave_type_conversions | | | version | 5.5.28 | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | x86_64 | | version_compile_os | Linux | +----------------------------------+------------------------------+ 18 rows in set (0.00 sec)
mysql> show variables like 'char%'; +--------------------------+---------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /home/openxs/dbs/p5.5/share/charsets/ | +--------------------------+---------------------------------------+ 8 rows in set (0.00 sec)
Verified with recent Percona server 5.5.28 also:
... bEL5fQ' \G ******* ******* ****** 1. row ******* ******* ******* ****** 01_31,PM_ 2010_02_ 28,PM_2010_ 03_31,PM_ 2010_04_ 30,PM_2010_ 05_31,PM_ 2010_06_ 30,PM_2010_ 07_31,PM_ 2010_08_ 31,PM_2010_ 09_30,PM_ 2010_10_ 31,PM_2010_ 11_30,PM_ 2010_12_ 31,PM_2011_ 01_31,PM_ 2011_02_ 28,PM_2011_ 03_31,PM_ 2011_04_ 30,PM_2011_ 05_31,PM_ 2011_06_ 30,PM_2011_ 07_31,PM_ 2011_08_ 31,PM_2011_ 09_30,PM_ 2011_10_ 31,PM_2011_ 11_30,PM_ 2011_12_ 31,PM_2012_ 01_31,PM_ 2012_02_ 29,PM_2012_ 03_31,PM_ 2012_04_ 30,PM_2012_ 05_31,PM_ 2012_06_ 30,PM_2012_ 07_31,PM_ 2012_08_ 31,PM_2012_ 09_30,PM_ 2012_10_ 31,PM_2012_ 11_30,PM_ 2012_12_ 31
mysql> explain partitions SELECT * FROM test_nico WHERE time_id >= '2012-10-09 00:00:00' AND time_id < '2012-10-16 00:00:00' AND cid = 'TpqiCvy6S9af5K
*******
id: 1
select_type: SIMPLE
table: test_nico
partitions: PM_2010_
type: ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 20
ref: const
rows: 36
Extra: Using where; Using index
1 row in set (0.00 sec)
mysql> show variables like '%ver%'; ------- ------- ------- ------- +------ ------- ------- ------- ---+ ------- ------- ------- ------- +------ ------- ------- ------- ---+ set_server | utf8 | force_recovery | 0 | recovery_ stats | OFF | recovery_ update_ relay_log | OFF | show_verbose_ locks | 0 | recover_ options | OFF | conversions | | compile_ machine | x86_64 | ------- ------- ------- ------- +------ ------- ------- ------- ---+
+------
| Variable_name | Value |
+------
| character_
| collation_server | utf8_unicode_ci |
| innodb_
| innodb_
| innodb_
| innodb_
| innodb_version | 1.1.8-29.0 |
| log_slow_verbosity | |
| myisam_
| protocol_version | 10 |
| relay_log_recovery | OFF |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_type_
| version | 5.5.28 |
| version_comment | MySQL Community Server (GPL) |
| version_
| version_compile_os | Linux |
+------
18 rows in set (0.00 sec)
mysql> show variables like 'char%'; ------- ------- ------+ ------- ------- ------- ------- ------- ----+ ------- ------- ------+ ------- ------- ------- ------- ------- ----+ set_client | utf8 | set_connection | utf8 | set_database | utf8 | set_filesystem | binary | set_results | utf8 | set_server | utf8 | set_system | utf8 | dbs/p5. 5/share/ charsets/ | ------- ------- ------+ ------- ------- ------- ------- ------- ----+
+------
| Variable_name | Value |
+------
| character_
| character_
| character_
| character_
| character_
| character_
| character_
| character_sets_dir | /home/openxs/
+------
8 rows in set (0.00 sec)