summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/table_lock_aggregate_thread_2u_2t.test
blob: a155619e9aacc5d16bb581a6fe10afee4c49b8d0 (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
25
26
# 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';

# thread
update performance_schema.setup_consumers
  set enabled='NO' where name like 'event%';

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

# 2tables
delete from performance_schema.setup_objects
  where object_name='t2';

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