Skip to content

Instantly share code, notes, and snippets.

@sejima
Created February 18, 2016 14:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sejima/1cebbf8a4948b7d37033 to your computer and use it in GitHub Desktop.
Save sejima/1cebbf8a4948b7d37033 to your computer and use it in GitHub Desktop.
$ egrep 'Last time.*locked' sbtest_zip.txt | sort | uniq -c
1 Last time read locked in file btr0cur.cc line 3592
1 Last time read locked in file btr0cur.cc line 3702
3 Last time read locked in file btr0cur.cc line 3720
78459 Last time read locked in file btr0cur.cc line 545
27 Last time read locked in file btr0cur.cc line 822
2 Last time read locked in file btr0sea.cc line 1094
1 Last time read locked in file btr0sea.cc line 1331
18 Last time read locked in file btr0sea.cc line 907
2 Last time read locked in file buf0flu.cc line 1056
1 Last time read locked in file row0sel.cc line 3220
12 Last time read locked in file row0sel.cc line 3926
1 Last time read locked in file row0sel.cc line 4138
5 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0cur.cc line 269
1 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0cur.cc line 292
78459 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0cur.cc line 536
29 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0sea.cc line 1193
7 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0sea.cc line 1445
1 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0sea.cc line 1604
23 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/btr/btr0sea.cc line 658
2 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/ibuf/ibuf0ibuf.cc line 1078
1 Last time write locked in file /export/home/pb2/build/sb_0-17068951-1447697721.44/mysql-5.6.28/storage/innobase/row/row0upd.cc line 2354
$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment