Basic service settings
- Basedir = OS _path-- Basic settings of everything
- Plugin_dir = OS _path
- Language = OS _path
- Character_sets_dir = OS _path
- Datadir = OS _path-- Extremely important! Data File storage directory
- Tmpdir = OS _path-- Temporary file storage path
- Slave_load_tmpdir = OS _path
Process name File Settings
Log File Settings
- Log_error = OS _file_name -- related options: -- console, log_warnings
- General_log_file = OS _file_name -- related options: Log-output, log, log_queries_not_using_indexes ,,
- Slow_query_log_file = OS _file_name -- related options: Log-output, long_query_time, min_examined_row_limit ,,,
- Relay_log_info_file = OS _file_name
- Log_bin = base_name -- related options: BINLOG-format, binlog_cache_size, max_binlog_cache_size, log_bin_trust_function_createors, log_bin_trust_routine_creators, max_binlog_size
InnoDB engine settings
- Innodb_data_home_dir = OS _path -- control the path of the data file
- Innodb_data_file_path = OS [_ path] _ file_name -- controls basic features of data files
- Innodb_log_group_home_dir = OS _path -- control the path of the transaction log Group
- Innodb_log_files_in_group = n -- control the number of files in the transaction log Group
- Innodb_log_file_size = n -- control the transaction log file size