MySQL中mysqld.exe与mysql.exe的区别?

阿里云-轻量应用服务器

前文说了MySQL应用程序的安装目录结构:

MySQL目录结构

里面bin目录用于放置 MySQL 可执行文件,如mysql.exe、mysqld.exe、mysqlshow.exe等。

其中几个较为重要的:

mysqld.exe

mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.

mysqld是MySQL的主程序,mysqld意思是mysql daemon(后台进程),在后台运行,监听3306端口。

mysql.exe

mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is presented in tab-separated format. The output format can be changed using command options.

mysql是MySQL的命令行工具,是一个客户端软件,可以对任何主机的mysql服务(即后台运行的mysqld)发起连接。

mysqladmin.exe

mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more.

mysqladmin 是一个执行管理操作的客户端,例如创建或删除数据库,重新加载授权表,将表刷新到磁盘以及重新打开日志文件。

mysqlshow.exe

The mysqlshow client can be used to quickly see which databases exist, their tables, or a table’s columns or indexes.

mysqlshow 是用来查看当前数据库、表、索引、视图等

mysqldump.exe

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.

mysqldump 是mysql 数据导出及备份工具。

mysqlslap.exe

mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server.

mysqlslap是mysql 性能分析测试工具。

参考资料:

MySQL程序概述


关注微信公众号

码中人 微信公众号