通过 apt 和 apt-file 列出 mysql 提供的所有可执行文件。

MariaDB 的命令好像是多了一大截，不过我们在服务器上目前还是部署 MySQL 比较多。

总结

• mysqld / mariadbd 服务器
• mysql / mariadb 客户端
• mysqld_multi
• mysqld_safe

InnoDB 相关

• innochecksum
• innotop (mariadb)

MyISAM 相关

• myisamchk
• myisamlog
• myisampack
• myisam_ftdump

工具

• mysqlbinlog Binlog
• mysqlslow 慢日志查询
• mysqldump 数据备份
• mysqlcheck 数据库维护
  有三个别名：mysqlanalyze (-a) / mysqloptimize (-o) / mysqlrepair (-r)
• mysqlslap 性能测试

其他命令

• my_print_defaults
• mysql_secure_installation 安装的时候用
• perror 错误码说明

罗列：MySQL

mysql-server
    mysql-server-8.0
        mysql-client-8.0
            mysql-common
            mysql-client-core-8.0
        mysql-common
        mysql-server-core-8.0

mysql-client
    mysql-client-8.0

mysql-server-core-8.0: /usr/bin/ibd2sdi
mysql-server-core-8.0: /usr/bin/innochecksum
mysql-server-core-8.0: /usr/bin/my_print_defaults
mysql-server-core-8.0: /usr/bin/myisamchk
mysql-server-core-8.0: /usr/bin/myisamlog
mysql-server-core-8.0: /usr/bin/myisampack
mysql-server-core-8.0: /usr/bin/mysql_migrate_keyring
mysql-server-core-8.0: /usr/bin/mysql_secure_installation
mysql-server-core-8.0: /usr/bin/mysql_ssl_rsa_setup
mysql-server-core-8.0: /usr/bin/mysql_tzinfo_to_sql
mysql-server-core-8.0: /usr/bin/mysql_upgrade
mysql-server-core-8.0: /usr/bin/mysqlbinlog
mysql-server-core-8.0: /usr/bin/mysqld_multi
mysql-server-core-8.0: /usr/bin/mysqld_safe
mysql-server-core-8.0: /usr/bin/perror
mysql-server-core-8.0: /usr/sbin/mysqld

mysql-client-8.0: /usr/bin/mysqlanalyze
mysql-client-8.0: /usr/bin/mysqloptimize
mysql-client-8.0: /usr/bin/mysqlrepair
mysql-client-8.0: /usr/bin/mysqlreport

mysql-client-core-8.0: /usr/bin/myisam_ftdump
mysql-client-core-8.0: /usr/bin/mysql
mysql-client-core-8.0: /usr/bin/mysql_config_editor
mysql-client-core-8.0: /usr/bin/mysqladmin
mysql-client-core-8.0: /usr/bin/mysqlcheck
mysql-client-core-8.0: /usr/bin/mysqldump
mysql-client-core-8.0: /usr/bin/mysqldumpslow
mysql-client-core-8.0: /usr/bin/mysqlimport
mysql-client-core-8.0: /usr/bin/mysqlpump
mysql-client-core-8.0: /usr/bin/mysqlshow
mysql-client-core-8.0: /usr/bin/mysqlslap

罗列：MariaDB 部分

mariadb-server
    mariadb-server-10.5
        mariadb-client-10.5
            mariadb-client-core-10.5
                mariadb-common
        mariadb-server-core-10.5
            mariadb-common

