{"id":3737,"date":"2025-05-01T12:00:52","date_gmt":"2025-05-01T11:00:52","guid":{"rendered":"https:\/\/kudzia.eu\/b\/?p=3737"},"modified":"2025-05-31T09:47:04","modified_gmt":"2025-05-31T08:47:04","slug":"putting-manticores-query-log-into-single-lines","status":"publish","type":"post","link":"https:\/\/kudzia.eu\/b\/2025\/05\/putting-manticores-query-log-into-single-lines\/","title":{"rendered":"putting manticore&#8217;s query.log, mysql&#8217;s slow query log into single lines"},"content":{"rendered":"\n<p>sometimes i&#8217;m dealing with large manticore logs where queries include line breaks.<\/p>\n\n\n\n<p>this helps me to get them into form that grep can work with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>cat query.log |tr '\\n' ' '|tr '\\r' ' ' |sed 's\/\\\/*\/\\n\\\/*\/g' |sed 's\/&#91;&#91;:space:]]+\/ \/g' |less<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>for mysql&#8217;s slow query log:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cat mysql-slow.log|awk '\/^#|^SET|^Time|^User|^Host|^Query_time|^Use\/ {if (sql) print sql; print; sql=\"\"; next} {sql = sql ? sql \" \" $0 : $0} END {if (sql) print sql}' |tr -d '\\r'|tr -s ' ' > mysql-slow-single.log<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>sometimes i&#8217;m dealing with large manticore logs where queries include line breaks. this helps me to get them into form that grep can work with: for mysql&#8217;s slow query log:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-3737","post","type-post","status-publish","format-standard","hentry","category-unimportant"],"_links":{"self":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/comments?post=3737"}],"version-history":[{"count":2,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3737\/revisions"}],"predecessor-version":[{"id":3757,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3737\/revisions\/3757"}],"wp:attachment":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/media?parent=3737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/categories?post=3737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/tags?post=3737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}