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