summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/table_lock_aggregate_global_2u_2t.test
blob: 9205e2b923275e3d2b98d2998c7a143f5b2cf1f7 (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';

# 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');

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

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