I'm seeing queries in my MySQL slow query log that have the character "N" instead of a specific value. Can I change that? I need in logs the real value with witch the query was executed.
I'm using MySQL 5.5.32.
show variables like "%log%"
expire_logs_days | 10
Are you using mysqldumpslow to read your slow query log?
mysqldumpslow converts all numbers to N and all strings to 'S'. It also normalises the case of all queries, any whitespace and any quoting before aggregating all similar queries together.
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
2 years ago