MySQL查看运行时间_MySQL
程序员文章站
2022-05-06 10:10:39
...
1、查看MySQL运行多长时间
mysql> SHOW GLOBAL STATUS LIKE 'UPTIME'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Uptime | 12823 | +---------------+-------+ 1 row in set (0.00 sec)2、查看MySQL连接超时
mysql> SHOW GLOBAL VARIABLES LIKE '%TIMEOUT'; +-----------------------------+----------+ | Variable_name | Value | +-----------------------------+----------+ | connect_timeout | 10 | | delayed_insert_timeout | 300 | | 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 | 3600 | | wait_timeout | 28800 | +-----------------------------+----------+ 12 rows in set (0.00 sec)
3、查看mysql请求链接进程被主动杀死
mysql> SHOW GLOBAL STATUS LIKE 'COM_KILL'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Com_kill | 0 | +---------------+-------+ 1 row in set (0.00 sec)
4、查看MySQL通信信息包最大值
mysql> SHOW GLOBAL VARIABLES LIKE 'MAX_ALLOWED_PACKET'; +--------------------+---------+ | Variable_name | Value | +--------------------+---------+ | max_allowed_packet | 4194304 | +--------------------+---------+ 1 row in set (0.00 sec)
上一篇: 制作多边形div
下一篇: C#连接mysql三种方式_MySQL
推荐阅读
-
Java与MySQL时间戳传递/存储/协调问题--userLegacyDatetimeCode--userTimezone--serverTimezone
-
MYSQL替换时间(年月日)字段时分秒不变实例解析
-
关于MySQL的时间进位问题浅析
-
Ubuntu查看修改mysql的登录名和密码、安装phpmyadmin
-
mysql 查看当前使用的配置文件my.cnf的方法(推荐)
-
MySQL能否授予查看存储过程定义权限给用户
-
Mysql的Root密码忘记,查看或修改的解决方法(图文介绍)
-
查看Mysql执行计划
-
MySql 按时间段查询数据方法(实例说明)
-
mysql 时间转换函数的使用方法第1/2页