Skip to content

Instantly share code, notes, and snippets.

View s-tajima's full-sized avatar

Satoshi Tajima s-tajima

21 followers · 9 following
View GitHub Profile
@s-tajima
s-tajima / dstat_sysbench.csv
Created May 31, 2014 13:02
sysbench result at 2014/05/31 Case1
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 7. in line 1.
"Dstat 0.7.0 CSV output"
"Author:","Dag Wieers <dag@wieers.com>",,,,"URL:","http://dag.wieers.com/home-made/dstat/"
"Host:","mysql-test01.hq.ecnavi.info",,,,"User:","root"
"Cmdline:","dstat -tclmdrn --output result/dstat_sysbench.csv 3",,,,"Date:","01 Jun 2014 05:42:09 JST"
"system","total cpu usage",,,,,,"load avg",,,"memory usage",,,,"dsk/total",,"io/total",,"net/total",
"date/time","usr","sys","idl","wai","hiq","siq","1m","5m","15m","used","buff","cach","free","read","writ","read","writ","recv","send"
01-06 05:42:09,1.817,0.557,97.419,0.184,0.004,0.019,2.090,2.030,2.010,2887806976.0,202784768.0,12348837888.0,16097980416.0,198036.477,4464182.055,15.400,289.822,0.0,0.0
01-06 05:42:12,21.235,12.015,61.452,4.631,0.292,0.375,2.090,2.030,2.010,2528866304.0,1417216.0,24043520.0,28983083008.0,149090304.0,45397.333,9045.0,7.0,546.0,788.667
01-06 05:42:15,57.952,15.233,2.770,22.157,0.881,1.007,3.360,2.290,2.090,2528804864.0,1466368.0,24047616.0,28983091200.0,402731008.0,64170.667,24578.333,8.333,238.667,491.333
@s-tajima
s-tajima / my.cnf
Created May 30, 2014 08:58
mysqlslap result at 2014/05/30 Case3 (TYPE="mixed")
[mysqld_multi]
mysqld=/usr/bin/mysqld_safe
mysqladmin=/usr/bin/mysqladmin
log=/var/log/mysql/mysqld_multi.log
[mysqld]
user=mysql
character-set-server=utf8
long_query_time=1
@s-tajima
s-tajima / df.txt
Last active August 29, 2015 14:02
mysqlslap result at 2014/05/30
[root@mysql-test01 result]# df -hT
Filesystem Type Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root ext4 50G 3.4G 44G 8% /
tmpfs tmpfs 15G 0 15G 0% /dev/shm
/dev/sda1 ext4 485M 32M 428M 7% /boot
/dev/mapper/VolGroup-lv_hdd1 ext4 74G 1.3G 69G 2% /hdd1
/dev/mapper/VolGroup-lv_hdd2 xfs 75G 1.3G 74G 2% /hdd2
/dev/fioa ext4 74G 1.3G 69G 2% /fio1
/dev/fiob xfs 75G 1.3G 74G 2% /fio2
@s-tajima
s-tajima / benchmark.sh
Last active August 29, 2015 14:02
Result of ioDrive benchmark. (MySQL)
#!/bin/bash
for DIR in "fio1" "fio2" "hdd1" "hdd2"
do
sync
echo 3 > /proc/sys/vm/drop_caches
sync
sysbench \
--test=oltp \
@s-tajima
s-tajima / fio1_ext4_seq_01.txt
Created May 29, 2014 13:31
Result of ioDrive benchmark. (sequential)
[root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=seqwr --max-requests=100000 run
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 160Mb each
20Gb total file size
Block size 16Kb
@s-tajima
s-tajima / fio1_ext_rand_01.txt
Created May 29, 2014 13:21
Result of ioDrive benchmark. (random)
[root@mysql-test01 fio1]# sysbench --test=fileio --file-total-size=20G --file-test-mode=rndrw --max-requests=100000 run
sysbench 0.4.12: multi-threaded system evaluation benchmark
Running the test with following options:
Number of threads: 1
Extra file open flags: 0
128 files, 160Mb each
20Gb total file size
Block size 16Kb
@s-tajima
s-tajima / command_log.txt
Created March 11, 2014 10:25
Command log of test for MHA failover.
= t1 -------------------------------------------------------------------------------------------------------------------------------------------
mysqlserver-a> select * from test_table01;
+----+---------------------+---------------------------+
| id | time | text |
+----+---------------------+---------------------------+
| 1 | 2014-03-10 15:33:42 | cva3fiwqey0owkoosc4c04kk4 |
| 2 | 2014-03-10 15:33:42 | 4bbdnnjqxr0gkw48kkgc8k8sc |
| 3 | 2014-03-10 15:33:42 | 6515bxq6eyw4w8ksoogogo4wo |
+----+---------------------+---------------------------+
@s-tajima
s-tajima / manager.log
Created March 11, 2014 08:16
MHA FailOver log.
Mon Mar 10 17:41:08 2014 - [warning] Got error on MySQL ping: 2006 (MySQL server has gone away)
ssh: connect to host 10.0.0.1 port 22: Connection refused
Mon Mar 10 17:41:08 2014 - [warning] HealthCheck: SSH to mysqlserver-a is NOT reachable.
Mon Mar 10 17:41:11 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Mon Mar 10 17:41:11 2014 - [warning] Connection failed 1 time(s)..
Mon Mar 10 17:41:14 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Mon Mar 10 17:41:14 2014 - [warning] Connection failed 2 time(s)..
Mon Mar 10 17:41:17 2014 - [warning] Got error on MySQL connect: 2013 (Lost connection to MySQL server at 'reading initial communication packet', system error: 111)
Mon Mar 10 17:41:17 2014 - [warning] Connection failed 3 time(s)..
Mon Mar 10 17:41:17 2014 - [warning] Master is not reachable from health checker!
@s-tajima
s-tajima / haproxy.cfg
Last active August 29, 2015 13:57
main config and rewrite script for HAproxy.
global
log 127.0.0.1 local2
chroot /var/lib/haproxy
pidfile /var/run/haproxy.pid
maxconn 1000
user haproxy
group haproxy
daemon
stats socket /var/lib/haproxy/stats
@s-tajima
s-tajima / manager.conf
Last active August 29, 2015 13:57
/etc/mha4mysql/manager.conf
[server default]
user=root
password=mysqlrootpass
manager_workdir=/var/log/mha4mysql/
manager_log=/var/log/mha4mysql/manager.log
remote_workdir=/var/log/mha4mysql/
#enable later
#master_ip_failover_script=/etc/mha4mysql/scripts/rewrite_haproxy_config.rb