We enabled slow_log to debug slow queries. But In slow_log table sql_text column is BLOB.. It used to work fine before on 5.6 but now shows blob on 5.7

(Clarification) When saving the slowlog to a TABLE, what happens to BLOBs and TEXT strings that cannot be safely stored in some standard column? Apparently, TEXT values are stored into a BLOB. In that case, how do I get back the TEXT in the desired CHARACTER SET?

  • Writing the slow log to FILE? Or TABLE? – Rick James Apr 2 '17 at 2:06
  • slow_log table.. – Deepak Apr 2 '17 at 5:26

In 5.7 ; column sql_text is changed to BLOB... Hence, you need to use select CONVERT(sql_text USING utf8 ) from mysql.slow_log ;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.