diff options
Diffstat (limited to 'mysql-test/r/stat_tables_par_innodb.result')
-rw-r--r-- | mysql-test/r/stat_tables_par_innodb.result | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/r/stat_tables_par_innodb.result b/mysql-test/r/stat_tables_par_innodb.result index cb4e4b09827..155582c9192 100644 --- a/mysql-test/r/stat_tables_par_innodb.result +++ b/mysql-test/r/stat_tables_par_innodb.result @@ -57,6 +57,9 @@ and l_discount between 0.06 - 0.01 and 0.06 + 0.01 and l_quantity < 24; revenue 77949.91860000002 +connect con1, localhost, root,,; +connect con2, localhost, root,,; +connection con1; set debug_sync='statistics_mem_alloc_start1 WAIT_FOR second_thread_started_too'; set debug_sync='statistics_mem_alloc_start2 SIGNAL first_thread_working'; use dbt3_s001; @@ -67,6 +70,7 @@ where l_shipdate >= date '1994-01-01' and l_shipdate < date '1994-01-01' + interval '1' year and l_discount between 0.06 - 0.01 and 0.06 + 0.01 and l_quantity < 24 ; +connection con2; set debug_sync='statistics_mem_alloc_start1 SIGNAL second_thread_started_too'; set debug_sync='statistics_mem_alloc_start2 WAIT_FOR first_thread_working'; use dbt3_s001; @@ -77,11 +81,16 @@ where l_shipdate >= date '1994-01-01' and l_shipdate < date '1994-01-01' + interval '1' year and l_discount between 0.06 - 0.01 and 0.06 + 0.01 and l_quantity < 24; +connection con1; revenue 77949.91860000002 +connection con2; revenue 77949.91860000002 +connection default; set use_stat_tables='preferably'; +disconnect con1; +disconnect con2; set debug_sync='RESET'; select * from mysql.index_stats where table_name='lineitem' order by index_name; db_name table_name index_name prefix_arity avg_frequency @@ -140,16 +149,25 @@ dbt3_s001 lineitem i_l_partkey 1 30.0250 dbt3_s001 lineitem i_l_suppkey 1 600.5000 dbt3_s001 lineitem i_l_suppkey_partkey 2 8.5786 dbt3_s001 lineitem i_l_suppkey_partkey 1 30.0250 +connect con1, localhost, root,,; +connect con2, localhost, root,,; +connection con1; set debug_sync='statistics_collection_start1 WAIT_FOR second_thread_started_too'; set debug_sync='statistics_collection_start2 SIGNAL first_thread_working'; use dbt3_s001; set use_stat_tables='preferably'; analyze table lineitem persistent for columns() indexes (i_l_shipdate); +connection con2; set debug_sync='statistics_collection_start1 SIGNAL second_thread_started_too'; set debug_sync='statistics_collection_start2 WAIT_FOR first_thread_working'; use dbt3_s001; set use_stat_tables='preferably'; analyze table lineitem persistent for columns() indexes (i_l_receiptdate); +connection con1; +connection con2; +connection default; +disconnect con1; +disconnect con2; set debug_sync='RESET'; select * from mysql.index_stats where table_name='lineitem' order by index_name, prefix_arity; db_name table_name index_name prefix_arity avg_frequency @@ -189,10 +207,14 @@ dbt3_s001 lineitem i_l_suppkey 1 600.5000 dbt3_s001 lineitem i_l_suppkey_partkey 1 30.0250 dbt3_s001 lineitem i_l_suppkey_partkey 2 8.5786 set debug_sync='RESET'; +connect con1, localhost, root,,; +connect con2, localhost, root,,; +connection con1; set debug_sync='statistics_collection_start SIGNAL parked WAIT_FOR finish'; use dbt3_s001; set use_stat_tables='preferably'; analyze table lineitem persistent for all; +connection con2; set debug_sync='now WAIT_FOR parked'; use dbt3_s001; set use_stat_tables='never'; @@ -203,6 +225,10 @@ delete from lineitem where l_orderkey=1 and l_partkey=156; select * from lineitem where l_orderkey=1 and l_partkey=156; l_orderkey l_partkey l_suppkey l_linenumber l_quantity l_extendedprice l_discount l_tax l_returnflag l_linestatus l_shipDATE l_commitDATE l_receiptDATE l_shipinstruct l_shipmode l_comment set debug_sync='now SIGNAL finish'; +connection con1; +connection default; +disconnect con1; +disconnect con2; set debug_sync='RESET'; select * from mysql.index_stats where table_name='lineitem' order by index_name, prefix_arity; @@ -236,18 +262,27 @@ dbt3_s001 lineitem i_l_suppkey_partkey 4 1.0000 set @save_global_use_stat_tables=@@global.use_stat_tables; set global use_stat_tables='preferably'; set debug_sync='RESET'; +connect con1, localhost, root,,; +connect con2, localhost, root,,; +connection con1; set debug_sync='statistics_update_start SIGNAL parker WAIT_FOR go1 EXECUTE 1'; set debug_sync='thr_multi_lock_after_thr_lock SIGNAL go2 EXECUTE 2'; use dbt3_s001; analyze table lineitem persistent for all; +connection con2; set debug_sync='open_and_process_table WAIT_FOR parker'; set debug_sync='statistics_read_start SIGNAL go1 WAIT_FOR go2'; use dbt3_s001; select * from mysql.index_stats, lineitem where index_name= 'i_l_shipdate' and l_orderkey=1 and l_partkey=68 order by prefix_arity;; +connection con1; +connection con2; db_name table_name index_name prefix_arity avg_frequency l_orderkey l_partkey l_suppkey l_linenumber l_quantity l_extendedprice l_discount l_tax l_returnflag l_linestatus l_shipDATE l_commitDATE l_receiptDATE l_shipinstruct l_shipmode l_comment dbt3_s001 lineitem i_l_shipdate 1 2.6496 1 68 9 2 36 34850.16 0.09 0.06 N O 1996-04-12 1996-02-28 1996-04-20 TAKE BACK RETURN MAIL slyly bold pinto beans detect s dbt3_s001 lineitem i_l_shipdate 2 1.0149 1 68 9 2 36 34850.16 0.09 0.06 N O 1996-04-12 1996-02-28 1996-04-20 TAKE BACK RETURN MAIL slyly bold pinto beans detect s dbt3_s001 lineitem i_l_shipdate 3 1.0000 1 68 9 2 36 34850.16 0.09 0.06 N O 1996-04-12 1996-02-28 1996-04-20 TAKE BACK RETURN MAIL slyly bold pinto beans detect s +connection default; +disconnect con1; +disconnect con2; set debug_sync='RESET'; set global use_stat_tables=@save_global_use_stat_tables; DROP DATABASE dbt3_s001; @@ -263,13 +298,18 @@ test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK SET debug_sync='after_open_table_ignore_flush WAIT_FOR go'; select * from information_schema.statistics where table_schema='test'; +connect con1, localhost, root; +connection con1; select * from t1; a b 1 1 2 2 SET DEBUG_SYNC= "now SIGNAL go"; +connection default; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT def test t1 1 test a 1 a A 2 NULL NULL YES BTREE +connection default; +disconnect con1; set debug_sync='RESET'; drop table t1; set global use_stat_tables=@save_global_use_stat_tables; |