Skip to content

Instantly share code, notes, and snippets.

View vadimtk's full-sized avatar

Vadim Tkachenko vadimtk

89 followers · 0 following
  • Percona
View GitHub Profile
@vadimtk
vadimtk / gist:5481807
Created April 29, 2013 14:13
#!/usr/bin/env bash
export CC=/opt/centos/devtoolset-1.1/root/usr/bin/gcc
export CPP=/opt/centos/devtoolset-1.1/root/usr/bin/cpp
export CXX=/opt/centos/devtoolset-1.1/root/usr/bin/c++
export LD=/opt/centos/devtoolset-1.1/root/usr/bin/ld
set -x
shopt -s compat31 2> /dev/null
@vadimtk
vadimtk / Percona Server 5.6 config
Created October 7, 2013 23:10
Config for Percona Server 5.6 benchmark
[mysqld]
server-id=20
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_files_in_group=2
innodb_log_file_size=2G
innodb_buffer_pool_size=25GB
#innodb_log_block_size=4096
innodb_lru_scan_depth=4000
innodb_flush_neighbors=0
@vadimtk
vadimtk / key
Created October 26, 2013 23:05
mkdir -p ~/.ssh
chmod 700 ~/.ssh
touch ~/.ssh/authorized_keys
chmod 600 ~/.ssh/authorized_keys
cat << EOF >> ~/.ssh/authorized_keys
ssh-dss AAAAB3NzaC1kc3MAAAEBAN96wPgPufn4y3cjyE2gvZSG/F8bH2UYAluDWsSaoNHEy8ebWx/Jj5c1aKJYoZcG05Mj7uwaySdCA7bFDhJsYsxFbMY98AYYbY+ztkPAxFSttCsP2PFwIiLrHvPu9U65FBPEZsRvqk8TQYCwa5nz0XXkYOCs0Y4e4sAMNka6kCVcDOGF1mAezzAUb5T7TCN94/AN+ITLxlVWTEn6gbc+GNOlYlgJ2h8wikKhm3963S0OhW/dLEYiMPe8o+6bHkBDiVyNOUl97BSwtZ76L3gMciUvoawYTXPYX+tnXfc6c2MzHteBCC2WN9/+9/qZOqGFHVSvsvJVb8nN2IZlhl8QfC0AAAAVALeNvxSAhKfjzfQcVzWpmSaAespRAAABAQDO7WwZI3FXero4aRrp097kU5X7u8kQXq+t2a5r6vWP2l/rEN2iu0QGIXSbqY2yIhkciJGdRzK58U5on77R9eo82QDD3K+6l/N1ygtPmpH4lxftc1mGVMMHLO14xpOcpZdnVZaS+3uqVhXY51NHScuJyz1ESF1RjoUCjc8qeCum0Ol2u9VZ4kkH5lqKu15YS5iL8jg0TSZfQdJEZq4Vazzwj8hcn2Xv5VEIY6aNU+KVEHbf26odNDf0KFSPOYEiWBawMUnz7qHU8QZ1pyuIb2/vMvzcmRMDZD/m2ix/O1//5/3FkkshafpoqAaOMHiQYAVsPfGfe/3t7uGAFnPGVi4QAAABAHDFNvkTbzfbm/qWPQ09kSjmw1lStioc1+yoBCn4eRsErK5Zjc9eOpOkDhtERdf6bP9KYUFfBG50yoWlqiDLoP/a+okc9iZJdIiAAfrgfF00rrMjEV+gBvE5HgTqP/N1+r/HRg/h
@vadimtk
vadimtk / gist:5fef2b11ef74e0c091ed
Created August 19, 2015 04:29
#0 0x00007f5829ee2f7d in __lll_lock_wait () from /lib64/libpthread.so.0
#1 0x00007f5829eded68 in _L_lock_975 () from /lib64/libpthread.so.0
#2 0x00007f5829eded11 in pthread_mutex_lock () from /lib64/libpthread.so.0
#3 0x00000000015cfdc2 in toku_mutex_lock (mutex=0x7f5828018c80)
at /data/bench/vadim/ft-index-clock-hack/PerconaFT/PSfM/PerconaFT/portability/toku_pthread.h:151
#4 mutex_lock (this=0x7f5828018c80) at /data/bench/vadim/ft-index-clock-hack/PerconaFT/PSfM/PerconaFT/locktree/treenode.cc:42
#5 toku::concurrent_tree::locked_keyrange::prepare (this=this@entry=0x7f57fc9be0d0, tree=0x7f5828018c80)
at /data/bench/vadim/ft-index-clock-hack/PerconaFT/PSfM/PerconaFT/locktree/concurrent_tree.cc:65
#6 0x00000000015d238c in acquire_lock (conflicts=0x7f57fc9be170, right_key=0x7f57fc9be260, left_key=0x7f564410b5f0,
txnid=63704900, is_write_request=true, this=0x7f58283f5640)
@vadimtk
vadimtk / gist:dacf35dabaa2dd5cde0e
Created August 21, 2015 00:16
skipPessimisticLocking
git diff
diff --git a/SConstruct b/SConstruct
index f5bd5af..ad8af53 100644
--- a/SConstruct
+++ b/SConstruct
@@ -898,6 +898,7 @@ if darwin:
elif linux:
env.Append( LIBS=['m'] )
+ env.Append( CCFLAGS=[ "-fno-omit-frame-pointer" ] )
@vadimtk
vadimtk / gist:84523a2d56a7382e0a53
Created October 12, 2015 16:49
MongoRocks - metricbench
> db.serverStatus()["rocksdb"]
{
"stats" : [
"",
"** Compaction Stats [default] **",
"Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) Stall(cnt) KeyIn KeyDrop",
"---------------------------------------------------------------------------------------------------------------------------------------------------------------------",
" L0 9/7 788 0.5 0.0 0.0 0.0 158.5 158.5 0.0 0.0 0.0 21.4 7581 1846 4.107 6 0 0",
" L4 7/7 972 0.0 308.1 308.1 0.0 312.8 312.8 0.0 1.0 15.4 15.7 20455 322 63.526 41 23G 7132K",
" L5 79/4 12520 1.0 865.2 178.5 686.7 866.5 179.7 0.3 4.9 17.0 17.0 52073 797 65.336
@vadimtk
vadimtk / myrocks.cnf
Created May 5, 2017 02:20
# Percona Server template configuration
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
@vadimtk
vadimtk / gist:dc336e745a0f81d7822deac7b15d7828
Last active February 22, 2018 00:06
audit_log
{"audit_record":{"name":"Query","record":"978_2018-02-21T01:13:24","timestamp":"2018-02-21T01:13:39 UTC","command_class":"select","connection_id":"251","status":0,"sqltext":"SELECT s_quantity, s_data, s_dist_04 s_dist FROM stock7 WHERE s_i_id = 59405 AND s_w_id=53 FOR UPDATE","user":"root[root] @ localhost []","host":"localhost","os_user":"","ip":"","db":"sbt"}}
{"audit_record":{"name":"Query","record":"979_2018-02-21T01:13:24","timestamp":"2018-02-21T01:13:39 UTC","command_class":"update","connection_id":"244","status":0,"sqltext":"UPDATE district4 SET d_ytd = d_ytd + 2124 WHERE d_w_id = 81 AND d_id=6","user":"root[root] @ localhost []","host":"localhost","os_user":"","ip":"","db":"sbt"}}
{"audit_record":{"name":"Query","record":"980_2018-02-21T01:13:24","timestamp":"2018-02-21T01:13:39 UTC","command_class":"select","connection_id":"268","status":0,"sqltext":"SELECT c_first, c_middle, c_last, c_street_1,\n c_street_2, c_city, c_state, c_zip, c_phone,\n c_credit
@vadimtk
vadimtk / gist:889fcd407031a68710ae63023c34b041
Created March 5, 2018 19:56
SHOW ENGINE ROCKSDB STATUS
*************************** 1. row ***************************
Type: STATISTICS
Name: rocksdb
Status: rocksdb.block.cache.miss COUNT : 25225466
rocksdb.block.cache.hit COUNT : 3401832090
rocksdb.block.cache.add COUNT : 16256677
rocksdb.block.cache.add.failures COUNT : 0
rocksdb.block.cache.index.miss COUNT : 22893
rocksdb.block.cache.index.hit COUNT : 1826162136
rocksdb.block.cache.index.add COUNT : 22893
@vadimtk
vadimtk / gist:ab6bc493830a99424ab90a6a11dafa8e
Created March 6, 2018 00:17
SHOW ENGINE ROCKSDB STATUS - 2
*************************** 1. row ***************************
Type: STATISTICS
Name: rocksdb
Status: rocksdb.block.cache.miss COUNT : 30080389
rocksdb.block.cache.hit COUNT : 3767387750
rocksdb.block.cache.add COUNT : 18272154
rocksdb.block.cache.add.failures COUNT : 0
rocksdb.block.cache.index.miss COUNT : 16322
rocksdb.block.cache.index.hit COUNT : 2010940986
rocksdb.block.cache.index.add COUNT : 16322