summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/table_lock_aggregate_hist_2u_3t.test
blob: a39bbcd1516df28067fe13bf9f96bcfe0c2e64ee (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# Tests for the performance schema

# Use MyISAM as InnoDB SE no longer uses THR_LOCK locks.
--source include/force_myisam_default.inc

--source ../include/table_aggregate_setup.inc

# hist by default

# table lock
update performance_schema.setup_instruments
  set enabled='NO' where name='wait/io/table/sql/handler';

# 2users
delete from performance_schema.setup_actors
  where user in ('user2', 'user4');

# 3tables by default

--source ../include/table_aggregate_load.inc
--source ../include/table_aggregate_cleanup.inc