User Tools

Site Tools


mysql_slow_investigation

for i in $(grep '^SET timestamp=' /var/log/mysqllogs/mysqld-slow.log | tail -n20 | cut -d '=' -f 2 | cut -c-10); do date -d @$i; done
Wed Jun  1 06:04:15 UTC 2016
Wed Jun  1 06:04:16 UTC 2016
Wed Jun  1 06:04:16 UTC 2016
Wed Jun  1 06:06:16 UTC 2016
Wed Jun  1 06:06:36 UTC 2016
Wed Jun  1 06:19:41 UTC 2016
Wed Jun  1 06:24:27 UTC 2016
Wed Jun  1 06:34:14 UTC 2016
Wed Jun  1 06:34:16 UTC 2016
Wed Jun  1 06:34:16 UTC 2016
Wed Jun  1 06:42:21 UTC 2016
Wed Jun  1 07:04:10 UTC 2016
Wed Jun  1 07:04:15 UTC 2016
Wed Jun  1 07:04:17 UTC 2016
Wed Jun  1 07:04:17 UTC 2016
Wed Jun  1 07:27:21 UTC 2016
Wed Jun  1 07:34:10 UTC 2016
Wed Jun  1 07:34:11 UTC 2016
Wed Jun  1 07:34:11 UTC 2016
Wed Jun  1 07:35:37 UTC 2016

for i in $(grep '^SET timestamp=' /var/log/mysqllogs/mysqld-slow.log | tail -n200 | cut -d '=' -f 2 | cut -c-10); do date -d @$i; done | cut -c-13 | uniq -c
      3 Tue May 31 06
      2 Tue May 31 07
      3 Tue May 31 08
      5 Tue May 31 09
      2 Tue May 31 10
      3 Tue May 31 11
     14 Tue May 31 12
      4 Tue May 31 13
      3 Tue May 31 14
      3 Tue May 31 19
      1 Tue May 31 21
      3 Tue May 31 22
     38 Wed Jun  1 01    <-----
     68 Wed Jun  1 02    <-----
      7 Wed Jun  1 03
     14 Wed Jun  1 04
      7 Wed Jun  1 05
     11 Wed Jun  1 06
      9 Wed Jun  1 07

mysql_slow_investigation.txt · Last modified: 2024/05/23 07:26 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki