常用命令之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