Aleksey Kazakov Dezinger

## minipc.txt
https://portal.eaeunion.org/sites/odata/_layouts/15/Portal.EEC.Registry.UI/DisplayForm.aspx?ItemId=61156&ListId=d84d16d7-2cc9-4cff-a13b-530f96889dbc

## chef-noatime-and-swap.rb
# Enable noatime on local ext3/4 & xfs filesystems

fstab = File.open('/etc/fstab',"r")
newlines = Array.new
needremount = Array.new
ihaveswap = false
fstab.each do |line|
  # Tokenize each fstab line with a space separator
  tokens = line.split
  if tokens[2] == "swap"

## composer_gzip_test.php
<?php

$retries = 0;

function fetch() {
    global $retries;

    echo "Retry " . $retries . " | ";

    $opts = array(

## Postresql_Statistic.sql
-- Запросы по сбору статистики PostgreSql 9.3.x

-- Процессы которые висят более 20 секунд
select * from pg_stat_activity where state != 'idle' and current_timestamp - query_start > '20 sec';

-- К-во update-тов за время с последнего сброса статистики
SELECT relname, n_tup_ins + n_tup_upd + n_tup_del from pg_stat_user_tables order by 2 desc limit 5;

-- Сброс статистики
SELECT pg_stat_reset();

## mcached.shell
telnet localhost 11211

Command 	Description 	Example
get 	Reads a value 	get mykey
set 	Set a key unconditionally 	set mykey 0 60 5
add 	Add a new key 	add newkey 0 60 5
replace 	Overwrite existing key 	replace key 0 60 5
append 	Append data to existing key 	append key 0 60 15
prepend 	Prepend data to existing key 	prepend key 0 60 15
incr 	Increments numerical key value by given number 	incr mykey 2

## post-receive
mkdir ~/git/website.git && ~/git/cd website.git
git init --bare

mkdir ~/webapps/website
git config core.bare false
git config core.worktree /home/rafi/webapps/website      ; NO TRAILING SLASH!!! Will screw up things real bad.
git config receive.denycurrentbranch ignore
; create a hook
cat > hooks/post-receive
#!/bin/sh

## random-func-postgresql.sql
CREATE OR REPLACE FUNCTION random(numeric, numeric)
RETURNS numeric AS
$$
   SELECT ($1 + ($2 - $1) * random())::numeric;
$$ LANGUAGE 'sql' VOLATILE;


SELECT random(1,10)::int, random(1,10);

## create-table-adn-fill-1m-recs.sql
CREATE TABLE foo (c1 integer, c2 text);
INSERT INTO foo
  SELECT i, md5(random()::text)
  FROM generate_series(1, 1000000) AS i;

## pkg-expander.shell
pkgutil --expand MAMP_2.1.1.pkg /tmp/test/mamp211/

## lib-ver.shell
otool -L /usr/lib/libssl.0.9.7.dylib
	# Enable noatime on local ext3/4 & xfs filesystems

	fstab = File.open('/etc/fstab',"r")
	newlines = Array.new
	needremount = Array.new
	ihaveswap = false
	fstab.each do \|line\|
	# Tokenize each fstab line with a space separator
	tokens = line.split
	if tokens[2] == "swap"
	<?php

	$retries = 0;

	function fetch() {
	global $retries;

	echo "Retry " . $retries . " \| ";

	$opts = array(
	-- Запросы по сбору статистики PostgreSql 9.3.x

	-- Процессы которые висят более 20 секунд
	select * from pg_stat_activity where state != 'idle' and current_timestamp - query_start > '20 sec';

	-- К-во update-тов за время с последнего сброса статистики
	SELECT relname, n_tup_ins + n_tup_upd + n_tup_del from pg_stat_user_tables order by 2 desc limit 5;

	-- Сброс статистики
	SELECT pg_stat_reset();
	telnet localhost 11211

	Command Description Example
	get Reads a value get mykey
	set Set a key unconditionally set mykey 0 60 5
	add Add a new key add newkey 0 60 5
	replace Overwrite existing key replace key 0 60 5
	append Append data to existing key append key 0 60 15
	prepend Prepend data to existing key prepend key 0 60 15
	incr Increments numerical key value by given number incr mykey 2
	mkdir ~/git/website.git && ~/git/cd website.git
	git init --bare

	mkdir ~/webapps/website
	git config core.bare false
	git config core.worktree /home/rafi/webapps/website ; NO TRAILING SLASH!!! Will screw up things real bad.
	git config receive.denycurrentbranch ignore
	; create a hook
	cat > hooks/post-receive
	#!/bin/sh
	CREATE OR REPLACE FUNCTION random(numeric, numeric)
	RETURNS numeric AS
	$$
	SELECT ($1 + ($2 - $1) * random())::numeric;
	$$ LANGUAGE 'sql' VOLATILE;


	SELECT random(1,10)::int, random(1,10);
	CREATE TABLE foo (c1 integer, c2 text);
	INSERT INTO foo
	SELECT i, md5(random()::text)
	FROM generate_series(1, 1000000) AS i;