Kai Weber kwbr

## sort.vim
function! Sort(type, ...)
    '[,']sort
endfunction
nmap <silent> <key> :set opfunc=Sort<CR>g@

" usage:
" <key>ip
" <key>G

## pt-stalk dissection with bash
# Many of these are obvious and stupidly simple, but for your reference and copy-pasting pleasure…


# Mextify all (with workaround for pesky samples that contain multi-line RSA key that breaks pt-mext)
for i in $(ls $1/*-mysqladmin); do { (cat $i | sed -e '/\-\-\-\-\-BEGIN\ PUBLIC\ KEY/,+9d' | pt-mext -r -- cat -) > $i.mext && echo $i.mext;} done;

# Inspect given variable through multiple mext samples (revealing ;-))
grep Table_locks_waited *.mext |less -S

#Find contentious tables

## restic.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                kwbr
                / restic.md
            
            
              Created
              May 2, 2019 12:18
                — forked from rolfn/restic.md
            
              
                Backup auf Cloud-Speicher mit »restic«
              
          
    Backup auf Cloud-Speicher mit »restic«

Das Programm »restic« ist ein modernes Backup-Programm,
welches als Ziel lokal gemountete Verzeichnisse verwenden kann. Darüber hinaus
unterstützt es einige ausgewählte Protokolle, um direkt auf Cloud-Speicher
zugreifen zu können (SFTP, S3, OpenStack Swift, Google Cloud Storage u.a.). Im
Folgenden soll gezeigt werden, wie man unter Linux automatische Backups
konfigurieren kann. Als Ziel wird in diesem Beispiel der S3-kompatible »Object
Storage Service« (TelekomCLOUD) benutzt. Sinngemäß lassen sich die folgenden
Angaben auch auf andere Backup-Ziele (z.B. NFS-Mounts) anwenden. Getestet wurde

  
## g1_log_parser.sh
#!/usr/bin/env awk -f

# Based on the idea from https://blogs.oracle.com/taylor22/entry/using_r_to_analyze_g1gc, the
# script is updated to use the format of the gc logs as received with the parameters:
# -XX:+UseThreadPriorities
# -XX:ThreadPriorityPolicy=42
# -Xms1995M -Xmx1995M
# -Xss256k -XX:StringTableSize=1000003
# -XX:SurvivorRatio=8
# -XX:MaxTenuringThreshold=1

## make-load.sh
#!/usr/bin/env bash

if [ -z "$1" ]; then
   echo "Usage: $0 <iterations>"
   exit 1
fi

# Display product ID, category, title, price, num orders
# ordered by top products limit 10
function top_products(){

## producer_consumer.pl
#!/usr/bin/perl

use strict;
use warnings FATAL => 'all';

use DBI;
use English qw(-no_match_vars);
use Getopt::Long;
use List::Util qw(max);

## xtrabackup_full_increment_restore.sh
#!/bin/bash
# This is my production backup script.
# https://sqlgossip.com

set -e
set -u

usage() {
        echo "usage: $(basename $0) [option]"
        echo "option=full: Perform Full Backup"

## Vagrantfile
Vagrant.configure("2") do |config|
    config.vm.box = "debian/stretch64"
    config.vm.provision "ansible" do |ansible|
        ansible.compatibility_mode = "2.0"
        ansible.playbook = "play.yml"
    end
end

## deploy.sh
#!/bin/bash

set -e

export AWS_REGION="eu-west-1"
export COMMIT_ID=$1

# Docker Hub account with read-only access to the repository
export DOCKER_HUB_USERNAME="[FILL ME IN]"
export DOCKER_HUB_PASSWORD="[FILL ME IN]"

## gist:5232698
#!/bin/bash

# atlassian-heap-dump.sh - dump a heap using GDB for a crashed application
# Accepts a single argument: the PID of the JVM
# Author: James Gray (jgray@atlassian.com)
# Copyright Atlassian P/L
# License: MIT

# Are we root?
if [ $UID -ne 0 ]; then
	function! Sort(type, ...)
	'[,']sort
	endfunction
	nmap <silent> <key> :set opfunc=Sort<CR>g@

	" usage:
	" <key>ip
	" <key>G
	# Many of these are obvious and stupidly simple, but for your reference and copy-pasting pleasure…


	# Mextify all (with workaround for pesky samples that contain multi-line RSA key that breaks pt-mext)
	for i in $(ls $1/*-mysqladmin); do { (cat $i \| sed -e '/\-\-\-\-\-BEGIN\ PUBLIC\ KEY/,+9d' \| pt-mext -r -- cat -) > $i.mext && echo $i.mext;} done;

	# Inspect given variable through multiple mext samples (revealing ;-))
	grep Table_locks_waited *.mext \|less -S

	#Find contentious tables
	#!/usr/bin/env awk -f

	# Based on the idea from https://blogs.oracle.com/taylor22/entry/using_r_to_analyze_g1gc, the
	# script is updated to use the format of the gc logs as received with the parameters:
	# -XX:+UseThreadPriorities
	# -XX:ThreadPriorityPolicy=42
	# -Xms1995M -Xmx1995M
	# -Xss256k -XX:StringTableSize=1000003
	# -XX:SurvivorRatio=8
	# -XX:MaxTenuringThreshold=1
	#!/usr/bin/env bash

	if [ -z "$1" ]; then
	echo "Usage: $0 <iterations>"
	exit 1
	fi

	# Display product ID, category, title, price, num orders
	# ordered by top products limit 10
	function top_products(){
	#!/usr/bin/perl

	use strict;
	use warnings FATAL => 'all';

	use DBI;
	use English qw(-no_match_vars);
	use Getopt::Long;
	use List::Util qw(max);
	#!/bin/bash
	# This is my production backup script.
	# https://sqlgossip.com

	set -e
	set -u

	usage() {
	echo "usage: $(basename $0) [option]"
	echo "option=full: Perform Full Backup"
	Vagrant.configure("2") do \|config\|
	config.vm.box = "debian/stretch64"
	config.vm.provision "ansible" do \|ansible\|
	ansible.compatibility_mode = "2.0"
	ansible.playbook = "play.yml"
	end
	end
	#!/bin/bash

	set -e

	export AWS_REGION="eu-west-1"
	export COMMIT_ID=$1

	# Docker Hub account with read-only access to the repository
	export DOCKER_HUB_USERNAME="[FILL ME IN]"
	export DOCKER_HUB_PASSWORD="[FILL ME IN]"
	#!/bin/bash

	# atlassian-heap-dump.sh - dump a heap using GDB for a crashed application
	# Accepts a single argument: the PID of the JVM
	# Author: James Gray (jgray@atlassian.com)
	# Copyright Atlassian P/L
	# License: MIT

	# Are we root?
	if [ $UID -ne 0 ]; then