MySQL Slow Query Log and MySQL 8.0.19

MySQL Slow Query Log and MySQL 8.0.19

1、需求概述

今天有个客户想访问慢查询日志来寻找查询性能低下的SQL语句,但是他无法访问慢查询日志文件,想从performance_schema中去找,虽然可以找到一些有用的信息,但不如慢查询日志的效率高。所以建议使用慢查询日志表来完成。在调整参数之后,发现sql_text的内容是16进制的,如下:

mysql> select sql_text from mysql.slow_log limit 1; +--------------------------------------------------------------------------------------------------------------------------------------------------------+ | sql_text | +--------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0x73656C656374202A2066726F6D20736274657374312077686572652063206C696B6520272531383532323835363333382D36303732303534383837312D37343337393631323538382527 | +--------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)