summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/table_lock_aggregate_global_2u_3t.test
blob: 60db987b9df7ded59fa97f2d3675c85a1225195c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# 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

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

# global
update performance_schema.setup_consumers
  set enabled='NO' where name='thread_instrumentation';

# 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