Skip to content

Instantly share code, notes, and snippets.

View s-tajima's full-sized avatar

Satoshi Tajima s-tajima

View GitHub Profile
@s-tajima
s-tajima / result.txt
Created April 20, 2020 13:02
SQS Endpoint Latency
$ for EP in $(cat sqs-endpoint.txt); do ping -c 4 $EP; echo; echo; done
PING sqs.ap-east-1.amazonaws.com (13.248.36.32) 56(84) bytes of data.
64 bytes from 13.248.36.32 (13.248.36.32): icmp_seq=1 ttl=232 time=53.1 ms
64 bytes from 13.248.36.32 (13.248.36.32): icmp_seq=2 ttl=232 time=52.6 ms
64 bytes from 13.248.36.32 (13.248.36.32): icmp_seq=3 ttl=232 time=52.6 ms
64 bytes from 13.248.36.32 (13.248.36.32): icmp_seq=4 ttl=232 time=52.7 ms
--- sqs.ap-east-1.amazonaws.com ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3003ms
rtt min/avg/max/mdev = 52.630/52.779/53.142/0.312 ms
@s-tajima
s-tajima / DenyDisableAudit.json
Created November 20, 2019 15:01
AWS SCPs Policies
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Deny",
"Action": [
"organizations:LeaveOrganization",
"config:DeleteConfigRule",
"config:DeleteConfigurationRecorder",
"config:DeleteDeliveryChannel",
@s-tajima
s-tajima / fetch_log.rb
Last active August 29, 2015 14:02
fetch td-agent log.
require 'rubygems'
require 'pp'
require 'json'
def init
`mkdir -p ./fetch_log_tmp`
end
def finalize
`rm -f ./fetch_log_tmp/*`
@s-tajima
s-tajima / my.cnf
Created June 2, 2014 09:38
mysqlslap result at 2014/06/02 case2
[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 / my.cnf
Created June 2, 2014 09:07
mysqlslap result at 2014/06/02 case1
[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 / dstat_sysbench.csv
Last active August 29, 2015 14:02
sysbench result at 2014/06/01 Case6
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:","02 Jun 2014 21:45:55 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"
02-06 21:45:55,1.084,0.410,98.231,0.260,0.003,0.012,2.0,2.0,2.0,18437144576.0,2654208.0,20963328.0,13076647936.0,510231.452,2617234.166,28.788,164.497,0.0,0.0
02-06 21:45:58,59.003,17.337,14.196,7.580,0.628,1.256,2.720,2.150,2.050,19183427584.0,29376512.0,29335552.0,12295270400.0,255862101.333,24465408.0,15827.0,4970.667,286.0,1100.0
02-06 21:46:01,63.321,18.235,3.722,12.882,0.544,1.297,2.720,2.150,2.050,19931938816.0,58503168.0,36749312.0,11510218752.0,248360960.0,27800917.333,15404.0,5361.0,672.0,678.667
@s-tajima
s-tajima / dstat_sysbench.csv
Created June 1, 2014 03:48
sysbench result at 2014/06/01 Case5
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 21:46:05 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 21:46:05,1.447,0.485,97.766,0.283,0.003,0.016,1.910,3.500,5.200,4435611648.0,1564672.0,697929728.0,26402304000.0,491903.746,3429070.843,31.376,220.633,0.0,0.0
01-06 21:46:08,46.205,16.722,22.686,12.886,0.542,0.959,1.910,3.500,5.200,5218349056.0,24522752.0,31113216.0,26263425024.0,267513856.0,19592533.333,16444.333,3278.333,667.333,3196.0
01-06 21:46:11,56.355,17.298,1.936,22.685,0.715,1.010,2.880,3.670,5.250,6063812608.0,48705536.0,36384768.0,25388507136.0,281077077.333,23334912.0,17360.333,3647.667,62
@s-tajima
s-tajima / dstat_sysbench.csv
Created June 1, 2014 03:37
sysbench result at 2014/06/01 Case4
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 21:32:39 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 21:32:39,1.438,0.482,97.809,0.253,0.003,0.015,2.110,5.040,5.080,15639875584.0,2957312.0,24035328.0,15870541824.0,434943.708,3399727.415,28.423,219.556,0.0,0.0
01-06 21:32:42,60.277,17.953,9.983,9.941,0.671,1.174,2.110,5.040,5.080,16463581184.0,33243136.0,30912512.0,15009673216.0,270903978.667,25427968.0,16781.0,4485.0,680.667,1038.667
01-06 21:32:45,68.889,20.713,1.887,6.457,0.797,1.258,3.380,5.250,5.150,17397170176.0,71507968.0,39022592.0,14029709312.0,308944896.0,32279210.667,19147.667,5671.667,748.3
@s-tajima
s-tajima / dstat_sysbench.csv
Created June 1, 2014 03:26
sysbench result at 2014/06/01 Case 3
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 21:23:31 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 21:23:31,1.431,0.480,97.839,0.232,0.003,0.015,1.850,1.910,2.980,4276502528.0,1417216.0,608673792.0,26650816512.0,387455.559,3407668.729,25.536,220.067,0.0,0.0
01-06 21:23:34,47.029,14.226,23.096,14.393,0.544,0.711,2.740,2.100,3.040,5044092928.0,3162112.0,25317376.0,26464837632.0,261320704.0,30037.333,15849.0,7.333,380.0,799.333
01-06 21:23:37,69.153,19.866,1.593,7.795,0.796,0.796,2.740,2.100,3.040,6165258240.0,3346432.0,26124288.0,25342681088.0,375156736.0,25941.333,22900.667,5.0,978.0,936.0
@s-tajima
s-tajima / dstat_sysbench.csv
Created May 31, 2014 13:36
sysbench result at 2014/05/31 Case2
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 07:10:51 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 07:10:51,1.783,0.552,97.424,0.218,0.004,0.019,1.920,2.0,2.0,4254179328.0,1740800.0,18673664.0,27262816256.0,307614.938,4346259.893,21.981,281.470,0.0,0.0
01-06 07:10:54,54.904,16.513,18.022,9.179,0.712,0.671,3.050,2.230,2.070,5205237760.0,2875392.0,25862144.0,26303434752.0,316738218.667,32426.667,19246.333,6.667,336.667,4300.0
01-06 07:10:57,64.304,18.205,1.720,14.346,0.713,0.713,3.050,2.230,2.070,6245322752.0,2908160.0,25858048.0,25263321088.0,344883200.0,45056.0,21054.0,4.0,290.0,4216.667