Oneliners - Revision history

Jan at 19:27, 26 August 2016

2016-08-26T19:27:01Z

← Older revision		Revision as of 21:27, 26 August 2016
Line 8:		Line 8:
	Get the size of the a folder and it's subdirectories, sorted by size:		Get the size of the a folder and it's subdirectories, sorted by size:
	<pre>		<pre>
	du --max-depth=1 ~~-k /path/to/folder~~ \| sort -~~nr \| cut -f2 \| xargs -d '\n' du -sh~~		du -hx --max-depth=1 \| sort -h
	</pre>		</pre>
			(removed the convoluted old command, this is much simpler)

	=== Postfix ===		=== Postfix ===

Jan: 2 revisions imported

2016-08-26T19:10:43Z

2 revisions imported

← Older revision

Revision as of 21:10, 26 August 2016

Jan: 1 revision imported

2016-08-26T19:09:41Z

1 revision imported

← Older revision

Revision as of 21:09, 26 August 2016

Jan at 10:53, 18 November 2013

2013-11-18T10:53:50Z

← Older revision		Revision as of 12:53, 18 November 2013
Line 9:		Line 9:
	<pre>		<pre>
	du --max-depth=1 -k /path/to/folder \| sort -nr \| cut -f2 \| xargs -d '\n' du -sh		du --max-depth=1 -k /path/to/folder \| sort -nr \| cut -f2 \| xargs -d '\n' du -sh
			</pre>

			=== Postfix ===
			Mass-Delete from mailqueue by sender address
			<pre>
			mailq \| awk ' /^[0-9A-F][0-9A-F].user@example.com$/ {print $1}' \| xargs -rn1 postsuper -d
	</pre>		</pre>

Jan at 13:33, 8 November 2013

2013-11-08T13:33:31Z

← Older revision		Revision as of 15:33, 8 November 2013
Line 3:		Line 3:
	<pre>		<pre>
	echo "scale=4; 100-`mysql -NB -e "SHOW STATUS LIKE 'Threads_created'; SHOW STATUS LIKE 'Connections';" \| awk '{print $2}' \| tr '\n' '/'`100" \| bc		echo "scale=4; 100-`mysql -NB -e "SHOW STATUS LIKE 'Threads_created'; SHOW STATUS LIKE 'Connections';" \| awk '{print $2}' \| tr '\n' '/'`100" \| bc
			</pre>

			=== Filesystem ===
			Get the size of the a folder and it's subdirectories, sorted by size:
			<pre>
			du --max-depth=1 -k /path/to/folder \| sort -nr \| cut -f2 \| xargs -d '\n' du -sh
	</pre>		</pre>

Jan: 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): <..."

2013-11-08T13:29:56Z

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): <..."

New page

=== 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):
<pre>
echo "scale=4; 100-`mysql -NB -e "SHOW STATUS LIKE 'Threads_created'; SHOW STATUS LIKE 'Connections';" | awk '{print $2}' | tr '\n' '/'`100" | bc
</pre>