�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: stat_tables_par.inc</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'># Note that this test requires a fresh restart to not have problems with the
# old status values

--disable_service_connection

set @save_use_stat_tables=@@use_stat_tables;

set use_stat_tables=&#039;preferably&#039;;

--disable_warnings
DROP DATABASE IF EXISTS dbt3_s001;
--enable_warnings

CREATE DATABASE dbt3_s001;

use dbt3_s001;

set @save_optimizer_switch=@@optimizer_switch;
set optimizer_switch=&#039;extended_keys=off&#039;;
 
--disable_query_log
--disable_result_log
--disable_warnings
--source include/dbt3_s001.inc
truncate mysql.table_stats;
truncate mysql.column_stats;
truncate mysql.index_stats;
ANALYZE TABLE
customer, lineitem, nation, orders, part, partsupp, region, supplier;
--enable_warnings
--enable_result_log
--enable_query_log

select * from mysql.table_stats;
select * from mysql.index_stats;


#
# Test for parallel memory allocation for statistical data
# 
#    assumes that start the code of memory allocation for stats data has this line:
#
#       DEBUG_SYNC(thd, &quot;statistics_mem_alloc_start1&quot;);
#       DEBUG_SYNC(thd, &quot;statistics_mem_alloc_start2&quot;);
#

let $Q6=
select round(sum(l_extendedprice*l_discount),4) as revenue
from lineitem
where l_shipdate &gt;= date &#039;1994-01-01&#039; 
      and l_shipdate &lt; date &#039;1994-01-01&#039; + interval &#039;1&#039; year
      and l_discount between 0.06 - 0.01 and 0.06 + 0.01
      and l_quantity &lt; 24;

flush table lineitem;
set use_stat_tables=&#039;never&#039;;
eval $Q6;

connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

connection con1;
set debug_sync=&#039;statistics_mem_alloc_start1  WAIT_FOR second_thread_started_too&#039;;
set debug_sync=&#039;statistics_mem_alloc_start2  SIGNAL first_thread_working&#039;;
use dbt3_s001;
set use_stat_tables=&#039;preferably&#039;;
--send_eval $Q6                                            

connection con2;
set debug_sync=&#039;statistics_mem_alloc_start1  SIGNAL second_thread_started_too&#039;;
set debug_sync=&#039;statistics_mem_alloc_start2  WAIT_FOR first_thread_working&#039;;
use dbt3_s001;
set use_stat_tables=&#039;preferably&#039;;
--send_eval $Q6

connection con1;
--reap

connection con2;
--reap

connection default;
set use_stat_tables=&#039;preferably&#039;;
disconnect con1;
disconnect con2;
set debug_sync=&#039;RESET&#039;;

#
# Test for parallel statistics collection
# 
#    assumes that start of stats collection code has this line:
#
#       DEBUG_SYNC(thd, &quot;statistics_collection_start1&quot;);
#       DEBUG_SYNC(thd, &quot;statistics_collection_start2&quot;);
#

