// 5.6 Searching 15280 files for "timed_mutexes" /home/ushastry/bzr/mysql/server/mysql-5.6/include/my_sys.h: 285 extern const char *charsets_dir; 286 287: extern my_bool timed_mutexes; 288 289 enum cache_type /home/ushastry/bzr/mysql/server/mysql-5.6/mysql-test/r/variables.result: 196 @@concurrent_insert 197 AUTO 198: set global timed_mutexes=ON; 199: show variables like 'timed_mutexes'; 200 Variable_name Value 201: timed_mutexes ON 202: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 203 VARIABLE_NAME VARIABLE_VALUE 204: TIMED_MUTEXES ON 205: set global timed_mutexes=0; 206: show variables like 'timed_mutexes'; 207 Variable_name Value 208: timed_mutexes OFF 209: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 210 VARIABLE_NAME VARIABLE_VALUE 211: TIMED_MUTEXES OFF 212 set default_storage_engine=MYISAM, default_storage_engine="HEAP", global default_storage_engine="MERGE"; 213 show local variables like 'default_storage_engine'; /home/ushastry/bzr/mysql/server/mysql-5.6/mysql-test/suite/sys_vars/r/timed_mutexes_basic.result: 1: SET @global_start_value = @@global.timed_mutexes; 2 SELECT @global_start_value; 3 @global_start_value 4 0 5 '#--------------------FN_DYNVARS_177_01------------------------#' 6: SET @@global.timed_mutexes = 1; 7: SET @@global.timed_mutexes = DEFAULT; 8: SELECT @@global.timed_mutexes; 9: @@global.timed_mutexes 10 0 11 '#---------------------FN_DYNVARS_177_02-------------------------#' 12: SET timed_mutexes = 1; 13: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 14: SELECT @@timed_mutexes; 15: @@timed_mutexes 16 0 17: SELECT global.timed_mutexes; 18 ERROR 42S02: Unknown table 'global' in field list 19: SET global timed_mutexes = 1; 20: SELECT @@global.timed_mutexes; 21: @@global.timed_mutexes 22 1 23 '#--------------------FN_DYNVARS_177_03------------------------#' 24: SET @@global.timed_mutexes = 0; 25: SELECT @@global.timed_mutexes; 26: @@global.timed_mutexes 27 0 28: SET @@global.timed_mutexes = 1; 29: SELECT @@global.timed_mutexes; 30: @@global.timed_mutexes 31 1 32 '#--------------------FN_DYNVARS_177_04-------------------------#' 33: SET @@global.timed_mutexes = -1; 34: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '-1' 35: SET @@global.timed_mutexes = 2; 36: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' 37: SET @@global.timed_mutexes = "T"; 38: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'T' 39: SET @@global.timed_mutexes = "Y"; 40: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'Y' 41: SET @@global.timed_mutexes = _true; 42: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '_true' 43: SET @@global.timed_mutexes = 0N; 44: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0N' 45: SET @@global.timed_mutexes = 1+1; 46: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' 47: SET @@global.timed_mutexes = 0FF; 48: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0FF' 49: SET @@global.timed_mutexes = '0'; 50: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0' 51: SET @@global.timed_mutexes = N; 52: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'N' 53 '#-------------------FN_DYNVARS_177_05----------------------------#' 54: SET @@session.timed_mutexes = 0; 55: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 56: SET @@timed_mutexes = 0; 57: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 58: SET @@local.timed_mutexes = 0; 59: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 60: SELECT @@session.timed_mutexes; 61: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable 62: SELECT @@local.timed_mutexes; 63: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable 64 '#----------------------FN_DYNVARS_177_06------------------------#' 65 SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES 66: WHERE VARIABLE_NAME='timed_mutexes'; 67 count(VARIABLE_VALUE) 68 1 69 '#----------------------FN_DYNVARS_177_07------------------------#' 70: SELECT IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 71 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 72: WHERE VARIABLE_NAME='timed_mutexes'; 73: IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 74 1 75: SELECT @@global.timed_mutexes; 76: @@global.timed_mutexes 77 1 78 SELECT VARIABLE_VALUE 79 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 80: WHERE VARIABLE_NAME='timed_mutexes'; 81 VARIABLE_VALUE 82 ON 83 '#---------------------FN_DYNVARS_177_08-------------------------#' 84: SET @@global.timed_mutexes = OFF; 85: SELECT @@global.timed_mutexes; 86: @@global.timed_mutexes 87 0 88: SET @@global.timed_mutexes = ON; 89: SELECT @@global.timed_mutexes; 90: @@global.timed_mutexes 91 1 92 '#---------------------FN_DYNVARS_177_09----------------------#' 93: SET @@global.timed_mutexes = TRUE; 94: SELECT @@global.timed_mutexes; 95: @@global.timed_mutexes 96 1 97: SET @@global.timed_mutexes = FALSE; 98: SELECT @@global.timed_mutexes; 99: @@global.timed_mutexes 100 0 101: SET @@global.timed_mutexes = @global_start_value; 102: SELECT @@global.timed_mutexes; 103: @@global.timed_mutexes 104 0 105 /home/ushastry/bzr/mysql/server/mysql-5.6/mysql-test/suite/sys_vars/t/timed_mutexes_basic.test: 1: ################## mysql-test\t\timed_mutexes_basic.test ###################### 2 # # 3: # Variable Name: timed_mutexes # 4 # Scope: GLOBAL # 5 # Access Type: Dynamic # . 12 # Author: Rizwan # 13 # # 14: # Description: Test Cases of Dynamic System Variable timed_mutexes # 15 # that checks the behavior of this variable in the following ways# 16 # * Default Value # .. 26 --source include/load_sysvars.inc 27 ######################################################################## 28: # START OF timed_mutexes TESTS # 29 ######################################################################## 30 31 32 ############################################################################## 33: # Saving initial value of timed_mutexes in a temporary variable # 34 ############################################################################## 35 36: SET @global_start_value = @@global.timed_mutexes; 37 SELECT @global_start_value; 38 39 --echo '#--------------------FN_DYNVARS_177_01------------------------#' 40 ######################################################################## 41: # Display the DEFAULT value of timed_mutexes # 42 ######################################################################## 43 44: SET @@global.timed_mutexes = 1; 45: SET @@global.timed_mutexes = DEFAULT; 46: SELECT @@global.timed_mutexes; 47 48 --echo '#---------------------FN_DYNVARS_177_02-------------------------#' 49 ############################################################################# 50: # Check if timed_mutexes can be accessed with and without @@ sign # 51 ############################################################################# 52 53 --Error ER_GLOBAL_VARIABLE 54: SET timed_mutexes = 1; 55: SELECT @@timed_mutexes; 56 --Error ER_UNKNOWN_TABLE 57: SELECT global.timed_mutexes; 58 59: SET global timed_mutexes = 1; 60: SELECT @@global.timed_mutexes; 61 62 63 --echo '#--------------------FN_DYNVARS_177_03------------------------#' 64 ######################################################################## 65: # Change the value of timed_mutexes to a valid value # 66 ######################################################################## 67 68: SET @@global.timed_mutexes = 0; 69: SELECT @@global.timed_mutexes; 70: SET @@global.timed_mutexes = 1; 71: SELECT @@global.timed_mutexes; 72 73 74 --echo '#--------------------FN_DYNVARS_177_04-------------------------#' 75 ########################################################################### 76: # Change the value of timed_mutexes to invalid value # 77 ########################################################################### 78 79 --Error ER_WRONG_VALUE_FOR_VAR 80: SET @@global.timed_mutexes = -1; 81 --Error ER_WRONG_VALUE_FOR_VAR 82: SET @@global.timed_mutexes = 2; 83 --Error ER_WRONG_VALUE_FOR_VAR 84: SET @@global.timed_mutexes = "T"; 85 --Error ER_WRONG_VALUE_FOR_VAR 86: SET @@global.timed_mutexes = "Y"; 87 --Error ER_WRONG_VALUE_FOR_VAR 88: SET @@global.timed_mutexes = _true; 89 --Error ER_WRONG_VALUE_FOR_VAR 90: SET @@global.timed_mutexes = 0N; 91 --Error ER_WRONG_VALUE_FOR_VAR 92: SET @@global.timed_mutexes = 1+1; 93 --Error ER_WRONG_VALUE_FOR_VAR 94: SET @@global.timed_mutexes = 0FF; 95 --Error ER_WRONG_VALUE_FOR_VAR 96: SET @@global.timed_mutexes = '0'; 97 --Error ER_WRONG_VALUE_FOR_VAR 98: SET @@global.timed_mutexes = N; 99 100 101 --echo '#-------------------FN_DYNVARS_177_05----------------------------#' 102 ########################################################################### 103: # Test if accessing session timed_mutexes gives error # 104 ########################################################################### 105 106 --Error ER_GLOBAL_VARIABLE 107: SET @@session.timed_mutexes = 0; 108 --Error ER_GLOBAL_VARIABLE 109: SET @@timed_mutexes = 0; 110 --Error ER_GLOBAL_VARIABLE 111: SET @@local.timed_mutexes = 0; 112 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR 113: SELECT @@session.timed_mutexes; 114 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR 115: SELECT @@local.timed_mutexes; 116 117 --echo '#----------------------FN_DYNVARS_177_06------------------------#' ... 121 122 SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES 123: WHERE VARIABLE_NAME='timed_mutexes'; 124 125 ... 129 ######################################################################### 130 131: SELECT IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 132 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 133: WHERE VARIABLE_NAME='timed_mutexes'; 134: SELECT @@global.timed_mutexes; 135 136 SELECT VARIABLE_VALUE 137 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 138: WHERE VARIABLE_NAME='timed_mutexes'; 139 140 --echo '#---------------------FN_DYNVARS_177_08-------------------------#' ... 143 ################################################################### 144 145: SET @@global.timed_mutexes = OFF; 146: SELECT @@global.timed_mutexes; 147: SET @@global.timed_mutexes = ON; 148: SELECT @@global.timed_mutexes; 149 150 --echo '#---------------------FN_DYNVARS_177_09----------------------#' ... 153 ################################################################### 154 155: SET @@global.timed_mutexes = TRUE; 156: SELECT @@global.timed_mutexes; 157: SET @@global.timed_mutexes = FALSE; 158: SELECT @@global.timed_mutexes; 159 160 ############################## ... 162 ############################## 163 164: SET @@global.timed_mutexes = @global_start_value; 165: SELECT @@global.timed_mutexes; 166 167 ############################################################### 168: # END OF timed_mutexes TESTS # 169 ############################################################### 170 /home/ushastry/bzr/mysql/server/mysql-5.6/mysql-test/t/variables.test: 126 select @@concurrent_insert; 127 128: set global timed_mutexes=ON; 129: show variables like 'timed_mutexes'; 130: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 131: set global timed_mutexes=0; 132: show variables like 'timed_mutexes'; 133: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 134 135 set default_storage_engine=MYISAM, default_storage_engine="HEAP", global default_storage_engine="MERGE"; /home/ushastry/bzr/mysql/server/mysql-5.6/mysys/my_static.c: 23 #include "my_alarm.h" 24 25: my_bool timed_mutexes= 0; 26 27 /* from my_init */ /home/ushastry/bzr/mysql/server/mysql-5.6/sql/sys_vars.cc: 3034 BLOCK_SIZE(1)); 3035 3036: static Sys_var_mybool Sys_timed_mutexes( 3037: "timed_mutexes", 3038 "Specify whether to time mutexes (only InnoDB mutexes are currently " 3039 "supported)", 3040: GLOBAL_VAR(timed_mutexes), CMD_LINE(OPT_ARG), DEFAULT(0)); 3041 3042 static char *server_version_ptr; /home/ushastry/bzr/mysql/server/mysql-5.6/storage/innobase/include/sync0sync.h: 44 45 #if defined(UNIV_DEBUG) && !defined(UNIV_HOTBACKUP) 46: extern "C" my_bool timed_mutexes; 47 #endif /* UNIV_DEBUG && !UNIV_HOTBACKUP */ 48 147 matches across 8 files // 5.5 Searching 10149 files for "timed_mutexes" /home/ushastry/bzr/mysql/server/mysql-5.5/include/my_sys.h: 258 extern const char *my_defaults_file; 259 260: extern my_bool timed_mutexes; 261 262 enum loglevel { /home/ushastry/bzr/mysql/server/mysql-5.5/mysql-test/r/variables.result: 188 @@concurrent_insert 189 AUTO 190: set global timed_mutexes=ON; 191: show variables like 'timed_mutexes'; 192 Variable_name Value 193: timed_mutexes ON 194: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 195 VARIABLE_NAME VARIABLE_VALUE 196: TIMED_MUTEXES ON 197: set global timed_mutexes=0; 198: show variables like 'timed_mutexes'; 199 Variable_name Value 200: timed_mutexes OFF 201: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 202 VARIABLE_NAME VARIABLE_VALUE 203: TIMED_MUTEXES OFF 204 set default_storage_engine=MYISAM, default_storage_engine="HEAP", global default_storage_engine="MERGE"; 205 show local variables like 'default_storage_engine'; /home/ushastry/bzr/mysql/server/mysql-5.5/mysql-test/suite/sys_vars/r/timed_mutexes_basic.result: 1: SET @global_start_value = @@global.timed_mutexes; 2 SELECT @global_start_value; 3 @global_start_value 4 0 5 '#--------------------FN_DYNVARS_177_01------------------------#' 6: SET @@global.timed_mutexes = 1; 7: SET @@global.timed_mutexes = DEFAULT; 8: SELECT @@global.timed_mutexes; 9: @@global.timed_mutexes 10 0 11 '#---------------------FN_DYNVARS_177_02-------------------------#' 12: SET timed_mutexes = 1; 13: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 14: SELECT @@timed_mutexes; 15: @@timed_mutexes 16 0 17: SELECT global.timed_mutexes; 18 ERROR 42S02: Unknown table 'global' in field list 19: SET global timed_mutexes = 1; 20: SELECT @@global.timed_mutexes; 21: @@global.timed_mutexes 22 1 23 '#--------------------FN_DYNVARS_177_03------------------------#' 24: SET @@global.timed_mutexes = 0; 25: SELECT @@global.timed_mutexes; 26: @@global.timed_mutexes 27 0 28: SET @@global.timed_mutexes = 1; 29: SELECT @@global.timed_mutexes; 30: @@global.timed_mutexes 31 1 32 '#--------------------FN_DYNVARS_177_04-------------------------#' 33: SET @@global.timed_mutexes = -1; 34: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '-1' 35: SET @@global.timed_mutexes = 2; 36: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' 37: SET @@global.timed_mutexes = "T"; 38: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'T' 39: SET @@global.timed_mutexes = "Y"; 40: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'Y' 41: SET @@global.timed_mutexes = _true; 42: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '_true' 43: SET @@global.timed_mutexes = 0N; 44: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0N' 45: SET @@global.timed_mutexes = 1+1; 46: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' 47: SET @@global.timed_mutexes = 0FF; 48: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0FF' 49: SET @@global.timed_mutexes = '0'; 50: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0' 51: SET @@global.timed_mutexes = N; 52: ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'N' 53 '#-------------------FN_DYNVARS_177_05----------------------------#' 54: SET @@session.timed_mutexes = 0; 55: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 56: SET @@timed_mutexes = 0; 57: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 58: SET @@local.timed_mutexes = 0; 59: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL 60: SELECT @@session.timed_mutexes; 61: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable 62: SELECT @@local.timed_mutexes; 63: ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable 64 '#----------------------FN_DYNVARS_177_06------------------------#' 65 SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES 66: WHERE VARIABLE_NAME='timed_mutexes'; 67 count(VARIABLE_VALUE) 68 1 69 '#----------------------FN_DYNVARS_177_07------------------------#' 70: SELECT IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 71 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 72: WHERE VARIABLE_NAME='timed_mutexes'; 73: IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 74 1 75: SELECT @@global.timed_mutexes; 76: @@global.timed_mutexes 77 1 78 SELECT VARIABLE_VALUE 79 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 80: WHERE VARIABLE_NAME='timed_mutexes'; 81 VARIABLE_VALUE 82 ON 83 '#---------------------FN_DYNVARS_177_08-------------------------#' 84: SET @@global.timed_mutexes = OFF; 85: SELECT @@global.timed_mutexes; 86: @@global.timed_mutexes 87 0 88: SET @@global.timed_mutexes = ON; 89: SELECT @@global.timed_mutexes; 90: @@global.timed_mutexes 91 1 92 '#---------------------FN_DYNVARS_177_09----------------------#' 93: SET @@global.timed_mutexes = TRUE; 94: SELECT @@global.timed_mutexes; 95: @@global.timed_mutexes 96 1 97: SET @@global.timed_mutexes = FALSE; 98: SELECT @@global.timed_mutexes; 99: @@global.timed_mutexes 100 0 101: SET @@global.timed_mutexes = @global_start_value; 102: SELECT @@global.timed_mutexes; 103: @@global.timed_mutexes 104 0 105 /home/ushastry/bzr/mysql/server/mysql-5.5/mysql-test/suite/sys_vars/t/timed_mutexes_basic.test: 1: ################## mysql-test\t\timed_mutexes_basic.test ###################### 2 # # 3: # Variable Name: timed_mutexes # 4 # Scope: GLOBAL # 5 # Access Type: Dynamic # . 12 # Author: Rizwan # 13 # # 14: # Description: Test Cases of Dynamic System Variable timed_mutexes # 15 # that checks the behavior of this variable in the following ways# 16 # * Default Value # .. 26 --source include/load_sysvars.inc 27 ######################################################################## 28: # START OF timed_mutexes TESTS # 29 ######################################################################## 30 31 32 ############################################################################## 33: # Saving initial value of timed_mutexes in a temporary variable # 34 ############################################################################## 35 36: SET @global_start_value = @@global.timed_mutexes; 37 SELECT @global_start_value; 38 39 --echo '#--------------------FN_DYNVARS_177_01------------------------#' 40 ######################################################################## 41: # Display the DEFAULT value of timed_mutexes # 42 ######################################################################## 43 44: SET @@global.timed_mutexes = 1; 45: SET @@global.timed_mutexes = DEFAULT; 46: SELECT @@global.timed_mutexes; 47 48 --echo '#---------------------FN_DYNVARS_177_02-------------------------#' 49 ############################################################################# 50: # Check if timed_mutexes can be accessed with and without @@ sign # 51 ############################################################################# 52 53 --Error ER_GLOBAL_VARIABLE 54: SET timed_mutexes = 1; 55: SELECT @@timed_mutexes; 56 --Error ER_UNKNOWN_TABLE 57: SELECT global.timed_mutexes; 58 59: SET global timed_mutexes = 1; 60: SELECT @@global.timed_mutexes; 61 62 63 --echo '#--------------------FN_DYNVARS_177_03------------------------#' 64 ######################################################################## 65: # Change the value of timed_mutexes to a valid value # 66 ######################################################################## 67 68: SET @@global.timed_mutexes = 0; 69: SELECT @@global.timed_mutexes; 70: SET @@global.timed_mutexes = 1; 71: SELECT @@global.timed_mutexes; 72 73 74 --echo '#--------------------FN_DYNVARS_177_04-------------------------#' 75 ########################################################################### 76: # Change the value of timed_mutexes to invalid value # 77 ########################################################################### 78 79 --Error ER_WRONG_VALUE_FOR_VAR 80: SET @@global.timed_mutexes = -1; 81 --Error ER_WRONG_VALUE_FOR_VAR 82: SET @@global.timed_mutexes = 2; 83 --Error ER_WRONG_VALUE_FOR_VAR 84: SET @@global.timed_mutexes = "T"; 85 --Error ER_WRONG_VALUE_FOR_VAR 86: SET @@global.timed_mutexes = "Y"; 87 --Error ER_WRONG_VALUE_FOR_VAR 88: SET @@global.timed_mutexes = _true; 89 --Error ER_WRONG_VALUE_FOR_VAR 90: SET @@global.timed_mutexes = 0N; 91 --Error ER_WRONG_VALUE_FOR_VAR 92: SET @@global.timed_mutexes = 1+1; 93 --Error ER_WRONG_VALUE_FOR_VAR 94: SET @@global.timed_mutexes = 0FF; 95 --Error ER_WRONG_VALUE_FOR_VAR 96: SET @@global.timed_mutexes = '0'; 97 --Error ER_WRONG_VALUE_FOR_VAR 98: SET @@global.timed_mutexes = N; 99 100 101 --echo '#-------------------FN_DYNVARS_177_05----------------------------#' 102 ########################################################################### 103: # Test if accessing session timed_mutexes gives error # 104 ########################################################################### 105 106 --Error ER_GLOBAL_VARIABLE 107: SET @@session.timed_mutexes = 0; 108 --Error ER_GLOBAL_VARIABLE 109: SET @@timed_mutexes = 0; 110 --Error ER_GLOBAL_VARIABLE 111: SET @@local.timed_mutexes = 0; 112 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR 113: SELECT @@session.timed_mutexes; 114 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR 115: SELECT @@local.timed_mutexes; 116 117 --echo '#----------------------FN_DYNVARS_177_06------------------------#' ... 121 122 SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES 123: WHERE VARIABLE_NAME='timed_mutexes'; 124 125 ... 129 ######################################################################### 130 131: SELECT IF(@@global.timed_mutexes, "ON", "OFF") = VARIABLE_VALUE 132 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 133: WHERE VARIABLE_NAME='timed_mutexes'; 134: SELECT @@global.timed_mutexes; 135 136 SELECT VARIABLE_VALUE 137 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 138: WHERE VARIABLE_NAME='timed_mutexes'; 139 140 --echo '#---------------------FN_DYNVARS_177_08-------------------------#' ... 143 ################################################################### 144 145: SET @@global.timed_mutexes = OFF; 146: SELECT @@global.timed_mutexes; 147: SET @@global.timed_mutexes = ON; 148: SELECT @@global.timed_mutexes; 149 150 --echo '#---------------------FN_DYNVARS_177_09----------------------#' ... 153 ################################################################### 154 155: SET @@global.timed_mutexes = TRUE; 156: SELECT @@global.timed_mutexes; 157: SET @@global.timed_mutexes = FALSE; 158: SELECT @@global.timed_mutexes; 159 160 ############################## ... 162 ############################## 163 164: SET @@global.timed_mutexes = @global_start_value; 165: SELECT @@global.timed_mutexes; 166 167 ############################################################### 168: # END OF timed_mutexes TESTS # 169 ############################################################### 170 /home/ushastry/bzr/mysql/server/mysql-5.5/mysql-test/t/variables.test: 126 select @@concurrent_insert; 127 128: set global timed_mutexes=ON; 129: show variables like 'timed_mutexes'; 130: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 131: set global timed_mutexes=0; 132: show variables like 'timed_mutexes'; 133: select * from information_schema.session_variables where variable_name like 'timed_mutexes'; 134 135 set default_storage_engine=MYISAM, default_storage_engine="HEAP", global default_storage_engine="MERGE"; /home/ushastry/bzr/mysql/server/mysql-5.5/mysys/my_static.c: 23 #include "my_alarm.h" 24 25: my_bool timed_mutexes= 0; 26 27 /* from my_init */ /home/ushastry/bzr/mysql/server/mysql-5.5/sql/sys_vars.cc: 2232 BLOCK_SIZE(1)); 2233 2234: static Sys_var_mybool Sys_timed_mutexes( 2235: "timed_mutexes", 2236 "Specify whether to time mutexes (only InnoDB mutexes are currently " 2237 "supported)", 2238: GLOBAL_VAR(timed_mutexes), CMD_LINE(OPT_ARG), DEFAULT(0)); 2239 2240 static char *server_version_ptr; /home/ushastry/bzr/mysql/server/mysql-5.5/storage/innobase/include/sync0sync.h: 43 44 #if defined(UNIV_DEBUG) && !defined(UNIV_HOTBACKUP) 45: extern my_bool timed_mutexes; 46 #endif /* UNIV_DEBUG && !UNIV_HOTBACKUP */ 47 /home/ushastry/bzr/mysql/server/mysql-5.5/storage/innobase/sync/sync0sync.c: 530 mutex->count_os_yield++; 531 #ifndef UNIV_HOTBACKUP 532: if (timed_mutexes && timer_started == 0) { 533 ut_usectime(&sec, &ms); 534 lstart_time= (ib_int64_t)sec * 1000000 + ms; ... 633 /* !!!!! Sometimes os_wait can be called without os_thread_yield */ 634 #ifndef UNIV_HOTBACKUP 635: if (timed_mutexes == 1 && timer_started == 0) { 636 ut_usectime(&sec, &ms); 637 lstart_time= (ib_int64_t)sec * 1000000 + ms; ... 646 finish_timing: 647 #ifdef UNIV_DEBUG 648: if (timed_mutexes == 1 && timer_started==1) { 649 ut_usectime(&sec, &ms); 650 lfinish_time= (ib_int64_t)sec * 1000000 + ms; 150 matches across 9 files