s-tajima’s gists

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 <[email protected]>",,,,"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 / 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 / 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 / benchmark.sh

Last active August 29, 2015 14:02

Result of ioDrive benchmark. (MySQL)

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 / 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 / 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 / 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 / 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 / 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

Satoshi Tajima s-tajima