目录
❯ tree -L 1 -d
.
├── Docs # 文档
├── build
├── build-gs
├── build-ps
├── client
├── cmake
├── components
├── doc
├── doxygen_resources
├── extra # 第三方库,主要目的是为了多平台统一
├── greatdb-docs
├── greatdb-tools
├── include
├── internal
├── libbinlogevents
├── libbinlogstandalone
├── libchangestreams
├── libmysql
├── libservices
├── man
├── mysql-test
├── mysys
├── packaging
├── plugin
├── router
├── scripts
├── share
├── sql # 核心目录,优化器,执行器等
├── sql-common
├── storage # 存储引擎,插件实现
├── strings
├── support-files
├── testclients
├── unittest
├── utilities
└── vio
基础命令
这里是简单整理的一些基础命令的说明,但是没那么多精力一个一个的看过去
一些命令只是为了简化操作,不值得编写一个程序,不知道 MySQL 的研发怎么想的
-rw-r--r-- 1 asky asky 512 Apr 22 19:05 license.key
-rwxr-xr-x 1 asky asky 1.6K Apr 23 15:13 ps_mysqld_helper # 不知道,没见有人用
-rwxr-xr-x 1 asky asky 16K Apr 23 15:13 ps-admin # 管理插件的,方便安装和卸载某几插件,无用
-rwxr-xr-x 1 asky asky 517K Apr 23 15:13 mysqldumpslow # 分析慢查询日志的工具
-rwxr-xr-x 1 asky asky 1.9K Apr 23 15:13 mysqldecompress # 压缩工具
-rwxr-xr-x 1 asky asky 34K Apr 23 15:13 mysqld_safe # 启动脚本,监控 mysqld 进程,异常退出时可以自动重启,无法直接使用 ^C 退出,需要使用 mysqladmin 命令
-rwxr-xr-x 1 asky asky 28K Apr 23 15:13 mysqld_multi # 多实例启动脚本
-rwxr-xr-x 1 asky asky 4.9K Apr 23 15:13 mysql_config # 输出当前 MySQL 的基础信息
-rwxr-xr-x 1 asky asky 32K Apr 23 15:13 greatdbd_multi # 多实例启动脚本for greatdb
-r--r--r-x 1 asky asky 3.7K Apr 23 15:16 report_awr
-rwxr-xr-x 1 asky asky 3.2M Apr 23 15:16 license_client
-rwxr-xr-x 1 asky asky 11M Apr 23 15:16 mysql_ssl_rsa_setup
-rwxr-xr-x 1 asky asky 9.8M Apr 23 15:16 lz4_decompress
-rwxr-xr-x 1 asky asky 9.4M Apr 23 15:16 zstd_decompress
-rwxr-xr-x 1 asky asky 9.1M Apr 23 15:16 zlib_decompress
-rwxr-xr-x 1 asky asky 75K Apr 23 15:16 mysqltest_safe_process
-rwxr-xr-x 1 asky asky 9.9M Apr 23 15:16 my_print_defaults # 输出当前 MySQL 的 my.cnf 配置信息
-rwxr-xr-x 1 asky asky 11M Apr 23 15:16 comp_err
-rwxr-xr-x 1 asky asky 13M Apr 23 15:26 myisamlog
-rwxr-xr-x 1 asky asky 14M Apr 23 15:26 myisamchk
-rwxr-xr-x 1 asky asky 13M Apr 23 15:26 myisam_ftdump
-rwxr-xr-x 1 asky asky 13M Apr 23 15:26 myisampack
-rwxr-xr-x 1 asky asky 35M Apr 23 15:29 mysqlxtest
-rwxr-xr-x 1 asky asky 13M Apr 23 15:29 mysql_keyring_encryption_test
-rwxr-xr-x 1 asky asky 15M Apr 23 15:31 mysqlcheck
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysqlimport
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysqldump
-rwxr-xr-x 1 asky asky 11M Apr 23 15:32 mysqldecrypt
-rwxr-xr-x 1 asky asky 20M Apr 23 15:32 mysqltest # 测试工具,可以
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysqlshow #
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysqladmin # 管理工具,重点交互工具
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysqlslap
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysql_secure_installation
-rwxr-xr-x 1 asky asky 11M Apr 23 15:32 mysql_config_editor
-rwxr-xr-x 1 asky asky 17M Apr 23 15:32 mysql_upgrade
-rwxr-xr-x 1 asky asky 16M Apr 23 15:32 mysql
-rwxr-xr-x 1 asky asky 21M Apr 23 15:32 mysqlbinlog
-rwxr-xr-x 1 asky asky 12M Apr 23 15:32 perror
-rwxr-xr-x 1 asky asky 23M Apr 23 15:32 mysqlpump # 备份工具
-rwxr-xr-x 1 asky asky 17M Apr 23 15:32 mysql_migrate_keyring
-rwxr-xr-x 1 asky asky 15M Apr 23 15:32 mysql_client_load_balance_test
-rwxr-xr-x 1 asky asky 9.1M Apr 23 15:32 mysql_tzinfo_to_sql
-rwxr-xr-x 1 asky asky 16M Apr 23 15:32 mysql_client_test
-rwxr-xr-x 1 asky asky 13M Apr 23 15:32 innochecksum
-rwxr-xr-x 1 asky asky 13M Apr 23 15:32 ibd2sdi
-rwxr-xr-x 1 asky asky 796K Apr 23 15:43 mysqlrouter_plugin_info
-rwxr-xr-x 1 asky asky 1.2M Apr 23 15:43 mysqlrouter_keyring
-rwxr-xr-x 1 asky asky 1.1M Apr 23 15:43 mysqlrouter_passwd
-rwxr-xr-x 1 asky asky 7.8M Apr 23 15:43 mysqlrouter
-rwxr-xr-x 1 asky asky 836M Apr 23 15:50 mysqld
-rw-r--r-- 1 asky asky 31 Apr 23 18:10 mysqld.my
在bin的同级目录support-files中还存在如下文件
-rwxr-xr-x 1 asky asky 1.1K Apr 22 19:05 mysqld_multi.server
-rwxr-xr-x 1 asky asky 11K Apr 23 15:13 mysql.server # 数据库的启停使用这个
-rw-r--r-- 1 asky asky 2.0K Apr 23 15:13 mysql-log-rotate