diff options
| author | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
|---|---|---|
| committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2016-09-06 10:36:10 -0400 |
| commit | 780c40ef0e1d200fd6874a9e8e65705e685d76c0 (patch) | |
| tree | 0a29ad51f0192f865d79de65b566da61add4b536 /mysql-test/r/partition.result | |
| parent | d8ad96eac0df9241ba200634717227a7153086e1 (diff) | |
| download | mariadb-git-10.2-mdev7635.tar.gz | |
MDEV-7635: Part 110.2-mdev7635
innodb_buffer_pool_dump_at_shutdown = ON
innodb_buffer_pool_dump_pct = 25
innodb_buffer_pool_load_at_startup = ON
innodb_checksum_algorithm = CRC32
innodb_file_format = Barracuda
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
innodb_log_compressed_pages = ON
innodb_log_file_size = 128M
innodb_purge_threads = 4
innodb_stats_traditional = OFF
innodb_strict_mode = ON
binlog_annotate_row_events = ON
binlog_format = MIXED
group_concat_max_len = 1M
histogram_size = 255
long-query-time = 2
lower_case_table_names = 2
max_allowed_packet = 16M
replicate_annotate_row_events = ON
slave_net_timeout = 60
sync_binlog = 1
use_stat_tables = complementary
aria_recover = FORCE,BACKUP
myisam_recover_options = FORCE,BACKUP
Diffstat (limited to 'mysql-test/r/partition.result')
| -rw-r--r-- | mysql-test/r/partition.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index 99b0e287975..92acd9e44e0 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -286,6 +286,7 @@ Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_par t1 1 a 1 a A NULL NULL NULL YES BTREE analyze table t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK show indexes from t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment @@ -1020,6 +1021,7 @@ PARTITION BY LIST (a) (PARTITION x1 VALUES IN (10), PARTITION x2 VALUES IN (20)); analyze table t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK drop table t1; create table t1 @@ -1815,6 +1817,7 @@ Table Op Msg_type Msg_text test.t1 check status OK ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze note The storage engine for the table doesn't support analyze drop table t1; drop procedure if exists mysqltest_1; @@ -2051,6 +2054,7 @@ ALTER TABLE t1 ANALYZE PARTITION p1 EXTENDED; ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXTENDED' at line 1 ALTER TABLE t1 ANALYZE PARTITION p1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK ALTER TABLE t1 CHECK PARTITION p1; Table Op Msg_type Msg_text |