[MySQL Reference Manual] 4 MYSQL Program

4 MYSQL Program

Directory

4 MYSQL Program .. 1

4.3 MySQL Server and Server startup program... 1

4.3.1 mysqld. 1

4.3.2 mysqld_safe. 1

4.3.3 mysql. server. 1

4.3.4 mysqld_multi1

4.4 MySQL installation-related Program... 2

4.4.1 comp_err. 2

4.4.2 mysqlbug. 2

4.4.3 mysql_install_db. 2

4.4.4 mysql_plugin. 2

4.4.5 mysql_secure_installation. 3

4.4.6 mysql_tzinfo_to_sql3

4.4.7 mysql_upgrade. 3

4.5 MySQL client program... 4

4.5.1 mysql4

4.5.2 mysqladmin. 4

4.5.3 mysqlcheck. 4

4.5.4 mysqldump. 5

4.5.5 mysqlimport. 5

4.5.6 mysqlshow... 5

4.5.7 mysqlslap. 6

4.6 MySQL management and efficiency Programs. 6

4.6.1 innochecksum... 6

4.6.2 myisam_ftdump. 6

4.6.3 myisamchk. 7

4.6.4 myisamlog. 7

4.6.5 myisampack. 7

4.6.6 mysql_config_editor. 7

4.6.7 mysqlaccess. 8

4.6.8 mysqlbinlog. 8

4.6.9 mysqldumpslow... 9

4.6.10 mysqlhotcopy. 9

4.6.11 mysql_convert_table_format. 9

4.6.12 mysql_find_rows. 9

4.6.13 mysql_fix_extensions. 10

4.6.14 mysql_setpermission. 10

4.6.15 mysql_waitpid. 10

4.6.16 mysql_zap. 10

4.7 Mysql development tool... 10

4.8 other program... 10

 

 

4.3 MySQL Server and Server startup program 4.3.1 mysqld

Mysqld is a mysql service program that listens to ports and affects the behavior of mysqld through system variables and configuration parameters.

4.3.2 mysqld_safe

Mysqld_safe is a recommended startup Method on unix servers. mysqld_safe starts the mysqld program and overwrites the default behaviors and displays the Specified Services to be started. Mysql_safe reads the configuration information in the configuration file [mysqld], [server], and [msqld_safe.

For more information about the mysqld_safe parameter, see:

Http://dev.mysql.com/doc/refman/5.6/en/mysqld-safe.html

 

In addition, if mariadb installed with yum in centos is configured with a configuration file, there is a pitfall when using service mysql start, and it will be wirelessly clicked.

Here is a detailed description of this situation:

Http://www.oschina.net/question/1261643_149788? Sort = time

4.3.3 mysql. server

Mysql. server is used for mac OS x and is not used for unix like systems. For details, refer:

Http://dev.mysql.com/doc/refman/5.6/en/mysql-server.html

4.3.4 mysqld_multi

Mysqld_multi is used to manage multiple mysqld processes. You can start to close the service or report the current status. Mysqld_multi reads [mysqldN] From the configuration file, and N is a positive number.

Start [mysqld7]:

Shell>Mysqld_multi start 17

Disable [mysqld8], [mysqld10] to [mysqld13]:

shell> mysqld_multi stop 8,10-13

For more information about the parameters of mysqld_multi, see:

Http://dev.mysql.com/doc/refman/5.6/en/mysqld-multi.html

Note the following when using mysqld_multi:

1. Know the meaning of each parameter passed to mysqld before use, and pay attention to the problems that may arise when different mysqld uses the same data folder.

2. Enable mysqld users to access database folders.

3. Ensure that you have the same MYSQL account to disable mysqld and have the SHOUTDOWN permission.

4. Each socket file and port are different.

5. Each mysqld must have its own pid File

6. If it is not started as root, an alarm will be triggered.

For the configuration file examples and details, see:

Http://dev.mysql.com/doc/refman/5.6/en/mysqld-multi.html

4.4 MySQL installation-related Program4.4.1 comp_err

Comp_err compiles the error message file. comp_err generates errmsg. sys during compilation for mysqld to identify the error display. Comp_err also generates mysqld_error.h, mysqld_ername.h, and SQL _state.h.

Details and parameters:

Http://dev.mysql.com/doc/refman/5.6/en/comp-err.html

4.4.2 mysqlbug

Will be killed in mysql5.7. The general method to report a bug is http://bugs.mysql.com /.

4.4.3 mysql_install_db

Mysql_install_db initializes the MySQL DATA folder and creates system data. It also creates a configuration file my. cnf if my. A my-new.cnf is created when a cnf exists (mysql 5.6.19 tests found that the configuration file is produced under/usr/, but mariadb does not generate the configuration file ).

Call method:

Shell>Scripts/mysql_install_db -- user = mysql \

-- Basedir =/opt/mysql \

-- Datadir =/opt/mysql/data

If you want to modify some settings of innodb, you can set the settings above my. cnf, for exampleinnodb_data_file_pathAndinnodb_log_file_size

Mysql_install_db parameters and details:

Http://dev.mysql.com/doc/refman/5.6/en/mysql-install-db.html

4.4.4 mysql_plugin

Mysql_plugin allows mysql to manage which plug-ins to be loaded by mysql. the mysql. plugin table determines which plug-ins to load through mysql_plugin. When the service starts, mysql will load the plug-in mysql. plugin. Of course, you can also specify the plug-in through-plugin_name.