mysql 查看参数:
mysql> SHOW VARIABLES LIKE '%file%';
+---------------------------------------+-----------------------------+
| Variable_name | Value |
+---------------------------------------+-----------------------------+
| character_set_filesystem | binary |
| core_file | OFF |
| ft_stopword_file | (built-in) |
| general_log_file | /mysql/data/master.log |
| init_file | |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_data_file_path | ibdata1:12M:autoextend |
| innodb_disable_sort_file_cache | OFF |
| innodb_file_format | Antelope |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
| innodb_log_file_size | 50331648 |
| innodb_log_files_in_group | 2 |
| innodb_open_files | 431 |
| keep_files_on_create | OFF |
| large_files_support | ON |
| local_infile | ON |
| lower_case_file_system | OFF |
| myisam_max_sort_file_size | 9223372036853727232 |
| open_files_limit | 1024 |
| performance_schema_max_file_classes | 50 |
| performance_schema_max_file_handles | 32768 |
| performance_schema_max_file_instances | 2557 |
| pid_file | /mysql/data/master.pid |
| relay_log_info_file | relay-log.info |
| secure_file_priv | |
| slow_query_log_file | /mysql/data/master-slow.log |
+---------------------------------------+-----------------------------+
28 rows in set (0.00 sec)