Oneliners

From fakedWiki
Revision as of 14:29, 8 November 2013 by Jan (talk | contribs) (Created page with "=== MySQL === Get the "hit rate" percentage of Connections vs. Threads_created, helps you with finding the sweet spot for thread_cache_size (the closer to 100%, the better): <...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

MySQL

Get the "hit rate" percentage of Connections vs. Threads_created, helps you with finding the sweet spot for thread_cache_size (the closer to 100%, the better): 

echo "scale=4; 100-`mysql -NB -e "SHOW STATUS LIKE 'Threads_created'; SHOW STATUS LIKE 'Connections';" | awk '{print $2}' | tr '\n' '/'`100" | bc
Retrieved from "https://wiki.faked.org/index.php?title=Oneliners&oldid=245"