SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE '%core%'; VARIABLE_NAME VARIABLE_VALUE CORE_FILE ON SHOW GLOBAL VARIABLES LIKE '%core%'; Variable_name Value core_file ON