MySQL Learning notes

Log

--log-error[=file_name] Turn On error logging

--log-bin[=file_name] Open Binary log

--max_binlog_size Setting the maximum storage limit for Binlog

--binlog-do-db=db_name binary logging for a database

--binlog-ignore-db=db_name ignoring binary logs for a database

--log[=file_name] Open all of the query, including select, the volume is relatively large, open after the performance has a greater impact, generally used for targeted troubleshooting

--log-slow-queries[=file_name] Turn on slow query log

--innodb_log_group_home_dir[=file_name] Change InnoDB log storage path

--innodb_log_files_in_group set the number of logs

--innodb_data_home_dir[=file_name] The total directory where the configuration data is stored

--innodb_data_file_path[=file_name] Data storage file

Data files

. frm files record metadata information related to tables

. MyD file MyISAM storage engine, storing data for MyISAM tables

. Myi file MyISAM storage engine , which holds information about the indexes of MyISAM tables

. ibd files and. ibdata files, both of which are files that hold the InnoDB data, the exclusive tablespace stores the data with a ". BD" file to hold the data, and the shared tablespace stores the data with the ". Ibdata" file to hold the data

Repli

MySQL Learning notes