# Analyze all but INSERTS from mysql’s general log
\ngrep -E ‘^.*[0-9]{1,}\\sQuery’ \/your-path\/to\/file.log | awk ‘{$1=$2=””; print toupper($0)}’ | sed ‘s\/\\s+\/ \/g’ | grep -Ev “^\\s*INSERT” | sed -r ‘s\/^(.*)(\\sSET\\s).*(\\sWHERE.*)\/\\1\\3\/g’ | sed -r ‘s\/^(.*SELECT).*(\\sFROM)(\\s.*)\/\\1\\3\/g’ | sed “s\/’\/\/g” | sed -r ‘s\/=\\s\\w+\/ \/g’ | sort | uniq -c<\/p>\n
# Change ls result and execute it.
\nls -1 | grep -v “bz2” | xargs -n 1 -I'{}’ echo mv “{}” \/dockers_persistent\/binlog\/mms_av_1\/<\/p>\n
# Change df result, replace some character and execute it as a parameter in the middle of the instruction.
\n# get some volumes, umount, repair and mount’em. <\/p>\n
\r\ndocker_name=mysql_server_1\r\ndf -h | grep $docker_name | awk '{print \"umount \" $6 \" && xfs_repair -t 15 \" $1 \" > .\/\" gensub(\"\/\", \"-\", \"g\",$1) \" 2> .\/\" gensub(\"\/\", \"-\", \"g\",$1) \".err && mount \" $6 \" &\"}'\r\n<\/pre>\n\r\n# Observe CPU frequency\r\nwatch \"cat \/proc\/cpuinfo | grep MHz | awk -F\":\" '{print $2'} | sort -n | uniq -c \"\r\n<\/pre>\n\r\n# Change devices from mapper into uuid\r\ngrep \"\/dev\/mapper\/[a-z\\-]\\{1,\\}\\s\" -o \/tmp\/fstab | while read line ; do blkid -s UUID \"$line\" | sed 's\/\"\/\\\\\"\/g' | eval$(awk -F\": \" '{print \" sed -i \\\"s#\"$1\"#\"$2\"#\\\" \/tmp\/fstab2\" }'); done\r\n<\/pre>\n\r\n# get all config lines but commented\r\ngrep -v \"^#\\|^$\" .\/106\/etc\/elasticsearch\/elasticsearch.yml\r\n<\/pre>\n\r\n# reroute all shards from one node into another.\r\ncurl -XGET 'http:\/\/localhost:9200\/_cat\/shards?v' -s | grep \"NODE_NAME\\s*$\" | awk -v NEW_NODE=\"es00.6\" ' {print \"{\\\"commands\\\":[{ \\\"move\\\": {\\\"index\\\":\\\"\"$1\"\\\",\\\"shard\\\": \"$2\",\\\"from_node\\\": \\\"\"$8\"\\\",\\\"to_node\\\":\\\"\"NEW_NODE\"\\\" }}]}\" }' | sed \"s\/^\\|$\/'\/g\" | xargs curl -XPOST \"http:\/\/localhost:9201\/_cluster\/reroute\" -d \r\n<\/pre>\n\r\n# get plugins whithin whole cluster\r\ncurl -XGET 'http:\/\/localhost:9200\/_nodes\/*\/_all' | jq-linux64 .nodes | jq-linux64 '.[] | [ .version ], [.settings.name], {plugins}'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"# Analyze all but INSERTS from mysql’s general log grep -E ‘^.*[0-9]{1,}\\sQuery’ \/your-path\/to\/file.log | awk ‘{$1=$2=””; print toupper($0)}’ | sed ‘s\/\\s+\/ \/g’ | grep -Ev “^\\s*INSERT” | sed -r ‘s\/^(.*)(\\sSET\\s).*(\\sWHERE.*)\/\\1\\3\/g’ | sed -r ‘s\/^(.*SELECT).*(\\sFROM)(\\s.*)\/\\1\\3\/g’ | sed “s\/’\/\/g” | sed -r ‘s\/=\\s\\w+\/ \/g’ | sort | uniq -c # Change ls result and execute it. ls […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1121"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1121"}],"version-history":[{"count":16,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions"}],"predecessor-version":[{"id":1259,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions\/1259"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}