dotmanila

#!/bin/bash 

USER=ubuntu
IP=$(ip -4 ad sh scope global | grep 'scope global' | awk '{print $2}' | cut -d'/' -f1 | head -n1)
KERNEL=$(uname -r)

wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_0.1-4.xenial_all.deb
sudo apt -y update
sudo apt -y upgrade

dotmanila

#!/bin/bash 

DISK=xvdb
USER=ubuntu
IP=$(ip -4 ad sh scope global | grep 'scope global' | awk '{print $2}' | cut -d'/' -f1 | head -n1)
KERNEL=$(uname -r)

wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_0.1-4.xenial_all.deb
sudo apt -y update

dotmanila

# Percona Toolkit System Summary Report ######################
    Platform | Linux
     Release | Ubuntu 16.04.3 LTS (xenial)
      Kernel | 4.4.0-98-generic
Architecture | CPU = 64-bit, OS = 64-bit
   Threading | NPTL 2.23
     SELinux | No SELinux detected
 Virtualized | No virtualization detected
# Processor ##################################################
  Processors | physical = 2, cores = 12, virtual = 24, hyperthreading = yes

dotmanila

#!/bin/bash

PREFIX=$1

time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
    --mysql-db=test --mysql-host=127.0.0.1 --mysql-port=57190 --tables=8 \
    --table-size=20000000 --auto-inc=off --threads=8 --time=0 \
    --rand-type=pareto oltp_read_only cleanup

time sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \

dotmanila

dbuf_cache_hiwater_pct                                          10
dbuf_cache_lowater_pct                                          10
dbuf_cache_max_bytes                                     104857600
dbuf_cache_max_shift                                             5
dmu_object_alloc_chunk_shift                                     7
ignore_hole_birth                                                1
l2arc_feed_again                                                 1 1
l2arc_feed_min_ms                                              200 200
l2arc_feed_secs                                                  1 1
l2arc_headroom                                                   2 2

dotmanila

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import json
import sys
import pymysql.cursors

from pymysqlreplication import BinLogStreamReader
from pymysqlreplication.row_event import (
    DeleteRowsEvent,

dotmanila

#!/bin/bash

_echo() {
   echo "$(date +%Y-%m-%d_%H_%M_%S) incr-refresh $1"
}

TBL='hits'
# MySQL clickhouse_changelog command
MYCL="mysql -h source_db_host mydb -BNe"
# MySQL source table command

dotmanila

#!/bin/bash

# File should have first column as numeric
FILE=$1

cat $FILE | sort -rn > $FILE.sort
cat $FILE.sort | awk 'NR%2==0' > $FILE.1
cat $FILE.sort | awk 'NR%2==1' > $FILE.2
rm -rf $FILE.sort

dotmanila

Keybase proof

I hereby claim:

• I am dotmanila on github.
• I am revin (https://keybase.io/revin) on keybase.
• I have a public key ASC8Pyeju_P3M6mAtkHvr-iB048ggm73oKYWbrRIKxIq6Qo

To claim this, I am signing this object:

dotmanila

#!/bin/sh
xsetroot -solid grey
export XKL_XMODMAP_DISABLE=1
#autocutsel -fork
openbox &
/usr/bin/lxsession -s Lubuntu &