mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 11:01:34 +02:00
43 lines
1.4 KiB
Text
43 lines
1.4 KiB
Text
--source include/no_valgrind_without_big.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_sequence.inc
|
|
--source include/hostname_is_not_localhost.inc
|
|
|
|
SET SESSION DEFAULT_STORAGE_ENGINE='InnoDB';
|
|
|
|
set @save_optimizer_switch_for_stat_tables_test=@@optimizer_switch;
|
|
set optimizer_switch='extended_keys=on';
|
|
|
|
set @innodb_stats_persistent_save= @@innodb_stats_persistent;
|
|
set @innodb_stats_persistent_sample_pages_save=
|
|
@@innodb_stats_persistent_sample_pages;
|
|
|
|
set global innodb_stats_persistent= 1;
|
|
set global innodb_stats_persistent_sample_pages=100;
|
|
--source stat_tables.test
|
|
set global innodb_stats_persistent= @innodb_stats_persistent_save;
|
|
set global innodb_stats_persistent_sample_pages=
|
|
@innodb_stats_persistent_sample_pages_save;
|
|
|
|
set optimizer_switch=@save_optimizer_switch_for_stat_tables_test;
|
|
|
|
--echo #
|
|
--echo # MDEV-22851: Engine independent index statistics are incorrect for large tables on Windows.
|
|
--echo #
|
|
|
|
CREATE TABLE t1(a INT) ENGINE=INNODB;
|
|
INSERT INTO t1 SELECT 1 FROM seq_1_to_60000;
|
|
|
|
SET @save_use_stat_tables= @@use_stat_tables;
|
|
SET use_stat_tables= preferably;
|
|
SELECT count(*) FROM t1;
|
|
CREATE INDEX idx ON t1(a);
|
|
ANALYZE TABLE t1 PERSISTENT FOR COLUMNS (a) INDEXES (idx);
|
|
SELECT * FROM mysql.index_stats where table_name='t1';
|
|
SELECT * FROM mysql.column_stats where table_name='t1';
|
|
SET use_stat_tables= @save_use_stat_tables;
|
|
DROP TABLE t1;
|
|
|
|
--echo # end of 10.1 tests
|
|
|
|
SET SESSION DEFAULT_STORAGE_ENGINE=DEFAULT;
|