tail -10000 mysql-slow.log |awk -F'SET timestamp=' 'NF > 1{ system("date -d @" $2) }{print $_}' > foo.log
That will insert a line before the "SET timestamp=" line of the actual date for the query.
Convert mysql timestamp to human readable date
That will insert a line before the "SET timestamp=" line of the actual date for the query.
- Post a new comment
- 0 comments
- Post a new comment
- 0 comments
