linux 查看mysql运行时间 |操作mysql的界面

使用Linux的命令查看MySQL的运行时间非常简单。下面是一个例子，展示如何使用linux命令查看MySQL的运行时间：

# mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2286
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>status;
--------------
mysql  Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using  EditLine wrapper
Connection id:		2286
Current database:
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.7.21-0ubuntu0.16.04.1 (Ubuntu)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/run/mysqld/mysqld.sock
Uptime:			18 min 14 sec
Threads: 1  Questions: 17  Slow queries: 0  Opens: 145  Flush tables: 1  Open tables: 63  Queries per second avg: 0.015
--------------

上面是一个成功连接到MySQL服务器的样例。其中“Uptime”就是MySQL的运行时间。可以看到，MySQL已运行了18分钟14秒钟。

可以使用更简单的方式来查看MySQL的运行时间。只需要运行以下命令即可：

# mysqladmin -h localhost -u root -p status
Enter password:
Uptime: 5365  Threads: 2  Questions: 179  Slow queries: 0  Opens: 82  Flush tables: 1  Open tables: 76  Queries per second avg: 0.033

上面的命令可以直接打印出MySQL的运行时间。其中“Uptime”依然是MySQL的运行时间。

使用Linux的命令查看MySQL的运行时间非常方便。上面的例子展示了如何使用两种不同的命令来查看MySQL的运行时间。这个功能不仅方便管理员管理和监控数据库，也对开发人员非常有用。