sql_textがバイナリなのでそのままだと読めないので対処。
SELECT
start_time,
CAST(sql_text AS CHAR(1000) CHARACTER SET utf8),
query_time
FROM
mysql.slow_log
そもそもファイルに出力した方が良いかも。
Go to list of users who liked
More than 1 year has passed since last update.
sql_textがバイナリなのでそのままだと読めないので対処。
SELECT
start_time,
CAST(sql_text AS CHAR(1000) CHARACTER SET utf8),
query_time
FROM
mysql.slow_log
そもそもファイルに出力した方が良いかも。
Register as a new user and use Qiita more conveniently
Go to list of users who liked