diff options
author | Vladislav Vaintroub <vvaintroub@mysql.com> | 2010-01-11 17:46:16 +0100 |
---|---|---|
committer | Vladislav Vaintroub <vvaintroub@mysql.com> | 2010-01-11 17:46:16 +0100 |
commit | ed40723dc93b6b334fab57f21222748b0c97d5f7 (patch) | |
tree | e4f89b0d3a3b0d0c945e43db0252a458293453d4 /mysql-test/suite | |
parent | 4c872d51f63328955d8f2e22693ac539e9538862 (diff) | |
parent | 3d915225611a921fad03934e58bf281b48fc15b0 (diff) | |
download | mariadb-git-ed40723dc93b6b334fab57f21222748b0c97d5f7.tar.gz |
merge
Diffstat (limited to 'mysql-test/suite')
50 files changed, 1179 insertions, 16 deletions
diff --git a/mysql-test/suite/sys_vars/r/all_vars.result b/mysql-test/suite/sys_vars/r/all_vars.result index abd1f5d2bd6..0f741ff930a 100644 --- a/mysql-test/suite/sys_vars/r/all_vars.result +++ b/mysql-test/suite/sys_vars/r/all_vars.result @@ -1,12 +1,14 @@ create table t1 (test_name text); +create table t2 (variable_name text); load data infile "MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1; -select variable_name as `There should be *no* variables listed below:` - from information_schema.global_variables -left join t1 on variable_name=test_name where -test_name is null -union -select variable_name from information_schema.session_variables -left join t1 on variable_name=test_name where -test_name is null; +insert into t2 select variable_name from information_schema.global_variables; +insert into t2 select variable_name from information_schema.session_variables; +update t2 set variable_name= replace(variable_name, "PERFORMANCE_SCHEMA_", "PFS_"); +select variable_name as `There should be *no* long test name listed below:` from t2 +where length(variable_name) > 50; +There should be *no* long test name listed below: +select variable_name as `There should be *no* variables listed below:` from t2 +left join t1 on variable_name=test_name where test_name is null; There should be *no* variables listed below: drop table t1; +drop table t2; diff --git a/mysql-test/suite/sys_vars/r/performance_schema_basic.result b/mysql-test/suite/sys_vars/r/performance_schema_basic.result new file mode 100644 index 00000000000..d494b64502b --- /dev/null +++ b/mysql-test/suite/sys_vars/r/performance_schema_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema; +@@global.performance_schema +1 +select @@session.performance_schema; +ERROR HY000: Variable 'performance_schema' is a GLOBAL variable +show global variables like 'performance_schema'; +Variable_name Value +performance_schema ON +show session variables like 'performance_schema'; +Variable_name Value +performance_schema ON +select * from information_schema.global_variables +where variable_name='performance_schema'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA ON +select * from information_schema.session_variables +where variable_name='performance_schema'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA ON +set global performance_schema=1; +ERROR HY000: Variable 'performance_schema' is a read only variable +set session performance_schema=1; +ERROR HY000: Variable 'performance_schema' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_events_waits_history_long_size_basic.result b/mysql-test/suite/sys_vars/r/pfs_events_waits_history_long_size_basic.result new file mode 100644 index 00000000000..6aa1b0b6325 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_events_waits_history_long_size_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_events_waits_history_long_size; +@@global.performance_schema_events_waits_history_long_size +15000 +select @@session.performance_schema_events_waits_history_long_size; +ERROR HY000: Variable 'performance_schema_events_waits_history_long_size' is a GLOBAL variable +show global variables like 'performance_schema_events_waits_history_long_size'; +Variable_name Value +performance_schema_events_waits_history_long_size 15000 +show session variables like 'performance_schema_events_waits_history_long_size'; +Variable_name Value +performance_schema_events_waits_history_long_size 15000 +select * from information_schema.global_variables +where variable_name='performance_schema_events_waits_history_long_size'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE 15000 +select * from information_schema.session_variables +where variable_name='performance_schema_events_waits_history_long_size'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE 15000 +set global performance_schema_events_waits_history_long_size=1; +ERROR HY000: Variable 'performance_schema_events_waits_history_long_size' is a read only variable +set session performance_schema_events_waits_history_long_size=1; +ERROR HY000: Variable 'performance_schema_events_waits_history_long_size' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_events_waits_history_size_basic.result b/mysql-test/suite/sys_vars/r/pfs_events_waits_history_size_basic.result new file mode 100644 index 00000000000..defa4eca1d4 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_events_waits_history_size_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_events_waits_history_size; +@@global.performance_schema_events_waits_history_size +15 +select @@session.performance_schema_events_waits_history_size; +ERROR HY000: Variable 'performance_schema_events_waits_history_size' is a GLOBAL variable +show global variables like 'performance_schema_events_waits_history_size'; +Variable_name Value +performance_schema_events_waits_history_size 15 +show session variables like 'performance_schema_events_waits_history_size'; +Variable_name Value +performance_schema_events_waits_history_size 15 +select * from information_schema.global_variables +where variable_name='performance_schema_events_waits_history_size'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE 15 +select * from information_schema.session_variables +where variable_name='performance_schema_events_waits_history_size'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE 15 +set global performance_schema_events_waits_history_size=1; +ERROR HY000: Variable 'performance_schema_events_waits_history_size' is a read only variable +set session performance_schema_events_waits_history_size=1; +ERROR HY000: Variable 'performance_schema_events_waits_history_size' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_cond_classes_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_cond_classes_basic.result new file mode 100644 index 00000000000..ec980a90cbd --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_cond_classes_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_cond_classes; +@@global.performance_schema_max_cond_classes +123 +select @@session.performance_schema_max_cond_classes; +ERROR HY000: Variable 'performance_schema_max_cond_classes' is a GLOBAL variable +show global variables like 'performance_schema_max_cond_classes'; +Variable_name Value +performance_schema_max_cond_classes 123 +show session variables like 'performance_schema_max_cond_classes'; +Variable_name Value +performance_schema_max_cond_classes 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_cond_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_COND_CLASSES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_cond_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_COND_CLASSES 123 +set global performance_schema_max_cond_classes=1; +ERROR HY000: Variable 'performance_schema_max_cond_classes' is a read only variable +set session performance_schema_max_cond_classes=1; +ERROR HY000: Variable 'performance_schema_max_cond_classes' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_cond_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_cond_instances_basic.result new file mode 100644 index 00000000000..5bdb24ed0b8 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_cond_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_cond_instances; +@@global.performance_schema_max_cond_instances +123 +select @@session.performance_schema_max_cond_instances; +ERROR HY000: Variable 'performance_schema_max_cond_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_cond_instances'; +Variable_name Value +performance_schema_max_cond_instances 123 +show session variables like 'performance_schema_max_cond_instances'; +Variable_name Value +performance_schema_max_cond_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_cond_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_COND_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_cond_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_COND_INSTANCES 123 +set global performance_schema_max_cond_instances=1; +ERROR HY000: Variable 'performance_schema_max_cond_instances' is a read only variable +set session performance_schema_max_cond_instances=1; +ERROR HY000: Variable 'performance_schema_max_cond_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_file_classes_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_file_classes_basic.result new file mode 100644 index 00000000000..47eaa449106 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_file_classes_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_file_classes; +@@global.performance_schema_max_file_classes +123 +select @@session.performance_schema_max_file_classes; +ERROR HY000: Variable 'performance_schema_max_file_classes' is a GLOBAL variable +show global variables like 'performance_schema_max_file_classes'; +Variable_name Value +performance_schema_max_file_classes 123 +show session variables like 'performance_schema_max_file_classes'; +Variable_name Value +performance_schema_max_file_classes 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_file_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_file_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 123 +set global performance_schema_max_file_classes=1; +ERROR HY000: Variable 'performance_schema_max_file_classes' is a read only variable +set session performance_schema_max_file_classes=1; +ERROR HY000: Variable 'performance_schema_max_file_classes' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_file_handles_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_file_handles_basic.result new file mode 100644 index 00000000000..7d210ea3103 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_file_handles_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_file_handles; +@@global.performance_schema_max_file_handles +123 +select @@session.performance_schema_max_file_handles; +ERROR HY000: Variable 'performance_schema_max_file_handles' is a GLOBAL variable +show global variables like 'performance_schema_max_file_handles'; +Variable_name Value +performance_schema_max_file_handles 123 +show session variables like 'performance_schema_max_file_handles'; +Variable_name Value +performance_schema_max_file_handles 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_file_handles'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_file_handles'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 123 +set global performance_schema_max_file_handles=1; +ERROR HY000: Variable 'performance_schema_max_file_handles' is a read only variable +set session performance_schema_max_file_handles=1; +ERROR HY000: Variable 'performance_schema_max_file_handles' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_file_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_file_instances_basic.result new file mode 100644 index 00000000000..097d4c14ed1 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_file_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_file_instances; +@@global.performance_schema_max_file_instances +123 +select @@session.performance_schema_max_file_instances; +ERROR HY000: Variable 'performance_schema_max_file_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_file_instances'; +Variable_name Value +performance_schema_max_file_instances 123 +show session variables like 'performance_schema_max_file_instances'; +Variable_name Value +performance_schema_max_file_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_file_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_file_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES 123 +set global performance_schema_max_file_instances=1; +ERROR HY000: Variable 'performance_schema_max_file_instances' is a read only variable +set session performance_schema_max_file_instances=1; +ERROR HY000: Variable 'performance_schema_max_file_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_mutex_classes_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_mutex_classes_basic.result new file mode 100644 index 00000000000..f2b75ef9540 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_mutex_classes_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_mutex_classes; +@@global.performance_schema_max_mutex_classes +123 +select @@session.performance_schema_max_mutex_classes; +ERROR HY000: Variable 'performance_schema_max_mutex_classes' is a GLOBAL variable +show global variables like 'performance_schema_max_mutex_classes'; +Variable_name Value +performance_schema_max_mutex_classes 123 +show session variables like 'performance_schema_max_mutex_classes'; +Variable_name Value +performance_schema_max_mutex_classes 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_mutex_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_mutex_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES 123 +set global performance_schema_max_mutex_classes=1; +ERROR HY000: Variable 'performance_schema_max_mutex_classes' is a read only variable +set session performance_schema_max_mutex_classes=1; +ERROR HY000: Variable 'performance_schema_max_mutex_classes' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_mutex_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_mutex_instances_basic.result new file mode 100644 index 00000000000..f12fa6ace03 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_mutex_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_mutex_instances; +@@global.performance_schema_max_mutex_instances +123 +select @@session.performance_schema_max_mutex_instances; +ERROR HY000: Variable 'performance_schema_max_mutex_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_mutex_instances'; +Variable_name Value +performance_schema_max_mutex_instances 123 +show session variables like 'performance_schema_max_mutex_instances'; +Variable_name Value +performance_schema_max_mutex_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_mutex_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_mutex_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES 123 +set global performance_schema_max_mutex_instances=1; +ERROR HY000: Variable 'performance_schema_max_mutex_instances' is a read only variable +set session performance_schema_max_mutex_instances=1; +ERROR HY000: Variable 'performance_schema_max_mutex_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_rwlock_classes_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_rwlock_classes_basic.result new file mode 100644 index 00000000000..6c2d4b773c0 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_rwlock_classes_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_rwlock_classes; +@@global.performance_schema_max_rwlock_classes +123 +select @@session.performance_schema_max_rwlock_classes; +ERROR HY000: Variable 'performance_schema_max_rwlock_classes' is a GLOBAL variable +show global variables like 'performance_schema_max_rwlock_classes'; +Variable_name Value +performance_schema_max_rwlock_classes 123 +show session variables like 'performance_schema_max_rwlock_classes'; +Variable_name Value +performance_schema_max_rwlock_classes 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_rwlock_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_rwlock_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 123 +set global performance_schema_max_rwlock_classes=1; +ERROR HY000: Variable 'performance_schema_max_rwlock_classes' is a read only variable +set session performance_schema_max_rwlock_classes=1; +ERROR HY000: Variable 'performance_schema_max_rwlock_classes' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_rwlock_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_rwlock_instances_basic.result new file mode 100644 index 00000000000..169387d369d --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_rwlock_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_rwlock_instances; +@@global.performance_schema_max_rwlock_instances +123 +select @@session.performance_schema_max_rwlock_instances; +ERROR HY000: Variable 'performance_schema_max_rwlock_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_rwlock_instances'; +Variable_name Value +performance_schema_max_rwlock_instances 123 +show session variables like 'performance_schema_max_rwlock_instances'; +Variable_name Value +performance_schema_max_rwlock_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_rwlock_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_rwlock_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES 123 +set global performance_schema_max_rwlock_instances=1; +ERROR HY000: Variable 'performance_schema_max_rwlock_instances' is a read only variable +set session performance_schema_max_rwlock_instances=1; +ERROR HY000: Variable 'performance_schema_max_rwlock_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_table_handles_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_table_handles_basic.result new file mode 100644 index 00000000000..5f661b0ecdd --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_table_handles_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_table_handles; +@@global.performance_schema_max_table_handles +123 +select @@session.performance_schema_max_table_handles; +ERROR HY000: Variable 'performance_schema_max_table_handles' is a GLOBAL variable +show global variables like 'performance_schema_max_table_handles'; +Variable_name Value +performance_schema_max_table_handles 123 +show session variables like 'performance_schema_max_table_handles'; +Variable_name Value +performance_schema_max_table_handles 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_table_handles'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_table_handles'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES 123 +set global performance_schema_max_table_handles=1; +ERROR HY000: Variable 'performance_schema_max_table_handles' is a read only variable +set session performance_schema_max_table_handles=1; +ERROR HY000: Variable 'performance_schema_max_table_handles' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_table_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_table_instances_basic.result new file mode 100644 index 00000000000..8497527abb5 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_table_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_table_instances; +@@global.performance_schema_max_table_instances +123 +select @@session.performance_schema_max_table_instances; +ERROR HY000: Variable 'performance_schema_max_table_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_table_instances'; +Variable_name Value +performance_schema_max_table_instances 123 +show session variables like 'performance_schema_max_table_instances'; +Variable_name Value +performance_schema_max_table_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_table_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_table_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES 123 +set global performance_schema_max_table_instances=1; +ERROR HY000: Variable 'performance_schema_max_table_instances' is a read only variable +set session performance_schema_max_table_instances=1; +ERROR HY000: Variable 'performance_schema_max_table_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_thread_classes_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_thread_classes_basic.result new file mode 100644 index 00000000000..9d45e13b46e --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_thread_classes_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_thread_classes; +@@global.performance_schema_max_thread_classes +123 +select @@session.performance_schema_max_thread_classes; +ERROR HY000: Variable 'performance_schema_max_thread_classes' is a GLOBAL variable +show global variables like 'performance_schema_max_thread_classes'; +Variable_name Value +performance_schema_max_thread_classes 123 +show session variables like 'performance_schema_max_thread_classes'; +Variable_name Value +performance_schema_max_thread_classes 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_thread_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_thread_classes'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 123 +set global performance_schema_max_thread_classes=1; +ERROR HY000: Variable 'performance_schema_max_thread_classes' is a read only variable +set session performance_schema_max_thread_classes=1; +ERROR HY000: Variable 'performance_schema_max_thread_classes' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/pfs_max_thread_instances_basic.result b/mysql-test/suite/sys_vars/r/pfs_max_thread_instances_basic.result new file mode 100644 index 00000000000..dbb3967ad33 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/pfs_max_thread_instances_basic.result @@ -0,0 +1,23 @@ +select @@global.performance_schema_max_thread_instances; +@@global.performance_schema_max_thread_instances +123 +select @@session.performance_schema_max_thread_instances; +ERROR HY000: Variable 'performance_schema_max_thread_instances' is a GLOBAL variable +show global variables like 'performance_schema_max_thread_instances'; +Variable_name Value +performance_schema_max_thread_instances 123 +show session variables like 'performance_schema_max_thread_instances'; +Variable_name Value +performance_schema_max_thread_instances 123 +select * from information_schema.global_variables +where variable_name='performance_schema_max_thread_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES 123 +select * from information_schema.session_variables +where variable_name='performance_schema_max_thread_instances'; +VARIABLE_NAME VARIABLE_VALUE +PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES 123 +set global performance_schema_max_thread_instances=1; +ERROR HY000: Variable 'performance_schema_max_thread_instances' is a read only variable +set session performance_schema_max_thread_instances=1; +ERROR HY000: Variable 'performance_schema_max_thread_instances' is a read only variable diff --git a/mysql-test/suite/sys_vars/t/all_vars.test b/mysql-test/suite/sys_vars/t/all_vars.test index c6c228d842f..6a18b5e3d37 100644 --- a/mysql-test/suite/sys_vars/t/all_vars.test +++ b/mysql-test/suite/sys_vars/t/all_vars.test @@ -1,3 +1,18 @@ +# Copyright (C) 2009-2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + --source include/not_embedded.inc # @@ -20,16 +35,26 @@ perl; EOF create table t1 (test_name text); +create table t2 (variable_name text); --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR eval load data infile "$MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1; -select variable_name as `There should be *no* variables listed below:` - from information_schema.global_variables - left join t1 on variable_name=test_name where - test_name is null - union -select variable_name from information_schema.session_variables - left join t1 on variable_name=test_name where - test_name is null; +insert into t2 select variable_name from information_schema.global_variables; +insert into t2 select variable_name from information_schema.session_variables; + +# Performance schema variables are too long for files named +# 'mysql-test/suite/sys_vars/t/' ... +# ... 'performance_schema_events_waits_history_long_size_basic-master.opt' +# to fit in the tar source distribution (limit in old tar) +# Renaming the tests to aliases below. + +update t2 set variable_name= replace(variable_name, "PERFORMANCE_SCHEMA_", "PFS_"); + +select variable_name as `There should be *no* long test name listed below:` from t2 + where length(variable_name) > 50; + +select variable_name as `There should be *no* variables listed below:` from t2 + left join t1 on variable_name=test_name where test_name is null; drop table t1; +drop table t2; diff --git a/mysql-test/suite/sys_vars/t/performance_schema_basic-master.opt b/mysql-test/suite/sys_vars/t/performance_schema_basic-master.opt new file mode 100644 index 00000000000..542720c44d7 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/performance_schema_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema diff --git a/mysql-test/suite/sys_vars/t/performance_schema_basic.test b/mysql-test/suite/sys_vars/t/performance_schema_basic.test new file mode 100644 index 00000000000..804e6261921 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/performance_schema_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema; + +show global variables like 'performance_schema'; + +show session variables like 'performance_schema'; + +select * from information_schema.global_variables + where variable_name='performance_schema'; + +select * from information_schema.session_variables + where variable_name='performance_schema'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic-master.opt new file mode 100644 index 00000000000..ff1dd2a8c05 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-events-waits-history-long-size=15000 diff --git a/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic.test b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic.test new file mode 100644 index 00000000000..bf6638803bc --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_long_size_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_events_waits_history_long_size; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_events_waits_history_long_size; + +show global variables like 'performance_schema_events_waits_history_long_size'; + +show session variables like 'performance_schema_events_waits_history_long_size'; + +select * from information_schema.global_variables + where variable_name='performance_schema_events_waits_history_long_size'; + +select * from information_schema.session_variables + where variable_name='performance_schema_events_waits_history_long_size'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_events_waits_history_long_size=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_events_waits_history_long_size=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic-master.opt new file mode 100644 index 00000000000..488707fc962 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-events-waits-history-size=15 diff --git a/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic.test b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic.test new file mode 100644 index 00000000000..28338ad1ffd --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_events_waits_history_size_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_events_waits_history_size; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_events_waits_history_size; + +show global variables like 'performance_schema_events_waits_history_size'; + +show session variables like 'performance_schema_events_waits_history_size'; + +select * from information_schema.global_variables + where variable_name='performance_schema_events_waits_history_size'; + +select * from information_schema.session_variables + where variable_name='performance_schema_events_waits_history_size'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_events_waits_history_size=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_events_waits_history_size=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic-master.opt new file mode 100644 index 00000000000..438bc463289 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-cond-classes=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic.test new file mode 100644 index 00000000000..70a757087f8 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_cond_classes_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_cond_classes; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_cond_classes; + +show global variables like 'performance_schema_max_cond_classes'; + +show session variables like 'performance_schema_max_cond_classes'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_cond_classes'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_cond_classes'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_cond_classes=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_cond_classes=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic-master.opt new file mode 100644 index 00000000000..47b9d629655 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-cond-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic.test new file mode 100644 index 00000000000..597ad334295 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_cond_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_cond_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_cond_instances; + +show global variables like 'performance_schema_max_cond_instances'; + +show session variables like 'performance_schema_max_cond_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_cond_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_cond_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_cond_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_cond_instances=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic-master.opt new file mode 100644 index 00000000000..6ed54f9f99d --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-file-classes=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic.test new file mode 100644 index 00000000000..8536a703afa --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_classes_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_file_classes; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_file_classes; + +show global variables like 'performance_schema_max_file_classes'; + +show session variables like 'performance_schema_max_file_classes'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_file_classes'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_file_classes'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_file_classes=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_file_classes=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic-master.opt new file mode 100644 index 00000000000..04633ae0897 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-file-handles=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic.test new file mode 100644 index 00000000000..ba702a030d7 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_handles_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_file_handles; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_file_handles; + +show global variables like 'performance_schema_max_file_handles'; + +show session variables like 'performance_schema_max_file_handles'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_file_handles'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_file_handles'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_file_handles=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_file_handles=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic-master.opt new file mode 100644 index 00000000000..078a998c1e7 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-file-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic.test new file mode 100644 index 00000000000..829df39bbe9 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_file_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_file_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_file_instances; + +show global variables like 'performance_schema_max_file_instances'; + +show session variables like 'performance_schema_max_file_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_file_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_file_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_file_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_file_instances=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic-master.opt new file mode 100644 index 00000000000..1525916a1ef --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-mutex-classes=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic.test new file mode 100644 index 00000000000..633d1a3487c --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_mutex_classes_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_mutex_classes; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_mutex_classes; + +show global variables like 'performance_schema_max_mutex_classes'; + +show session variables like 'performance_schema_max_mutex_classes'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_mutex_classes'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_mutex_classes'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_mutex_classes=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_mutex_classes=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic-master.opt new file mode 100644 index 00000000000..98ce2ff3df9 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-mutex-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic.test new file mode 100644 index 00000000000..2a8f5e5ae00 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_mutex_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_mutex_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_mutex_instances; + +show global variables like 'performance_schema_max_mutex_instances'; + +show session variables like 'performance_schema_max_mutex_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_mutex_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_mutex_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_mutex_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_mutex_instances=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic-master.opt new file mode 100644 index 00000000000..b5d5318635f --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-rwlock-classes=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic.test new file mode 100644 index 00000000000..ce911b60049 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_classes_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_rwlock_classes; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_rwlock_classes; + +show global variables like 'performance_schema_max_rwlock_classes'; + +show session variables like 'performance_schema_max_rwlock_classes'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_rwlock_classes'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_rwlock_classes'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_rwlock_classes=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_rwlock_classes=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic-master.opt new file mode 100644 index 00000000000..5dcecd99c0a --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-rwlock-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic.test new file mode 100644 index 00000000000..d16c1c46f68 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_rwlock_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_rwlock_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_rwlock_instances; + +show global variables like 'performance_schema_max_rwlock_instances'; + +show session variables like 'performance_schema_max_rwlock_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_rwlock_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_rwlock_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_rwlock_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_rwlock_instances=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic-master.opt new file mode 100644 index 00000000000..45e73c51f8c --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-table-handles=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic.test new file mode 100644 index 00000000000..3ede0985a70 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_table_handles_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_table_handles; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_table_handles; + +show global variables like 'performance_schema_max_table_handles'; + +show session variables like 'performance_schema_max_table_handles'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_table_handles'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_table_handles'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_table_handles=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_table_handles=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic-master.opt new file mode 100644 index 00000000000..b8b0ba4b40b --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-table-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic.test new file mode 100644 index 00000000000..fcd4886ca22 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_table_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_table_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_table_instances; + +show global variables like 'performance_schema_max_table_instances'; + +show session variables like 'performance_schema_max_table_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_table_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_table_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_table_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_table_instances=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic-master.opt new file mode 100644 index 00000000000..c0b64e5889a --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-thread-classes=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic.test new file mode 100644 index 00000000000..4704e87cf06 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_thread_classes_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_thread_classes; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_thread_classes; + +show global variables like 'performance_schema_max_thread_classes'; + +show session variables like 'performance_schema_max_thread_classes'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_thread_classes'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_thread_classes'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_thread_classes=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_thread_classes=1; + diff --git a/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic-master.opt b/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic-master.opt new file mode 100644 index 00000000000..b70eda8acb1 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic-master.opt @@ -0,0 +1 @@ +--loose-enable-performance-schema --loose-performance-schema-max-thread-instances=123 diff --git a/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic.test b/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic.test new file mode 100644 index 00000000000..d709c097f20 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/pfs_max_thread_instances_basic.test @@ -0,0 +1,47 @@ +# Copyright (C) 2010 Sun Microsystems, Inc. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +# +# Only global +# + +select @@global.performance_schema_max_thread_instances; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.performance_schema_max_thread_instances; + +show global variables like 'performance_schema_max_thread_instances'; + +show session variables like 'performance_schema_max_thread_instances'; + +select * from information_schema.global_variables + where variable_name='performance_schema_max_thread_instances'; + +select * from information_schema.session_variables + where variable_name='performance_schema_max_thread_instances'; + +# +# Read-only +# + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set global performance_schema_max_thread_instances=1; + +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +set session performance_schema_max_thread_instances=1; + |