select * from mysql.index_stats where table_name=&#039;lineitem&#039; order by index_name;
delete from mysql.index_stats 
  where table_name=&#039;lineitem&#039; and
        index_name in (&#039;i_l_shipdate&#039;, &#039;i_l_receiptdate&#039;);
select * from mysql.index_stats where table_name=&#039;lineitem&#039; order by index_name;
--disable_result_log
--disable_warnings
analyze table lineitem persistent for columns() indexes (i_l_shipdate);
--enable_warnings
--enable_result_log
select * from mysql.index_stats where table_name=&#039;lineitem&#039; order by index_name;
delete from mysql.index_stats 
  where table_name=&#039;lineitem&#039; and index_name= &#039;i_l_shipdate&#039;;
select * from mysql.index_stats where table_name=&#039;lineitem&#039; order by index_name;

connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

connection con1;
set debug_sync=&#039;statistics_collection_start1  WAIT_FOR second_thread_started_too&#039;;
set debug_sync=&#039;statistics_collection_start2  SIGNAL first_thread_working&#039;;
use dbt3_s001;
set use_stat_tables=&#039;preferably&#039;;
--send analyze table lineitem persistent for columns() indexes (i_l_shipdate)

connection con2;
set debug_sync=&#039;statistics_collection_start1  SIGNAL second_thread_started_too&#039;;
set debug_sync=&#039;statistics_collection_start2  WAIT_FOR first_thread_working&#039;;
use dbt3_s001;
set use_stat_tables=&#039;preferably&#039;;
--send analyze table lineitem persistent for columns() indexes (i_l_receiptdate)

connection con1;
--disable_result_log
--disable_warnings
--reap
--enable_warnings
--enable_result_log

connection con2;
--disable_result_log
--disable_warnings
--reap
--enable_warnings
--enable_result_log

connection default;
disconnect con1;
disconnect con2;
set debug_sync=&#039;RESET&#039;;

select * from mysql.index_stats where table_name=&#039;lineitem&#039; order by index_name, prefix_arity;

#
# Test for parallel statistics collection and update (innodb)
# 

select * from mysql.index_stats where table_name=&#039;lineitem&#039;
 order by index_name, prefix_arity;
set debug_sync=&#039;RESET&#039;;

let $innodb_storage_engine= 0;
if (`SELECT UPPER(@@default_storage_engine) = &#039;INNODB&#039;`)
{
  let $innodb_storage_engine= 1;
}

connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

connection con1;
set debug_sync=&#039;statistics_collection_start SIGNAL parked WAIT_FOR finish&#039;;
use dbt3_s001;
set use_stat_tables=&#039;preferably&#039;;
--send analyze table lineitem persistent for all

connection con2;
set debug_sync=&#039;now WAIT_FOR parked&#039;;
use dbt3_s001;
set use_stat_tables=&#039;never&#039;;
if ($innodb_storage_engine)
{
  select * from lineitem where l_orderkey=1 and l_partkey=156;
  delete from lineitem where l_orderkey=1 and l_partkey=156;
  select * from lineitem where l_orderkey=1 and l_partkey=156;
}
set debug_sync=&#039;now SIGNAL finish&#039;;

connection con1;
--disable_result_log
--disable_warnings
--reap
--enable_warnings
--enable_result_log

connection default;
disconnect con1;
disconnect con2;
set debug_sync=&#039;RESET&#039;;

select * from mysql.index_stats where table_name=&#039;lineitem&#039;
  order by index_name, prefix_arity;

#
# Bug mdev-3891: deadlock for ANALYZE and SELECT over mysql.index_stats
# 

set @save_global_use_stat_tables=@@global.use_stat_tables;
set global use_stat_tables=&#039;preferably&#039;;
set debug_sync=&#039;RESET&#039;;

connect (con1, localhost, root,,);
connect (con2, localhost, root,,);

connection con1;
set debug_sync=&#039;statistics_update_start SIGNAL parker WAIT_FOR go1 EXECUTE 1&#039;;
set debug_sync=&#039;thr_multi_lock_before_thr_lock SIGNAL go2 EXECUTE 3&#039;;
use dbt3_s001;
--send analyze table lineitem persistent for all

connection con2;
set debug_sync=&#039;open_and_process_table WAIT_FOR parker&#039;;
set debug_sync=&#039;statistics_read_start SIGNAL go1 WAIT_FOR go2&#039;;
use dbt3_s001;
--send select * from mysql.index_stats, lineitem where index_name= &#039;i_l_shipdate&#039; and l_orderkey=1 and l_partkey=68 order by prefix_arity;

connection con1;
--disable_result_log
--disable_warnings
--reap
--enable_warnings
--enable_result_log

connection con2;
--disable_warnings
--reap
--enable_warnings

connection default;
disconnect con1;
disconnect con2;
set debug_sync=&#039;RESET&#039;;

set global use_stat_tables=@save_global_use_stat_tables;

DROP DATABASE dbt3_s001;

use test;

--enable_service_connection

#
# Bug mdev-4019: crash when executing in parallel ANALYZE and 
#                SELECT * FROM information_schema.statistics
# 

set @save_global_use_stat_tables=@@global.use_stat_tables;
set global use_stat_tables=&#039;preferably&#039;;
set debug_sync=&#039;RESET&#039;;

create table t1 (a int, b int, key(a));
insert t1 values (1,1),(2,2);

analyze table t1;

SET debug_sync=&#039;after_open_table_ignore_flush WAIT_FOR go&#039;;
send select * from information_schema.statistics where table_schema=&#039;test&#039;;

connect(con1, localhost, root);
connection con1;
select * from t1;
SET DEBUG_SYNC= &quot;now SIGNAL go&quot;;

connection default;
reap;

connection default;
disconnect con1;
set debug_sync=&#039;RESET&#039;;

drop table t1;
set global use_stat_tables=@save_global_use_stat_tables;
set use_stat_tables=@save_use_stat_tables;
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>