fipar

These are instructions on getting the simple-todo test app from the meteor tutorial (link below) running on a Mac and using TokuMX instead of MongoDB. It was written in response to this request: https://www.percona.com/blog/2015/05/08/mongodb-percona-tokumxse-experimental-build-rc5-available/#comment-10864682

Prerequsites:

• Install meteor (https://www.meteor.com/install)
• Install boot2docker (http://boot2docker.io/, needed because there currently are no OS/X tokumx binaries)
• Optionally, have mongodb installed on the mac, so you can use the client to connect to tokumx on the container (https://www.mongodb.org/downloads)

fipar

Org-mode Org-mode Reference Card

Org mode reference card

Created from the plain text reference card on orgmode.org Download this file, and open it in Emacs org-mode!

fipar

select 'Tcp port: 3306  Unix socket: /tmp/mysql.sock\nTime                 Id Command    Argument' 
union 
select concat(date_format(event_time, '%y%m%d %H:%i:%S'), '    ', thread_id, ' ', command_type, '\t', argument) 
from general_log 
into outfile '/tmp/test' 
fields terminated by '' 

fipar

#!/bin/bash
sysbench \
--test=/usr/share/doc/sysbench/tests/db/insert.lua \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sysbench \
--mysql-password=sysbench \
--mysql-db=sysbench \
--mysql-table-engine=innodb \
--oltp-test-mode=complex \

fipar

fac()
{
    [ $1 -eq 0 ] && echo 1 && return
    seq $1 |tr '\n' '*'|sed 's/*$//g' | bc
}

fipar

# To get from: 
# telecaster:data_collection_scripts fernandoipar$ cat /tmp/test.csv
# 1*1,0,1
# 1*2,0,2
# 2+4,1*1024*1024,2*1024*1024*1024
# to:
# > t
#   V1      V2         V3
# 1  1       0          1
# 2  2       0          2

fipar

for test in oltp update_index update_non_index; do
mkdir $test; pushd $test
for i in 50000 25000 10000 5000 2500 1000
#for i in 10
do
sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_table_engine=tokudb --num-threads=16 --oltp-table-size=${i}000 --rand-type=pareto --rand-init=on --report-interval=10 --mysql-host=sbhost --mysql-db=sbtest --max-time=7200 --max-requests=0 prepare 
sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_table_engine=tokudb --num-threads=16 --oltp-table-size=${i}000 --rand-type=pareto --rand-init=on --report-interval=10 --mysql-host=sbhost --mysql-db=sbtest --max-time=7200 --max-requests=0 run | tee -a toku.${i}.${test}.ssd.txt
sysbench --mysql-engine-trx=yes --test=/usr/share/doc/sysbench/tests/db/oltp.lua --oltp_tables_count=32 --mysql-user=sb --mysql-password=sbs3cret --mysql_ta

fipar

{
  "id": 1,
  "title": "MongoDB",
  "originalTitle": "MongoDB",
  "tags": [],
  "style": "dark",
  "timezone": "browser",
  "editable": true,
  "hideControls": false,
  "sharedCrosshair": false,

fipar

#!/bin/bash

usage()
{
    cat <<EOF>&2
usage: $0 <name>
knits ${name}.Rmd into ${name}.md and ${name}.html
EOF
    exit
}

fipar

test -x pt-diskstats || {
    wget http://www.percona.com/get/pt-diskstats
    chmod +x pt-diskstats
}
reqs=""
which netstat || reqs="netstat $reqs"
which vmstat || reqs="vmstat $reqs"
which top || reqs="top $reqs"
rpm -qa > /tmp/rpms.$$
grep perl-Time-HiRes /tmp/rpms.$$ || reqs="perl-Time-HiRes $reqs"