当前位置:Gxlcms > 数据库问题 > MySQL查看运行时间

MySQL查看运行时间

时间:2021-07-01 10:21:17 帮助过:2人阅读

  1. mysql> SHOW GLOBAL STATUS LIKE ‘UPTIME‘;
  2. +---------------+-------+
  3. | Variable_name | Value |
  4. +---------------+-------+
  5. | Uptime | 12823 |
  6. +---------------+-------+
  7. 1 row in set (0.00 sec)

2、查看MySQL连接超时

  1. mysql> SHOW GLOBAL VARIABLES LIKE ‘%TIMEOUT‘;
  2. +-----------------------------+----------+
  3. | Variable_name | Value |
  4. +-----------------------------+----------+
  5. | connect_timeout | 10 |
  6. | delayed_insert_timeout | 300 |
  7. | innodb_flush_log_at_timeout | 1 |
  8. | innodb_lock_wait_timeout | 50 |
  9. | innodb_rollback_on_timeout | OFF |
  10. | interactive_timeout | 28800 |
  11. | lock_wait_timeout | 31536000 |
  12. | net_read_timeout | 30 |
  13. | net_write_timeout | 60 |
  14. | rpl_stop_slave_timeout | 31536000 |
  15. | slave_net_timeout | 3600 |
  16. | wait_timeout | 28800 |
  17. +-----------------------------+----------+
  18. 12 rows in set (0.00 sec)

3、查看mysql请求链接进程被主动杀死 

  1. mysql> SHOW GLOBAL STATUS LIKE ‘COM_KILL‘;
  2. +---------------+-------+
  3. | Variable_name | Value |
  4. +---------------+-------+
  5. | Com_kill | 0 |
  6. +---------------+-------+
  7. 1 row in set (0.00 sec)


4、查看MySQL通信信息包最大值

  1. mysql> SHOW GLOBAL VARIABLES LIKE ‘MAX_ALLOWED_PACKET‘;
  2. +--------------------+---------+
  3. | Variable_name | Value |
  4. +--------------------+---------+
  5. | max_allowed_packet | 4194304 |
  6. +--------------------+---------+
  7. 1 row in set (0.00 sec)


版权声明:本文为博主原创文章,未经博主允许不得转载。

MySQL查看运行时间

标签:mysql

人气教程排行