Skip to content

Instantly share code, notes, and snippets.

@ylacancellera

ylacancellera/mysql_perf_mutex_splits

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