diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-05-07 16:12:16 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-05-07 16:12:16 +0200 |
| commit | 5ffe939a6c00f072d885fc324354ccf3ebaa2657 (patch) | |
| tree | 4c19c0e2ddf54e10029b6e03a745bc863a37daa0 /mysql-test/suite/perfschema/include | |
| parent | a30477b32293d2914fe9147630266d8238d8ec2e (diff) | |
| parent | 04bce7b569f44f3aca3cb21953d41c2a4a02efe6 (diff) | |
| download | mariadb-git-5ffe939a6c00f072d885fc324354ccf3ebaa2657.tar.gz | |
perfschema 5.6.17
Diffstat (limited to 'mysql-test/suite/perfschema/include')
5 files changed, 65 insertions, 4 deletions
diff --git a/mysql-test/suite/perfschema/include/disable_instruments.inc b/mysql-test/suite/perfschema/include/disable_instruments.inc new file mode 100644 index 00000000000..b0a4ddec450 --- /dev/null +++ b/mysql-test/suite/perfschema/include/disable_instruments.inc @@ -0,0 +1,23 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/disable_instruments +# ========================================== +# +# ==== Usage ==== +# +# 1. Define the instrument to be disabled/enabled: +# +# let $pfs_instrument=<instrument> +# +# Where <instrument> is the instrument name with or without wildcards, e.g. +# +# let $pfs_instrument='%statement/sql%' +# +--disable_query_log ONCE + +eval update performance_schema.setup_instruments + set enabled='no', timed='no' + where name like $pfs_instrument; + + diff --git a/mysql-test/suite/perfschema/include/enable_instruments.inc b/mysql-test/suite/perfschema/include/enable_instruments.inc new file mode 100644 index 00000000000..94d63aee941 --- /dev/null +++ b/mysql-test/suite/perfschema/include/enable_instruments.inc @@ -0,0 +1,23 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/enable_instruments +# ========================================== +# +# ==== Usage ==== +# +# 1. Define the instrument to be enabled/disabled: +# +# let $pfs_instrument=<instrument> +# +# Where <instrument> is the instrument name with or without wildcards, e.g. +# +# let $pfs_instrument='%statement/sql%' +# +--disable_query_log ONCE + +eval update performance_schema.setup_instruments + set enabled='yes', timed='yes' + where name like $pfs_instrument; + + diff --git a/mysql-test/suite/perfschema/include/event_aggregate_setup.inc b/mysql-test/suite/perfschema/include/event_aggregate_setup.inc index a0103649c09..769ba5f8607 100644 --- a/mysql-test/suite/perfschema/include/event_aggregate_setup.inc +++ b/mysql-test/suite/perfschema/include/event_aggregate_setup.inc @@ -123,8 +123,8 @@ update performance_schema.setup_instruments set enabled='YES', timed='YES' update performance_schema.setup_instruments set enabled='YES', timed='YES' where name in ('statement/sql/select', 'statement/sql/insert', - 'statement/com/', - 'statement/com/Query', + 'statement/abstract/new_packet', + 'statement/abstract/Query', 'statement/com/Quit', 'statement/com/error'); diff --git a/mysql-test/suite/perfschema/include/rpl_statements_truncate.inc b/mysql-test/suite/perfschema/include/rpl_statements_truncate.inc new file mode 100644 index 00000000000..afd1d31a157 --- /dev/null +++ b/mysql-test/suite/perfschema/include/rpl_statements_truncate.inc @@ -0,0 +1,15 @@ +# Tests for the performance schema + +# ========================================== +# HELPER include/rpl_truncate_statements.inc +# ========================================== + +--disable_query_log +update performance_schema.setup_instruments set enabled='no', timed='no' where name like '%statement/%'; +truncate table performance_schema.events_waits_history_long; +truncate table performance_schema.events_statements_summary_by_digest; +truncate table performance_schema.events_statements_history; +truncate table performance_schema.events_statements_history_long; +update performance_schema.setup_instruments set enabled='yes', timed='yes' where name like '%statement/%'; +--enable_query_log + diff --git a/mysql-test/suite/perfschema/include/sizing_auto.inc b/mysql-test/suite/perfschema/include/sizing_auto.inc index 1a9afeaf219..4c3451ce8b5 100644 --- a/mysql-test/suite/perfschema/include/sizing_auto.inc +++ b/mysql-test/suite/perfschema/include/sizing_auto.inc @@ -2,8 +2,8 @@ show variables like "table_definition_cache"; show variables like "table_open_cache"; show variables like "max_connections"; -# Results vary by platform: -# show variables like "open_files_limit"; +# open_files_limit depends on OS configuration (ulimit -n) +#show variables like "open_files_limit"; show variables like "%performance_schema%"; show status like "%performance_schema%"; |