connection slave;

stop slave;

# Enable userstat on slave

set global userstat=1;

start slave;

# Make sure the statistics is empty so far

show table_statistics;

Table_schema	Table_name	Rows_read	Rows_changed	Rows_changed_x_#indexes

connection master;

# Create some writes on master

create table t1 (i int);

insert into t1 values (1),(2),(3),(4);

drop table t1;

connection slave;

# Slave shows statistics

show table_statistics;

Table_schema	Table_name	Rows_read	Rows_changed	Rows_changed_x_#indexes

test	t1	0	4	4

mysql	gtid_slave_pos	1	4	4

stop slave;

flush table_statistics;

# Make sure the statistics is empty again after flush

show table_statistics;

Table_schema	Table_name	Rows_read	Rows_changed	Rows_changed_x_#indexes

# Enable parallel slave

set global slave_parallel_threads=16;

start slave;

connection master;

# Create the same writes again

create table t1 (i int);

insert into t1 values (1),(2),(3),(4);

drop table t1;

connection slave;

# Slave shows statistics

show table_statistics;

Table_schema	Table_name	Rows_read	Rows_changed	Rows_changed_x_#indexes

test	t1	0	4	4

mysql	gtid_slave_pos	4	8	8

--source include/master-slave.inc

--source include/have_binlog_format_statement.inc

--enable_connect_log

--connection slave

stop slave;

--echo

--echo # Enable userstat on slave

set global userstat=1;

start slave;

--echo 

--echo # Make sure the statistics is empty so far

show table_statistics;

--connection master

--echo 

--echo # Create some writes on master

create table t1 (i int);

insert into t1 values (1),(2),(3),(4);

drop table t1;

--sync_slave_with_master

--echo 

--echo # Slave shows statistics

show table_statistics;

stop slave;

flush table_statistics;

--echo 

--echo # Make sure the statistics is empty again after flush

show table_statistics;

--echo 

--echo # Enable parallel slave

set global slave_parallel_threads=16;

start slave;

--connection master

--echo 

--echo # Create the same writes again

create table t1 (i int);

insert into t1 values (1),(2),(3),(4);

drop table t1;

--sync_slave_with_master

--echo 

--echo # Slave shows statistics

show table_statistics;