查看mysql数据库的一些参数

最新推荐文章于 2024-02-29 12:02:13 发布

再看我把你吃掉

最新推荐文章于 2024-02-29 12:02:13 发布

阅读量1k

点赞数

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/zz_aiytag/article/details/107946825

版权

MySQL 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

文章目录

查看时区
查看线程连接数
查看connection
查看超时参数

查看时区

mysql> show variables like '%time_zone';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | GMT    |
| time_zone        | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)

查看线程连接数

mysql> show status like 'Threads%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Threads_cached    | 1     |
| Threads_connected | 2     |
| Threads_created   | 3     |
| Threads_running   | 2     |
+-------------------+-------+
4 rows in set (0.00 sec)

查看connection

mysql> SHOW STATUS LIKE '%Connection%';
+-----------------------------------+---------------------+
| Variable_name                     | Value               |
+-----------------------------------+---------------------+
| Connection_errors_accept          | 0                   |
| Connection_errors_internal        | 0                   |
| Connection_errors_max_connections | 0                   |
| Connection_errors_peer_address    | 45                  |
| Connection_errors_select          | 0                   |
| Connection_errors_tcpwrap         | 0                   |
| Connections                       | 52                  |
| Max_used_connections              | 3                   |
| Max_used_connections_time         | 2020-08-11 23:05:34 |
+-----------------------------------+---------------------+
9 rows in set (0.00 sec)

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)

查看超时参数

mysql> show variables like "%timeout%";
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| have_statement_timeout      | YES      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 50       |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 28800    |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| rpl_stop_slave_timeout      | 31536000 |
| slave_net_timeout           | 60       |
| wait_timeout                | 28800    |
+-----------------------------+----------+
13 rows in set (0.00 sec)