Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use mysqladmin to manage mysql", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let Xiaobian take you to learn "how to use mysqladmin to manage mysql"!

mysqladmin is a dedicated management tool in mysql database, through which you can check server configuration, current status, create/delete database and other operations.

Usage:

Usage: mysqladmin [OPTIONS] command command....

Common parameters:

● -i, --sleep=#: The interval between repeated execution of the command.

● -r, --relative: When used in conjunction with the-i parameter and the extended-status command is specified, the difference between the current and previous status values is displayed.

Common commands:

● create databasename: Create a database

● drop databasename: delete database

Extended-status: View server status information, the same function as executing show global status in mysql command line mode.

Flush-logs: Refresh logs.

Flush-status: Reset status variables.

Flush-tables: Refresh all tables.

Flush-threads: Flushes thread cache.

flush-privileges: Reloads authorization tables, which is exactly the same as the reload command.

Refresh: Refresh all tables, please switch log files.

password [new-password]: modifies the password of the specified user, the function is exactly the same as the set password statement.

Ping: Check whether the current MySQL service can still provide services normally by means of ping.

● kill id、id、...：Kill threads connected to mysql server, exactly the same function as kill id statement.

processlist: View all connection thread information of the current mysql service. The function is exactly the same as the show processlist statement. Often used.

shutdown: Shutdown the database. Often used.

● status: View the current status of mysql, displaying only the last line of status command in mysql command line mode.

start-slave: Start slave service, exactly the same function as start slave statement.

stop-slave: Stop slave service, exactly the same function as stop slave statement.

● variables: Display system variables, the function is exactly the same as the show global variables statement.

version: View version information, including status command information.

Examples of usage:

(1) Creating and deleting databases

[root@oeldb1 ~]# mysqladmin -uroot -p123456 create test1

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

[root@oeldb1 ~]# mysqladmin -uroot -p123456 drop test1;

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

Dropping the database is potentially a very bad thing to do.

Any data stored in the database will be destroyed.

Do you really want to drop the 'test1' database [y/N] y

Database "test1" dropped

(2) View status information

[root@oeldb1 ~]# mysqladmin -uroot -p123456 status

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

Uptime: 952 Threads: 2 Questions: 12 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.012

Of which:

Uptime: The startup time of the mysql service.

Threads: Number of currently connected sessions.

Questions: Number of query statements executed since mysql service started.

Slow queries: Number of slow queries.

Opens: The number of table objects currently open.

Flush tables: Number of flush-*, refresh, and reload commands executed.

Open tables: The number of table objects open in the current session.

Queries per second avg: How often queries are executed.

Detailed status information:

[root@oeldb1 ~]# mysqladmin -uroot -p123456 extended-status | grep -i max

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

| Connection_errors_max_connections | 0 |

| Innodb_row_lock_time_max | 0 |

| Max_execution_time_exceeded | 0 |

| Max_execution_time_set | 0 |

| Max_execution_time_set_failed | 0 |

| Max_used_connections | 1 |

| Max_used_connections_time | 2017-06-25 21:22:48 |

| Tc_log_max_pages_used | 0 |

(3) Check whether mysq service is alive

[root@oeldb1 ~]# mysqladmin -uroot -p123456 ping

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

mysqld is alive

(4) Output the status information of the current mysql service every second:

[root@oeldb1 ~]# mysqladmin -uroot -p123456 -i 1 status

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

Uptime: 1069 Threads: 2 Questions: 14 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.013

Uptime: 1070 Threads: 2 Questions: 15 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.014

Uptime: 1071 Threads: 2 Questions: 16 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.014

Uptime: 1072 Threads: 2 Questions: 17 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.015

Uptime: 1073 Threads: 2 Questions: 18 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.016

Uptime: 1074 Threads: 2 Questions: 19 Slow queries: 0 Opens: 109 Flush tables: 1 Open tables: 102 Queries per second avg: 0.017

(5) Number of queries executed per second:

[root@oeldb1 ~]# mysqladmin -uroot -p123456 -i 1 -r extended-status | grep -e "Com_select"

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

| Com_select | 0 |

| Com_select | 0 |

| Com_select | 0 |

| Com_select | 0 |

| Com_select | 0 |

At this point, I believe everyone has a deeper understanding of "how to use mysqladmin to manage mysql," so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.