Skip to primary content
Skip to secondary content

ForDoDone

Tales from the Command Line…

ForDoDone

Main menu

  • Home
  • About

Daily Archives: May 15, 2015

hourly distribution of MySQL slow query log

Posted on May 15, 2015 by ForDoDone
Reply
# grep '# Time: ' *slowquery.log | awk '{print $4}' | cut -d : -f1 | sort | uniq -c | sort -nk2
  40 0
     76 1
     18 2
     18 3
     28 4
     64 5
     39 6
    100 7
    168 8
     67 9
    293 10
     40 11
    238 12
    133 13
    199 14
     54 15
     32 16
     22 17
     11 18
    155 19
    110 20
     59 21
     47 22
     62 23
Posted in MySQL, One Liners | Leave a reply
Twitter
Visit Us
Follow Me
Tweet
Instagram
RSS

Recent Posts

  • nginx map simple example
  • gracefully stop php laravel sqs worker in Docker on ECS Fargate
  • awslogs agent running inside Fargate container
  • Connect to MongoDB Atlas Replica Set via SSH Tunnels
  • list contents of all docker volumes

Tags

  • /dev/null
  • apache
  • awk
  • Bash
  • bc
  • column
  • curl
  • cut
  • dd
  • docker
  • docker-compose
  • esxcli
  • eval
  • find
  • forloop
  • git
  • grep
  • mail
  • mount
  • mysql
  • nagios
  • NFS
  • nmap
  • openssl
  • paste
  • ping
  • postfix
  • route
  • RPi
  • rsync
  • sed
  • seq
  • sort
  • ssh
  • ssh-keygen
  • tail
  • tar
  • touch
  • tr
  • uniq
  • unzip
  • vim-cmd
  • wget
  • while
  • zgrep

Categories

  • AWS
  • Bash
  • Continuous Delivery
  • Debian
  • Docker
  • General
  • Linux
  • Miscellaneous
  • MongoDB
  • MySQL
  • NetApp
  • Networking
  • One Liners
  • Puppet
  • Scripts
  • SSL
  • Troubleshooting
  • Ubuntu
  • VMWare
  • Vyatta
  • Windows
May 2015
S M T W T F S
 12
3456789
10111213141516
17181920212223
24252627282930
31  
« Apr   Jul »

Archives

  • October 2019
  • February 2019
  • January 2019
  • March 2018
  • December 2017
  • November 2017
  • September 2017
  • August 2017
  • June 2017
  • April 2017
  • December 2016
  • September 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
Proudly powered by WordPress