MySQL的目录结构及文件说明


前言

本文主要介绍下MySQL的目录结构及文件说明


测试环境

虚拟机环境:VirtualBox 6.0.24
操作系统:Oracle Linux Server release 6.5 x86_64
MySQL版本:5.7.33


MySQL的目录结构及文件说明

不同安装包,目录结构会有所不同。本环境为二进制安装包。
如下所示:

#查看mysql是否启动
[root@rac02 ~]# ps -ef|grep mysql
root     24580 24537  0 10:21 pts/0    00:00:00 grep mysql

#未启动,则手动启动mysql
[root@rac02 ~]# service mysql start
Starting MySQL.                                            [  OK  ]

#再次校验mysql进程是否存在
[root@rac02 ~]# ps -ef|grep mysql
root     24659     1  0 10:21 pts/0    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/mysql-files --pid-file=/usr/local/mysql/mysql-files/rac02.pid
mysql    25633 24659  4 10:21 pts/0    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/mysql-files --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/mysql-files/error.log --open-files-limit=65535 --pid-file=/usr/local/mysql/mysql-files/rac02.pid --socket=/usr/local/mysql/mysql-files/mysql.sock --port=3306
root     25781 24537  0 10:21 pts/0    00:00:00 grep mysql

#进入mysql根目录
[root@rac02 ~]# cd /usr/local/mysql/

#mysql目录结构
[root@rac02 mysql]# ls
bin  docs  include  lib  LICENSE  man  mysql-files  README  share  support-files
[root@rac02 mysql]# ls -al
total 292
drwxr-xr-x  10 root  root    4096 Jan 26 15:41 .
drwxr-xr-x. 13 root  root    4096 Jan 26 15:38 ..
drwxr-xr-x   2 root  root    4096 Jan 26 15:37 bin
drwxr-xr-x   2 root  root    4096 Jan 26 15:37 docs
drwxr-xr-x   3 root  root    4096 Jan 26 15:37 include
drwxr-xr-x   5 root  root    4096 Jan 26 15:37 lib
-rw-r--r--   1  7161 31415 250129 Dec 10  2020 LICENSE
drwxr-xr-x   4 root  root    4096 Jan 26 15:37 man
drwxr-x---   6 mysql mysql   4096 Jan 27 10:21 mysql-files
-rw-r--r--   1  7161 31415    566 Dec 10  2020 README
drwxr-xr-x  28 root  root    4096 Jan 26 15:37 share
drwxr-xr-x   2 root  root    4096 Jan 26 15:37 support-files

目录解释如下:
bin: 包含客户端程序和mysqld等二进制可执行文件。
docs: 包含ChangeLog、INFO_BIN、INFO_SRC等信息。
include: 包含(头) 文件的目录。
lib: 可动态加载的so库文件目录。
man: 包含man1、 man8。
share: 包含MySQL初始化的一些SQL脚本以及错误代码、 本地化语言文件等。
support-files: 包含单实例启停脚本mysql.server和多实例启停脚本 mysqld_multi.server等。
mysql-files:自定义的数据文件目录。

