随笔分类 -  mysql

mysql数据库相关
mysql启动失败“MySQL Daemon failed to start”
摘要：CentOS上，用命令：service mysqld restart 启动mysql报错： # service mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED] 阅读全文
posted @ 2019-06-10 20:29 溟漓 阅读(7305) 评论(0) 推荐(0)
mysql计算QPS
摘要：首先连接上mysql： $ mysql -h 192.168.0.x -P3306 -uusername -p123456 进入Mysql之后，查询general_log： mysql> SHOW VARIABLES LIKE "general_log%"; + + + | Variable_nam 阅读全文
posted @ 2019-05-30 16:36 溟漓 阅读(3922) 评论(0) 推荐(0)