set @userstat.save= @@userstat;

set global userstat= 1;

create temporary table t (a int primary key);

flush user_statistics, table_statistics;

insert into t values (1),(2);

update t set a = 10 where a = 1;

select rows_inserted, rows_updated from information_schema.user_statistics where user = 'root';

select table_name, rows_changed from information_schema.table_statistics where table_schema = 'test';

# Cleanup

set global userstat= @userstat.save;

insert into t values (1),(2);

update t set a = 10 where a = 1;

select rows_inserted, rows_updated from information_schema.user_statistics where user = 'root';

rows_inserted	rows_updated

2	1

select table_name, rows_changed from information_schema.table_statistics where table_schema = 'test';

table_name	rows_changed

set global userstat= @userstat.save;