#实际查看情况如下:
[root@rac02 mysql]# cd bin
[root@rac02 bin]# ls
innochecksum       mysqladmin                  mysqld_multi      mysqlpump                  mysqlxtest
lz4_decompress     mysqlbinlog                 mysqld_safe       mysql_secure_installation  perror
myisamchk          mysqlcheck                  mysqldump         mysqlshow                  replace
myisam_ftdump      mysql_client_test_embedded  mysqldumpslow     mysqlslap                  resolveip
myisamlog          mysql_config                mysql_embedded    mysql_ssl_rsa_setup        resolve_stack_dump
myisampack         mysql_config_editor         mysqlimport       mysqltest_embedded         zlib_decompress
my_print_defaults  mysqld                      mysql_install_db  mysql_tzinfo_to_sql
mysql              mysqld-debug                mysql_plugin      mysql_upgrade
[root@rac02 bin]# cd ../docs
[root@rac02 docs]# ls
ChangeLog  INFO_BIN  INFO_SRC
[root@rac02 docs]# cd ../include/
[root@rac02 include]# ls
big_endian.h              my_byteorder.h  mysql_com_server.h  my_thread.h                 sslopt-case.h
binary_log_types.h        my_command.h    mysqld_ername.h     my_thread_local.h           sslopt-longopts.h
byte_order_generic.h      my_compiler.h   mysqld_error.h      my_xml.h                    sslopt-vars.h
byte_order_generic_x86.h  my_config.h     mysql_embed.h       plugin_audit.h              thr_cond.h
decimal.h                 my_dbug.h       mysql.h             plugin_ftparser.h           thr_mutex.h
errmsg.h                  my_dir.h        mysql_time.h        plugin_group_replication.h  thr_rwlock.h
keycache.h                my_getopt.h     mysql_version.h     plugin.h                    typelib.h
little_endian.h           my_global.h     mysqlx_ername.h     plugin_keyring.h
m_ctype.h                 my_list.h       mysqlx_error.h      plugin_validate_password.h
m_string.h                mysql           mysqlx_version.h    sql_common.h
my_alloc.h                mysql_com.h     my_sys.h            sql_state.h
[root@rac02 include]# cd ../lib
[root@rac02 lib]# ls
libmysqlclient.a   libmysqlclient.so.20       libmysqld.a        libmysqlservices.a  pkgconfig
libmysqlclient.so  libmysqlclient.so.20.3.20  libmysqld-debug.a  mecab               plugin
[root@rac02 lib]# cd ../man
[root@rac02 man]# ls
man1  man8
[root@rac02 man]# cd man1
[root@rac02 man1]# ls
comp_err.1        my_print_defaults.1    mysqld_multi.1      mysql_plugin.1               mysql_tzinfo_to_sql.1
innochecksum.1    mysql.1                mysqld_safe.1       mysqlpump.1                  mysql_upgrade.1
lz4_decompress.1  mysqladmin.1           mysqldump.1         mysql_secure_installation.1  perror.1
myisamchk.1       mysqlbinlog.1          mysqldumpslow.1     mysql.server.1               replace.1
myisam_ftdump.1   mysqlcheck.1           mysqlimport.1       mysqlshow.1                  resolveip.1
myisamlog.1       mysql_config.1         mysql_install_db.1  mysqlslap.1                  resolve_stack_dump.1
myisampack.1      mysql_config_editor.1  mysqlman.1          mysql_ssl_rsa_setup.1        zlib_decompress.1
[root@rac02 man1]# cd ../../share/
[root@rac02 share]# ls
aclocal          fill_help_tables.sql         mysql_security_commands.sql   russian
bulgarian        french                       mysql_sys_schema.sql          serbian
charsets         german                       mysql_system_tables_data.sql  slovak
czech            greek                        mysql_system_tables.sql       spanish
danish           hungarian                    mysql_test_data_timezone.sql  swedish
dictionary.txt   innodb_memcached_config.sql  norwegian                     ukrainian
dutch            install_rewriter.sql         norwegian-ny                  uninstall_rewriter.sql
english          italian                      polish
errmsg-utf8.txt  japanese                     portuguese
estonian         korean                       romanian
[root@rac02 share]# cd ../support-files/
[root@rac02 support-files]# ls
magic  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@rac02 support-files]# 
数据文件目录如下所示
[root@rac02 mysql-files]# ls -al
total 639228
drwxr-x---  6 mysql mysql      4096 Jan 27 10:21 .
drwxr-xr-x 10 root  root       4096 Jan 26 15:41 ..
-rw-r-----  1 mysql mysql        56 Jan 26 16:06 auto.cnf
-rw-------  1 mysql mysql      1676 Jan 26 16:06 ca-key.pem
-rw-r--r--  1 mysql mysql      1112 Jan 26 16:06 ca.pem
-rw-r--r--  1 mysql mysql      1112 Jan 26 16:06 client-cert.pem
-rw-------  1 mysql mysql      1680 Jan 26 16:06 client-key.pem
-rw-r-----  1 mysql mysql     78280 Jan 27 10:21 error.log
-rw-r-----  1 mysql mysql       347 Jan 27 06:29 ib_buffer_pool
-rw-r-----  1 mysql mysql  12582912 Jan 27 10:21 ibdata1
-rw-r-----  1 mysql mysql 209715200 Jan 27 10:21 ib_logfile0
-rw-r-----  1 mysql mysql 209715200 Jan 26 20:15 ib_logfile1
-rw-r-----  1 mysql mysql 209715200 Jan 26 20:15 ib_logfile2
-rw-r-----  1 mysql mysql  12582912 Jan 27 10:21 ibtmp1
-rw-r-----  1 mysql mysql      6101 Jan 27 10:40 innodb_status.25633
drwxr-x---  2 mysql mysql      4096 Jan 26 16:06 mysql
-rw-r-----  1 mysql mysql       177 Jan 26 20:26 mysql_binlog.000001
-rw-r-----  1 mysql mysql       177 Jan 26 20:28 mysql_binlog.000002
-rw-r-----  1 mysql mysql       177 Jan 26 20:29 mysql_binlog.000003
-rw-r-----  1 mysql mysql       177 Jan 26 20:30 mysql_binlog.000004
-rw-r-----  1 mysql mysql       177 Jan 26 20:34 mysql_binlog.000005
-rw-r-----  1 mysql mysql       336 Jan 26 21:01 mysql_binlog.000006
-rw-r-----  1 mysql mysql       217 Jan 26 21:08 mysql_binlog.000007
-rw-r-----  1 mysql mysql       217 Jan 26 21:14 mysql_binlog.000008
-rw-r-----  1 mysql mysql       217 Jan 26 21:15 mysql_binlog.000009
-rw-r-----  1 mysql mysql       217 Jan 26 21:16 mysql_binlog.000010
-rw-r-----  1 mysql mysql       217 Jan 27 03:24 mysql_binlog.000011
-rw-r-----  1 mysql mysql       217 Jan 27 03:28 mysql_binlog.000012
-rw-r-----  1 mysql mysql       217 Jan 27 03:28 mysql_binlog.000013
-rw-r-----  1 mysql mysql       861 Jan 27 05:22 mysql_binlog.000014
-rw-r-----  1 mysql mysql       217 Jan 27 06:29 mysql_binlog.000015
-rw-r-----  1 mysql mysql       194 Jan 27 10:21 mysql_binlog.000016
-rw-r-----  1 mysql mysql       784 Jan 27 10:21 mysql_binlog.index
srwxrwxrwx  1 mysql mysql         0 Jan 27 10:21 mysql.sock
-rw-------  1 mysql mysql         6 Jan 27 10:21 mysql.sock.lock
drwxr-x---  2 mysql mysql      4096 Jan 26 16:06 performance_schema
-rw-------  1 mysql mysql      1680 Jan 26 16:06 private_key.pem
-rw-r--r--  1 mysql mysql       452 Jan 26 16:06 public_key.pem
-rw-r-----  1 mysql mysql         6 Jan 27 10:21 rac02.pid
-rw-r--r--  1 mysql mysql      1112 Jan 26 16:06 server-cert.pem
-rw-------  1 mysql mysql      1680 Jan 26 16:06 server-key.pem
-rw-r-----  1 mysql mysql      3846 Jan 27 10:21 slow.log
drwxr-x---  2 mysql mysql     12288 Jan 26 16:06 sys
drwxr-x---  2 mysql mysql      4096 Jan 26 20:45 test



[root@rac02 mysql-files]# tree
.
├── auto.cnf
├── ca-key.pem
├── ca.pem
├── client-cert.pem
├── client-key.pem
├── error.log
├── ib_buffer_pool
├── ibdata1
├── ib_logfile0
├── ib_logfile1
├── ib_logfile2
├── ibtmp1
├── innodb_status.25633
├── mysql
│   ├── columns_priv.frm
│   ├── columns_priv.MYD
│   ├── columns_priv.MYI
│   ├── db.frm
│   ├── db.MYD
│   ├── db.MYI
│   ├── db.opt
│   ├── engine_cost.frm
│   ├── engine_cost.ibd
│   ├── event.frm
│   ├── event.MYD
│   ├── event.MYI
│   ├── func.frm
│   ├── func.MYD
│   ├── func.MYI
│   ├── general_log.CSM
│   ├── general_log.CSV
│   ├── general_log.frm
│   ├── gtid_executed.frm
│   ├── gtid_executed.ibd
│   ├── help_category.frm
│   ├── help_category.ibd
│   ├── help_keyword.frm
│   ├── help_keyword.ibd
│   ├── help_relation.frm
│   ├── help_relation.ibd
│   ├── help_topic.frm
│   ├── help_topic.ibd
│   ├── innodb_index_stats.frm
│   ├── innodb_index_stats.ibd
│   ├── innodb_table_stats.frm
│   ├── innodb_table_stats.ibd
│   ├── ndb_binlog_index.frm
│   ├── ndb_binlog_index.MYD
│   ├── ndb_binlog_index.MYI
│   ├── plugin.frm
│   ├── plugin.ibd
│   ├── proc.frm
│   ├── proc.MYD
│   ├── proc.MYI
│   ├── procs_priv.frm
│   ├── procs_priv.MYD
│   ├── procs_priv.MYI
│   ├── proxies_priv.frm
│   ├── proxies_priv.MYD
│   ├── proxies_priv.MYI
│   ├── server_cost.frm
│   ├── server_cost.ibd
│   ├── servers.frm
│   ├── servers.ibd
│   ├── slave_master_info.frm
│   ├── slave_master_info.ibd
│   ├── slave_relay_log_info.frm
│   ├── slave_relay_log_info.ibd
│   ├── slave_worker_info.frm
│   ├── slave_worker_info.ibd
│   ├── slow_log.CSM
│   ├── slow_log.CSV
│   ├── slow_log.frm
│   ├── tables_priv.frm
│   ├── tables_priv.MYD
│   ├── tables_priv.MYI
│   ├── time_zone.frm
│   ├── time_zone.ibd
│   ├── time_zone_leap_second.frm
│   ├── time_zone_leap_second.ibd
│   ├── time_zone_name.frm
│   ├── time_zone_name.ibd
│   ├── time_zone_transition.frm
│   ├── time_zone_transition.ibd
│   ├── time_zone_transition_type.frm
│   ├── time_zone_transition_type.ibd
│   ├── user.frm
│   ├── user.MYD
│   └── user.MYI
├── mysql_binlog.000001
├── mysql_binlog.000002
├── mysql_binlog.000003
├── mysql_binlog.000004
├── mysql_binlog.000005
├── mysql_binlog.000006
├── mysql_binlog.000007
├── mysql_binlog.000008
├── mysql_binlog.000009
├── mysql_binlog.000010
├── mysql_binlog.000011
├── mysql_binlog.000012
├── mysql_binlog.000013
├── mysql_binlog.000014
├── mysql_binlog.000015
├── mysql_binlog.000016
├── mysql_binlog.index
├── mysql.sock
├── mysql.sock.lock
├── performance_schema
│   ├── accounts.frm
│   ├── cond_instances.frm
│   ├── db.opt
│   ├── events_stages_current.frm
│   ├── events_stages_history.frm
│   ├── events_stages_history_long.frm
│   ├── events_stages_summary_by_account_by_event_name.frm
│   ├── events_stages_summary_by_host_by_event_name.frm
│   ├── events_stages_summary_by_thread_by_event_name.frm
│   ├── events_stages_summary_by_user_by_event_name.frm
│   ├── events_stages_summary_global_by_event_name.frm
│   ├── events_statements_current.frm
│   ├── events_statements_history.frm
│   ├── events_statements_history_long.frm
│   ├── events_statements_summary_by_account_by_event_name.frm
│   ├── events_statements_summary_by_digest.frm
│   ├── events_statements_summary_by_host_by_event_name.frm
│   ├── events_statements_summary_by_program.frm
│   ├── events_statements_summary_by_thread_by_event_name.frm
│   ├── events_statements_summary_by_user_by_event_name.frm
│   ├── events_statements_summary_global_by_event_name.frm
│   ├── events_transactions_current.frm
│   ├── events_transactions_history.frm
│   ├── events_transactions_history_long.frm
│   ├── events_transactions_summary_by_account_by_event_name.frm
│   ├── events_transactions_summary_by_host_by_event_name.frm
│   ├── events_transactions_summary_by_thread_by_event_name.frm
│   ├── events_transactions_summary_by_user_by_event_name.frm
│   ├── events_transactions_summary_global_by_event_name.frm
│   ├── events_waits_current.frm
│   ├── events_waits_history.frm
│   ├── events_waits_history_long.frm
│   ├── events_waits_summary_by_account_by_event_name.frm
│   ├── events_waits_summary_by_host_by_event_name.frm
│   ├── events_waits_summary_by_instance.frm
│   ├── events_waits_summary_by_thread_by_event_name.frm
│   ├── events_waits_summary_by_user_by_event_name.frm
│   ├── events_waits_summary_global_by_event_name.frm
│   ├── file_instances.frm
│   ├── file_summary_by_event_name.frm
│   ├── file_summary_by_instance.frm
│   ├── global_status.frm
│   ├── global_variables.frm
│   ├── host_cache.frm
│   ├── hosts.frm
│   ├── memory_summary_by_account_by_event_name.frm
│   ├── memory_summary_by_host_by_event_name.frm
│   ├── memory_summary_by_thread_by_event_name.frm
│   ├── memory_summary_by_user_by_event_name.frm
│   ├── memory_summary_global_by_event_name.frm
│   ├── metadata_locks.frm
│   ├── mutex_instances.frm
│   ├── objects_summary_global_by_type.frm
│   ├── performance_timers.frm
│   ├── prepared_statements_instances.frm
│   ├── replication_applier_configuration.frm
│   ├── replication_applier_status_by_coordinator.frm
│   ├── replication_applier_status_by_worker.frm
│   ├── replication_applier_status.frm
│   ├── replication_connection_configuration.frm
│   ├── replication_connection_status.frm
│   ├── replication_group_members.frm
│   ├── replication_group_member_stats.frm
│   ├── rwlock_instances.frm
│   ├── session_account_connect_attrs.frm
│   ├── session_connect_attrs.frm
│   ├── session_status.frm
│   ├── session_variables.frm
│   ├── setup_actors.frm
│   ├── setup_consumers.frm
│   ├── setup_instruments.frm
│   ├── setup_objects.frm
│   ├── setup_timers.frm
│   ├── socket_instances.frm
│   ├── socket_summary_by_event_name.frm
│   ├── socket_summary_by_instance.frm
│   ├── status_by_account.frm
│   ├── status_by_host.frm
│   ├── status_by_thread.frm
│   ├── status_by_user.frm
│   ├── table_handles.frm
│   ├── table_io_waits_summary_by_index_usage.frm
│   ├── table_io_waits_summary_by_table.frm
│   ├── table_lock_waits_summary_by_table.frm
│   ├── threads.frm
│   ├── users.frm
│   ├── user_variables_by_thread.frm
│   └── variables_by_thread.frm
├── private_key.pem
├── public_key.pem
├── rac02.pid
├── server-cert.pem
├── server-key.pem
├── slow.log
├── sys
│   ├── db.opt
│   ├── host_summary_by_file_io.frm
│   ├── host_summary_by_file_io_type.frm
│   ├── host_summary_by_stages.frm
│   ├── host_summary_by_statement_latency.frm
│   ├── host_summary_by_statement_type.frm
│   ├── host_summary.frm
│   ├── innodb_buffer_stats_by_schema.frm
│   ├── innodb_buffer_stats_by_table.frm
│   ├── innodb_lock_waits.frm
│   ├── io_by_thread_by_latency.frm
│   ├── io_global_by_file_by_bytes.frm
│   ├── io_global_by_file_by_latency.frm
│   ├── io_global_by_wait_by_bytes.frm
│   ├── io_global_by_wait_by_latency.frm
│   ├── latest_file_io.frm
│   ├── memory_by_host_by_current_bytes.frm
│   ├── memory_by_thread_by_current_bytes.frm
│   ├── memory_by_user_by_current_bytes.frm
│   ├── memory_global_by_current_bytes.frm
│   ├── memory_global_total.frm
│   ├── metrics.frm
│   ├── processlist.frm
│   ├── ps_check_lost_instrumentation.frm
│   ├── schema_auto_increment_columns.frm
│   ├── schema_index_statistics.frm
│   ├── schema_object_overview.frm
│   ├── schema_redundant_indexes.frm
│   ├── schema_table_lock_waits.frm
│   ├── schema_table_statistics.frm
│   ├── schema_table_statistics_with_buffer.frm
│   ├── schema_tables_with_full_table_scans.frm
│   ├── schema_unused_indexes.frm
│   ├── session.frm
│   ├── session_ssl_status.frm
│   ├── statement_analysis.frm
│   ├── statements_with_errors_or_warnings.frm
│   ├── statements_with_full_table_scans.frm
│   ├── statements_with_runtimes_in_95th_percentile.frm
│   ├── statements_with_sorting.frm
│   ├── statements_with_temp_tables.frm
│   ├── sys_config.frm
│   ├── sys_config.ibd
│   ├── sys_config_insert_set_user.TRN
│   ├── sys_config.TRG
│   ├── sys_config_update_set_user.TRN
│   ├── user_summary_by_file_io.frm
│   ├── user_summary_by_file_io_type.frm
│   ├── user_summary_by_stages.frm
│   ├── user_summary_by_statement_latency.frm
│   ├── user_summary_by_statement_type.frm
│   ├── user_summary.frm
│   ├── version.frm
│   ├── wait_classes_global_by_avg_latency.frm
│   ├── wait_classes_global_by_latency.frm
│   ├── waits_by_host_by_latency.frm
│   ├── waits_by_user_by_latency.frm
│   ├── waits_global_by_latency.frm
│   ├── x@0024host_summary_by_file_io.frm
│   ├── x@0024host_summary_by_file_io_type.frm
│   ├── x@0024host_summary_by_stages.frm
│   ├── x@0024host_summary_by_statement_latency.frm
│   ├── x@0024host_summary_by_statement_type.frm
│   ├── x@0024host_summary.frm
│   ├── x@0024innodb_buffer_stats_by_schema.frm
│   ├── x@0024innodb_buffer_stats_by_table.frm
│   ├── x@0024innodb_lock_waits.frm
│   ├── x@0024io_by_thread_by_latency.frm
│   ├── x@0024io_global_by_file_by_bytes.frm
│   ├── x@0024io_global_by_file_by_latency.frm
│   ├── x@0024io_global_by_wait_by_bytes.frm
│   ├── x@0024io_global_by_wait_by_latency.frm
│   ├── x@0024latest_file_io.frm
│   ├── x@0024memory_by_host_by_current_bytes.frm
│   ├── x@0024memory_by_thread_by_current_bytes.frm
│   ├── x@0024memory_by_user_by_current_bytes.frm
│   ├── x@0024memory_global_by_current_bytes.frm
│   ├── x@0024memory_global_total.frm
│   ├── x@0024processlist.frm
│   ├── x@0024ps_digest_95th_percentile_by_avg_us.frm
│   ├── x@0024ps_digest_avg_latency_distribution.frm
│   ├── x@0024ps_schema_table_statistics_io.frm
│   ├── x@0024schema_flattened_keys.frm
│   ├── x@0024schema_index_statistics.frm
│   ├── x@0024schema_table_lock_waits.frm
│   ├── x@0024schema_table_statistics.frm
│   ├── x@0024schema_table_statistics_with_buffer.frm
│   ├── x@0024schema_tables_with_full_table_scans.frm
│   ├── x@0024session.frm
│   ├── x@0024statement_analysis.frm
│   ├── x@0024statements_with_errors_or_warnings.frm
│   ├── x@0024statements_with_full_table_scans.frm
│   ├── x@0024statements_with_runtimes_in_95th_percentile.frm
│   ├── x@0024statements_with_sorting.frm
│   ├── x@0024statements_with_temp_tables.frm
│   ├── x@0024user_summary_by_file_io.frm
│   ├── x@0024user_summary_by_file_io_type.frm
│   ├── x@0024user_summary_by_stages.frm
│   ├── x@0024user_summary_by_statement_latency.frm
│   ├── x@0024user_summary_by_statement_type.frm
│   ├── x@0024user_summary.frm
│   ├── x@0024wait_classes_global_by_avg_latency.frm
│   ├── x@0024wait_classes_global_by_latency.frm
│   ├── x@0024waits_by_host_by_latency.frm
│   ├── x@0024waits_by_user_by_latency.frm
│   └── x@0024waits_global_by_latency.frm
└── test
    └── db.opt

