Config:
- 2 x Intel Xeon(R) CPU E5-2620 v4 @ 2.10GHz (8 cores), 32 vcpus total
- 16GB RAM
- Table rows: 5M
- Number of tables: 16
- Rand-type: uniform
Dataset size:
- InnoDB Uncompressed: 116GB
## Analyze InnoDB status | |
grep -h "lock on" log | cut -d "-" -f2- | sort | uniq -c | sort -nr > lock_on.txt | |
grep -h "Mutex at" log | cut -d "," -f 1 | sort | uniq -c | sort -nr > mutex_at.txt | |
grep -h "has waited at " log | awk '{print $6" "$7" "$8}' | sort | uniq -c | sort -nr > has_waited_at.txt | |
grep -h "Last time write locked " log | sort | uniq -c | sort -nr > last_time_write_locked.txt | |
grep -A 2 "\-\-\-TRANSACTION" log | grep COMMIT | cut -d "," -f 1,2,3 | sort | uniq -c | sort -nr > commit_statements.txt |
#!/usr/bin/env python | |
""" | |
Uses rsync to sync files in parallel between a source and destination. | |
This script has been tested with Python 2.7.4 and 2.6.8; it requires 2.5+. | |
This script has also been tested with rsync versions 3.0.9 and 2.6.8. | |
BASIC USAGE: |
bzr branch lp:percona-server/5.5 percona_server_5.5
bzr tags | grep 5.5.27
bzr branch -r tag:Percona-Server-5.5.27-28.0 lp:percona-server/5.5 percona_server_5.5.27
import requests | |
import hashlib | |
import subprocess | |
import time | |
url = 'http://cachefly.cachefly.net/100mb.test' | |
backup_file = 'backup.out' | |
md5sum_file = 'backup.out.md5' | |
gpg_file = 'backup.out.gpg' |
# update gems | |
sudo gem update --no-rdoc --no-ri | |
# edit client.rb with correct validation key and chef server | |
# also set the environment | |
log_level :info | |
log_location STDOUT | |
chef_server_url "https://api.opscode.com/organizations/modcloth-comments" | |
validation_client_name "modcloth-comments-validator" | |
node_name "comments-standalone-01.demo.modcloth.com" |
#!/bin/bash | |
hyperthreading=$1 | |
if [[ -z $hyperthreading ]]; then | |
echo "Missing argument: Specify 0 to disable hyperthreading and 1 to enable hyperthreading" | |
exit 2 | |
fi | |
# Be careful to not skip the space at the beginning nor the end |
select tables.table_schema | |
, tables.table_name | |
, tables.engine | |
from information_schema.tables | |
left join ( | |
select table_schema | |
, table_name | |
from information_schema.statistics | |
group by table_schema | |
, table_name |
FIELDS = ['cmd', 'command', 'start', 'end', 'delta', 'msg', 'stdout', 'stderr'] | |
def human_log(res): | |
if type(res) == type(dict()): | |
for field in FIELDS: | |
if field in res.keys(): | |
print '\n{0}:\n{1}'.format(field, res[field]) | |
class CallbackModule(object): |