mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
7ac5a1d362
Merged all perfschema tests, except for the following: perfschema.part_table_io perfschema.binlog_mix perfschema.binlog_row perfschema.binlog_stmt perfschema.statement_digest_consumers perfschema.statement_digest privilege.inc privilege.result
245 lines
6.1 KiB
PHP
245 lines
6.1 KiB
PHP
# Tests for the performance schema
|
|
|
|
# =======================================
|
|
# HELPER include/connection_load.inc
|
|
# =======================================
|
|
|
|
call dump_all();
|
|
|
|
connect (con1a, localhost, user1, , );
|
|
select "user1 in con1a" as status;
|
|
call dump_all();
|
|
|
|
connect (con1b, localhost, user1, , );
|
|
select "user1 in con1b" as status;
|
|
call dump_all();
|
|
|
|
connect (con1c, localhost, user1, , );
|
|
select "user1 in con1c" as status;
|
|
call dump_all();
|
|
|
|
connect (con2a, localhost, user2, , );
|
|
select "user2 in con2a" as status;
|
|
call dump_all();
|
|
|
|
connect (con2b, localhost, user2, , );
|
|
select "user2 in con2b" as status;
|
|
call dump_all();
|
|
|
|
connect (con2c, localhost, user2, , );
|
|
select "user2 in con2c" as status;
|
|
call dump_all();
|
|
|
|
connect (con3a, localhost, user3, , );
|
|
select "user3 in con3a" as status;
|
|
call dump_all();
|
|
|
|
connect (con3b, localhost, user3, , );
|
|
select "user3 in con3b" as status;
|
|
call dump_all();
|
|
|
|
connect (con3c, localhost, user3, , );
|
|
select "user3 in con3c" as status;
|
|
call dump_all();
|
|
|
|
--connection default
|
|
|
|
--disconnect con1a
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 8 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con1a disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con2a
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 7 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con2a disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con3a
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 6 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con3a disconnected" as status;
|
|
call dump_all();
|
|
|
|
truncate table performance_schema.accounts;
|
|
call dump_all();
|
|
truncate table performance_schema.users;
|
|
call dump_all();
|
|
truncate table performance_schema.hosts;
|
|
call dump_all();
|
|
|
|
connect (con4a, localhost, user4, , );
|
|
select "user4 in con4a" as status;
|
|
call dump_all();
|
|
|
|
connect (con4b, localhost, user4, , );
|
|
select "user4 in con4b" as status;
|
|
call dump_all();
|
|
|
|
connect (con4c, localhost, user4, , );
|
|
select "user4 in con4c" as status;
|
|
call dump_all();
|
|
|
|
--connection default
|
|
|
|
--disconnect con1b
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 8 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con1b disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con2b
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 7 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con2b disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con3b
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 6 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con3b disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con1c
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 5 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con1c disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con2c
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 4 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con2c disconnected" as status;
|
|
call dump_all();
|
|
|
|
--disconnect con3c
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 3 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con3c disconnected" as status;
|
|
call dump_all();
|
|
|
|
truncate table performance_schema.accounts;
|
|
call dump_all();
|
|
truncate table performance_schema.users;
|
|
call dump_all();
|
|
truncate table performance_schema.hosts;
|
|
call dump_all();
|
|
|
|
connect (con5a, localhost, user5, , );
|
|
select "user5 in con5a" as status;
|
|
call dump_all();
|
|
|
|
connect (con5b, localhost, user5, , );
|
|
select "user5 in con5b" as status;
|
|
call dump_all();
|
|
|
|
connect (con5c, localhost, user5, , );
|
|
select "user5 in con5c" as status;
|
|
call dump_all();
|
|
|
|
--connection default
|
|
|
|
--disconnect con4a
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 5 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
--disconnect con4b
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 4 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
--disconnect con4c
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 3 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
--disconnect con5a
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 2 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
--disconnect con5b
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 1 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
--disconnect con5c
|
|
|
|
# Wait for the disconnect to complete
|
|
let $wait_condition=
|
|
select count(*) = 0 from performance_schema.threads
|
|
where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%';
|
|
--source include/wait_condition.inc
|
|
|
|
select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status;
|
|
call dump_all();
|
|
|
|
truncate table performance_schema.hosts;
|
|
call dump_all();
|
|
truncate table performance_schema.users;
|
|
call dump_all();
|
|
truncate table performance_schema.accounts;
|
|
call dump_all();
|
|
|