4 directories, 308 files

数据文件: .frm、.MYI、.MYD、.ibd、.ibdata1、ib_logfile*、ibtmp1、auto.cnf、db.opt、.CSM、.CSV、.TRN、.TRG。

  1. .frm:表结构定义文件。
  2. .MYI:MyISAM存储引擎索引文件。
  3. .MYD:MyISAM存储引擎数据文件。
  4. .ibd:InnoDB存储引擎独立表空间文件。
  5. ibdata1:InnoDB存储引擎共享表空间文件。
  6. ib_logfile*:InnoDB存储引擎redo log文件。
  7. ibtmp1:InnoDB存储引擎临时表空间文件。
  8. auto.cnf:用于存放MySQL实例的全局唯一的server-uuid的文件。
  9. db.opt:包含数据库配置信息的文件。
  10. .CSM:用于存放CSV存储引擎的元数据等相关信息的文件。
  11. .CSV:用于存放CSV存储引擎的数据文件,每行数据的列值之间使用逗号分隔。
  12. .TRN:用于存放与触发器相关的元数据。
  13. .TRG:用于存放触发器定义语句以及与定义相关的信息。
  14. 日志文件:error.log(错误日志文件)、mysql_binlog.*(二进制日志文件)、slow.log(慢日志文件)

此部分可以参考官方文档,链接: https://dev.mysql.com/doc/refman/5.7/en/glossary.html.

以上说明来源于官方文档及相关书籍阅读整理。
如有错误,请指正,非常感谢!


  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

大白快跑

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值