mysql
Java般若生
it 老白
展开
-
mysql/mariadb 慢日志错误日志配置
mysql/mariadb 慢日志错误日志配置先查看慢sql是否开启mysql> show variables like “%slow%”;show VARIABLES like ‘%long_query_time%’查询Mysql的进程[root@localhost rc.d]# ps -ef | grep mysqlroot 6096 1 0 17:19 ? 00:00:00 /bin/sh /usr/local/mariadb/bin/mysq原创 2020-07-29 17:42:32 · 1055 阅读 · 0 评论 -
mysql 启动问题,The server quit without updating PID file (/var/run/mysqld/mysqld.pid)
Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid)首先描述下遇到的问题[root@nodes mysql]# systemctl status mysqld.service● mysqld.service - LSB: start and stop MySQL Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendo原创 2020-07-25 10:52:15 · 1355 阅读 · 0 评论 -
mysql查看当前实时连接数
mysql查看当前实时连接数静态查看:SHOW PROCESSLIST; SHOW FULL PROCESSLIST; SHOW VARIABLES LIKE '%max_connections%'; SHOW STATUS LIKE '%Connection%'; 实时查看:mysql> show status like ‘Threads%’;Threads_cached 30Threads_connected 152Threads_created 1736143原创 2020-06-16 14:10:36 · 205 阅读 · 0 评论