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