常用命令之mysql

 

mysql数据库连接数 相关的操作

show full processlist;
SHOW PROCESSLIST;
SHOW FULL PROCESSLIST;
SHOW VARIABLES LIKE '%max_connections%';
SHOW STATUS LIKE '%Connection%';
show status like 'Threads%';
show variables like '%max_connections%';
show global status like 'Thread%';
show status like '%Connections%';

 

 

时间相关

查询当天的数据

select * from table_name
where 1=1
and to_days(createDate)=to_days(now())
limit 1

posted @ 2020-08-13 22:03  ~~~~~~~~~~~~~  阅读(61)  评论(0)  编辑  收藏  举报