MySQL Primer--the Usage of Mysqladmin--ping,status,processlist,kill,shutdown

最新推荐文章于 2021-01-21 07:41:01 发布

learn123_net

最新推荐文章于 2021-01-21 07:41:01 发布

阅读量756

点赞数

分类专栏： MySQL Primer 文章标签： myqladmin ping status kill processlist

本文链接：https://blog.csdn.net/piniheaven/article/details/9264559

版权

MySQL Primer 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1.Using mysqladmin
*Checking MySQL server status
    command:
       mysqladmin -p ping;
       mysqladmin -p status;

eg1:

     fish@piniheaven:~$sudo mysqladmin -p ping
     [sudo] password for fish:
     Enter password:
     mysqld is alive

   eg2:
     fish@piniheaven:~$ sudo mysqladmin -p status
     Enter password:
     Uptime: 3272 Threads: 1 Questions: 111 Slow queries: 0 Opens: 175 Flush tables: 1 Open tables: 42 Queries per second avg: 0.033

*find out what connections are active to the MySQL server
     command:
       mysqladmin -p processlist;

eg3:

eg4:

     fish@piniheaven:~$sudo mysqladmin -p kill 46
     Enter password:
     fish@piniheaven:~$ sudo mysqladmin -p processlist
     Enter password:
     +----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+----+---------+------+-------+------------------+
| 52 | root | localhost | | Query | 0 | | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+
    explanation:
       after executing the command,we can see that the connection by id 46 no longer exists:
       At the sametime,when the root user with an id 46 who connected via the MySQL CLI try to do someting,for example:
       SHOW DATABASES;Unfortunately,it didn't work!He would received the following messages:
       ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...

*shoutdown the server
     command:
       mysqladmin -p shutdown