1select @@global.open_files_limit; 2@@global.open_files_limit 3# 4select @@session.open_files_limit; 5ERROR HY000: Variable 'open_files_limit' is a GLOBAL variable 6show global variables like 'open_files_limit'; 7Variable_name Value 8open_files_limit # 9show session variables like 'open_files_limit'; 10Variable_name Value 11open_files_limit # 12select * from information_schema.global_variables where variable_name='open_files_limit'; 13VARIABLE_NAME VARIABLE_VALUE 14OPEN_FILES_LIMIT # 15select * from information_schema.session_variables where variable_name='open_files_limit'; 16VARIABLE_NAME VARIABLE_VALUE 17OPEN_FILES_LIMIT # 18set global open_files_limit=1; 19ERROR HY000: Variable 'open_files_limit' is a read only variable 20set session open_files_limit=1; 21ERROR HY000: Variable 'open_files_limit' is a read only variable 22