hourly distribution of MySQL slow query log

# 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

Leave a Reply

Your email address will not be published. Required fields are marked *