6farer

SELECT 
    CONCAT('ALTER TABLE ',
            tbl.TABLE_SCHEMA,
            '.',
            tbl.TABLE_NAME,
            ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;')
FROM
    information_schema.TABLES tbl
WHERE
    tbl.TABLE_SCHEMA = 'DBNAMEGOESHERE*****'

6farer

Keybase proof

I hereby claim:

• I am 6farer on github.
• I am 6farer (https://keybase.io/6farer) on keybase.
• I have a public key whose fingerprint is 03CD 7EC7 0487 7AE7 6220 524E 183A 1EE9 FF31 7E0E

To claim this, I am signing this object:

6farer

#! /bin/bash

NAME=$1
if [ -z $NAME ]; then
  echo "First parameter should be a name for the output files, e.g. devint.company.local"
  exit -1
fi

openssl genrsa -out $NAME.key 2048
openssl req -new -key $NAME.key -out $NAME.csr

6farer

Latency Comparison Numbers
--------------------------
L1 cache reference                            0.5 ns
Branch mispredict                             5   ns
L2 cache reference                            7   ns             14x L1 cache
Mutex lock/unlock                            25   ns
Main memory reference                       100   ns             20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy              3,000   ns
Send 1K bytes over 1 Gbps network        10,000   ns    0.01 ms
Read 4K randomly from SSD*              150,000   ns    0.15 ms

6farer

#!/bin/bash
#####################################################
# Name: Bash CheatSheet for Mac OSX
# 
# A little overlook of the Bash basics
#
# Usage:
#
# Author: J. Le Coupanec
# Date: 2014/11/04

6farer

lib-cov
*.seed
*.log
*.csv
*.dat
*.out
*.pid
*.gz

pids