concat效率 mysql_Mysql 优化——分析表读写和sql效率问题

上次我们说到mysql的一些sql查询方面的优化，包括查看explain执行计划，分析索引等等。 今天我们分享一些 分析mysql表读写、索引等等操作的sql语句。

闲话不多说，直接上代码：

-- 反映表的读写压力

SELECT file_name AS file,

count_read,

sum_number_of_bytes_read AS total_read,

count_write,

sum_number_of_bytes_write AS total_written,

(sum_number_of_bytes_read + sum_number_of_bytes_write) AS total

FROM performance_schema.file_summary_by_instance

ORDER BY sum_number_of_bytes_read+ sum_number_of_bytes_write DESC;

-- 反映文件的延迟

SELECT (file_name) AS file,

count_star AS total,

CONCAT(ROUND(sum_timer_wait / 3600000000000000, 2), 'h') AS total_latency,

count_read,

CONCAT(ROUND(sum_timer_read / 1000000000000, 2), 's') AS read_latency,

count_write,

CONCAT(ROUND(sum_timer_write / 3600000000000000, 2), 'h')AS write_latency

FROM p