1select * from information_schema.system_variables 2where variable_name like 'debug%' 3 order by variable_name; 4VARIABLE_NAME DEBUG 5SESSION_VALUE 6GLOBAL_VALUE 7GLOBAL_VALUE_ORIGIN COMPILE-TIME 8DEFAULT_VALUE 9VARIABLE_SCOPE SESSION 10VARIABLE_TYPE VARCHAR 11VARIABLE_COMMENT Built-in DBUG debugger 12NUMERIC_MIN_VALUE NULL 13NUMERIC_MAX_VALUE NULL 14NUMERIC_BLOCK_SIZE NULL 15ENUM_VALUE_LIST NULL 16READ_ONLY NO 17COMMAND_LINE_ARGUMENT OPTIONAL 18VARIABLE_NAME DEBUG_BINLOG_FSYNC_SLEEP 19SESSION_VALUE NULL 20GLOBAL_VALUE 314 21GLOBAL_VALUE_ORIGIN CONFIG 22DEFAULT_VALUE 0 23VARIABLE_SCOPE GLOBAL 24VARIABLE_TYPE BIGINT UNSIGNED 25VARIABLE_COMMENT Extra sleep (in microseconds) to add to binlog fsync(), for debugging 26NUMERIC_MIN_VALUE 0 27NUMERIC_MAX_VALUE 4294967295 28NUMERIC_BLOCK_SIZE 1 29ENUM_VALUE_LIST NULL 30READ_ONLY NO 31COMMAND_LINE_ARGUMENT REQUIRED 32VARIABLE_NAME DEBUG_DBUG 33SESSION_VALUE 34GLOBAL_VALUE 35GLOBAL_VALUE_ORIGIN COMPILE-TIME 36DEFAULT_VALUE 37VARIABLE_SCOPE SESSION 38VARIABLE_TYPE VARCHAR 39VARIABLE_COMMENT Built-in DBUG debugger 40NUMERIC_MIN_VALUE NULL 41NUMERIC_MAX_VALUE NULL 42NUMERIC_BLOCK_SIZE NULL 43ENUM_VALUE_LIST NULL 44READ_ONLY NO 45COMMAND_LINE_ARGUMENT OPTIONAL 46VARIABLE_NAME DEBUG_MUTEX_DEADLOCK_DETECTOR 47SESSION_VALUE NULL 48GLOBAL_VALUE ON 49GLOBAL_VALUE_ORIGIN COMPILE-TIME 50DEFAULT_VALUE ON 51VARIABLE_SCOPE GLOBAL 52VARIABLE_TYPE BOOLEAN 53VARIABLE_COMMENT Enable checking of wrong mutex usage 54NUMERIC_MIN_VALUE NULL 55NUMERIC_MAX_VALUE NULL 56NUMERIC_BLOCK_SIZE NULL 57ENUM_VALUE_LIST OFF,ON 58READ_ONLY YES 59COMMAND_LINE_ARGUMENT OPTIONAL 60VARIABLE_NAME DEBUG_NO_THREAD_ALARM 61SESSION_VALUE NULL 62GLOBAL_VALUE OFF 63GLOBAL_VALUE_ORIGIN COMPILE-TIME 64DEFAULT_VALUE OFF 65VARIABLE_SCOPE GLOBAL 66VARIABLE_TYPE BOOLEAN 67VARIABLE_COMMENT Disable system thread alarm calls. Disabling it may be useful in debugging or testing, never do it in production 68NUMERIC_MIN_VALUE NULL 69NUMERIC_MAX_VALUE NULL 70NUMERIC_BLOCK_SIZE NULL 71ENUM_VALUE_LIST OFF,ON 72READ_ONLY YES 73COMMAND_LINE_ARGUMENT OPTIONAL 74VARIABLE_NAME DEBUG_SYNC 75SESSION_VALUE ON - current signal: '' 76GLOBAL_VALUE NULL 77GLOBAL_VALUE_ORIGIN COMPILE-TIME 78DEFAULT_VALUE 79VARIABLE_SCOPE SESSION ONLY 80VARIABLE_TYPE VARCHAR 81VARIABLE_COMMENT Debug Sync Facility 82NUMERIC_MIN_VALUE NULL 83NUMERIC_MAX_VALUE NULL 84NUMERIC_BLOCK_SIZE NULL 85ENUM_VALUE_LIST NULL 86READ_ONLY NO 87COMMAND_LINE_ARGUMENT NULL 88