polardbxengine/mysql-test/suite/xengine_perfschema/t/pfs_example_lifecycle.test

88 lines
2.0 KiB
Plaintext

--source include/have_debug.inc
select component_urn from mysql.component;
--sorted_result
select *
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
INSTALL COMPONENT "file://component_pfs_example";
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "%/pfs_example/%";
--sorted_result
select NAME
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
UNINSTALL COMPONENT "file://component_pfs_example";
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "wait/synch/mutex/pfs_example/%";
--sorted_result
select *
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
INSTALL COMPONENT "file://component_pfs_example";
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "wait/synch/mutex/pfs_example/%";
--sorted_result
select NAME
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
--source include/restart_mysqld.inc
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "wait/synch/mutex/pfs_example/%";
--sorted_result
select NAME
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
UNINSTALL COMPONENT "file://component_pfs_example";
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "wait/synch/mutex/pfs_example/%";
--sorted_result
select *
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";
--source include/restart_mysqld.inc
select component_urn from mysql.component;
--sorted_result
select * from performance_schema.setup_instruments
where NAME like "wait/synch/mutex/pfs_example/%";
--sorted_result
select *
from performance_schema.mutex_instances
where NAME like "%/pfs_example/%";