mariadb-server-10.5: /usr/bin/aria_chk
mariadb-server-10.5: /usr/bin/aria_dump_log
mariadb-server-10.5: /usr/bin/aria_ftdump
mariadb-server-10.5: /usr/bin/aria_pack
mariadb-server-10.5: /usr/bin/aria_read_log
mariadb-server-10.5: /usr/bin/galera_new_cluster
mariadb-server-10.5: /usr/bin/galera_recovery
mariadb-server-10.5: /usr/bin/mariadb-binlog
mariadb-server-10.5: /usr/bin/mariadb-convert-table-format
mariadb-server-10.5: /usr/bin/mariadb-hotcopy
mariadb-server-10.5: /usr/bin/mariadb-plugin
mariadb-server-10.5: /usr/bin/mariadb-secure-installation
mariadb-server-10.5: /usr/bin/mariadb-service-convert
mariadb-server-10.5: /usr/bin/mariadb-setpermission
mariadb-server-10.5: /usr/bin/mariadb-tzinfo-to-sql
mariadb-server-10.5: /usr/bin/mariadbd-multi
mariadb-server-10.5: /usr/bin/mariadbd-safe
mariadb-server-10.5: /usr/bin/mariadbd-safe-helper
mariadb-server-10.5: /usr/bin/msql2mysql
mariadb-server-10.5: /usr/bin/myisam_ftdump
mariadb-server-10.5: /usr/bin/myisamchk
mariadb-server-10.5: /usr/bin/myisamlog
mariadb-server-10.5: /usr/bin/myisampack
mariadb-server-10.5: /usr/bin/mysql_convert_table_format
mariadb-server-10.5: /usr/bin/mysql_plugin
mariadb-server-10.5: /usr/bin/mysql_secure_installation
mariadb-server-10.5: /usr/bin/mysql_setpermission
mariadb-server-10.5: /usr/bin/mysql_tzinfo_to_sql
mariadb-server-10.5: /usr/bin/mysqlbinlog
mariadb-server-10.5: /usr/bin/mysqld_multi
mariadb-server-10.5: /usr/bin/mysqld_safe
mariadb-server-10.5: /usr/bin/mysqld_safe_helper
mariadb-server-10.5: /usr/bin/mysqlhotcopy
mariadb-server-10.5: /usr/bin/perror
mariadb-server-10.5: /usr/bin/replace
mariadb-server-10.5: /usr/bin/resolve_stack_dump
mariadb-server-10.5: /usr/bin/wsrep_sst_common
mariadb-server-10.5: /usr/bin/wsrep_sst_mariabackup
mariadb-server-10.5: /usr/bin/wsrep_sst_mysqldump
mariadb-server-10.5: /usr/bin/wsrep_sst_rsync
mariadb-server-10.5: /usr/bin/wsrep_sst_rsync_wan

mariadb-client-10.5: /usr/bin/innotop
mariadb-client-10.5: /usr/bin/mariadb-access
mariadb-client-10.5: /usr/bin/mariadb-admin
mariadb-client-10.5: /usr/bin/mariadb-analyze
mariadb-client-10.5: /usr/bin/mariadb-conv
mariadb-client-10.5: /usr/bin/mariadb-dump
mariadb-client-10.5: /usr/bin/mariadb-dumpslow
mariadb-client-10.5: /usr/bin/mariadb-find-rows
mariadb-client-10.5: /usr/bin/mariadb-fix-extensions
mariadb-client-10.5: /usr/bin/mariadb-import
mariadb-client-10.5: /usr/bin/mariadb-optimize
mariadb-client-10.5: /usr/bin/mariadb-repair
mariadb-client-10.5: /usr/bin/mariadb-report
mariadb-client-10.5: /usr/bin/mariadb-show
mariadb-client-10.5: /usr/bin/mariadb-slap
mariadb-client-10.5: /usr/bin/mariadb-waitpid
mariadb-client-10.5: /usr/bin/mariadbcheck
mariadb-client-10.5: /usr/bin/mysql_find_rows
mariadb-client-10.5: /usr/bin/mysql_fix_extensions
mariadb-client-10.5: /usr/bin/mysql_waitpid
mariadb-client-10.5: /usr/bin/mysqlaccess
mariadb-client-10.5: /usr/bin/mysqladmin
mariadb-client-10.5: /usr/bin/mysqlanalyze
mariadb-client-10.5: /usr/bin/mysqlcheck
mariadb-client-10.5: /usr/bin/mysqldump
mariadb-client-10.5: /usr/bin/mysqldumpslow
mariadb-client-10.5: /usr/bin/mysqlimport
mariadb-client-10.5: /usr/bin/mysqloptimize
mariadb-client-10.5: /usr/bin/mysqlrepair
mariadb-client-10.5: /usr/bin/mysqlreport
mariadb-client-10.5: /usr/bin/mysqlshow
mariadb-client-10.5: /usr/bin/mysqlslap
mariadb-client-10.5: /usr/bin/mytop

mariadb-server-core-10.5: /usr/bin/innochecksum
mariadb-server-core-10.5: /usr/bin/mariadb-install-db
mariadb-server-core-10.5: /usr/bin/mariadb-upgrade
mariadb-server-core-10.5: /usr/bin/my_print_defaults
mariadb-server-core-10.5: /usr/bin/mysql_install_db
mariadb-server-core-10.5: /usr/bin/mysql_upgrade
mariadb-server-core-10.5: /usr/bin/resolveip
mariadb-server-core-10.5: /usr/sbin/mariadbd
mariadb-server-core-10.5: /usr/sbin/mysqld

mariadb-client-core-10.5: /usr/bin/mariadb
mariadb-client-core-10.5: /usr/bin/mariadb-check
mariadb-client-core-10.5: /usr/bin/mysql

其他

• percona-toolkit