Skip to content

Instantly share code, notes, and snippets.

@ylacancellera

ylacancellera/mysql_perf_mutex_sums

Last active January 20, 2022 14:32
Show Gist options
  • Save ylacancellera/c678a7a74d73915b8ebdb607654fb544 to your computer and use it in GitHub Desktop.
Save ylacancellera/c678a7a74d73915b8ebdb607654fb544 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_perf_mutex_sums
pager grep -v "\-\-+\-\-" | grep -v "Type" | sed 's/| InnoDB | //' | sed 's/\s\+|\s\+/\t/g' | sed 's/ |$//' | sed 's/os_waits=/= /' | awk 'BEGIN { FS = "=" } { locks[$1]+=$2 } END { for (l in locks) print l,locks[l] }'
show engine innodb mutex;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment