MySQL SQL语句性能分析
来源:互联网 发布:网络聊天室代码 编辑:程序博客网 时间:2024/05/18 10:27
set profiling = 1;
select * from g_staff;
show profiles
SHOW profile CPU,BLOCK IO FOR query 88;
select * from g_staff;
show profiles
SHOW profile CPU,BLOCK IO FOR query 88;
select * from NFORMATION_SCHEMA.PROFILING
将 MySQL’s SHOW PROFILES 命令的结果转成适合阅读的格式
SET @query_id := 5;
SELECT
STATE,
SUM(DURATION) AS Total_R,
ROUND(
100 * SUM(DURATION) / (
SELECT
SUM(DURATION)
FROM
INFORMATION_SCHEMA.PROFILING
WHERE
QUERY_ID = @query_id
),
2
) AS Pct_R,
COUNT(*) AS Calls,
SUM(DURATION) / COUNT(*) AS "R/Call"
FROM
INFORMATION_SCHEMA.PROFILING
WHERE
QUERY_ID = @query_id
GROUP BY
STATE
ORDER BY
Total_R DESC;
SELECT
STATE,
SUM(DURATION) AS Total_R,
ROUND(
100 * SUM(DURATION) / (
SELECT
SUM(DURATION)
FROM
INFORMATION_SCHEMA.PROFILING
WHERE
QUERY_ID = @query_id
),
2
) AS Pct_R,
COUNT(*) AS Calls,
SUM(DURATION) / COUNT(*) AS "R/Call"
FROM
INFORMATION_SCHEMA.PROFILING
WHERE
QUERY_ID = @query_id
GROUP BY
STATE
ORDER BY
Total_R DESC;
- MySQL SQL语句性能分析
- mysql sql语句性能分析
- MYSQL sql 语句性能分析
- mysql使用Profiling分析query语句,sql语句性能优化
- mysql语句性能分析
- Mysql中两个有用的sql性能分析语句
- SQL语句LIMIT在MySQL中的性能分析
- MySQL SQL性能分析
- 分析SQL语句的性能
- Oracle分析Sql语句性能
- MySql优化sql语句性能
- MySQL 检测sql语句性能
- MySql sql性能瓶颈分析
- Explain分析sql语句的性能
- 分析SQL语句性能3种方法
- SQL 查询语句性能对比分析
- 利用EXPLAIN分析sql语句的性能
- 【MySql性能优化二】利用explain进行查询和分析sql语句
- MySQL数据库备份
- 关闭chrome 的内置PDF 查看器
- 查看运行时间函数--比较运行速度
- Mysql Dump
- spring mvc系列文章 - Spring MVC国际化配置
- MySQL SQL语句性能分析
- MySQL Server系统架构
- MFC----文件拖拽的实现OnDropFiles
- oracle数据库迁移到GBase(南大通用)笔记
- struts2获取各种表单的数据小实例
- 通过创建MapFile来定位程序崩溃地址
- HDU——4349(数论)
- MySQL 的权限系统
- 【Android】ListView与Button的共存问题解决