s-tajima

#! /bin/bash

TMP_SAVE_DIR="/home/ --"
TARGET_URL="http://"
TARGET_FILE="target"
TARGET_FILE_TMP="target.tmp"

if [ ! -d ${TMP_SAVE_DIR} ]; then
    mkdir -p ${TMP_SAVE_DIR}
    if [ $? != 0 ]; then

s-tajima

# 連番でディレクトリを作成
 seq 1 10 | xargs -t -i mkdir test_{}
 mkdir test_{1..10}

s-tajima

<?php

//ユーザ情報配列からidだけ抜き出す
$users = array(
        array('id' => 1, 'name' => 'name1'),
        array('id' => 2, 'name' => 'name2'),
        array('id' => 3, 'name' => 'name3'),
        array('id' => 4, 'name' => 'name4')
        );

s-tajima

<?php
echo "Hello";

s-tajima

#テーブルの初期化
TRUNCATE TABLE tablename;

#複数のカラムでユニークキーを張る
ALTER TABLE tablename ADD CONSTRAINT UNIQUE (column1, column2);

#テーブルにカラムを追加する
ALTER TABLE tablename ADD COLUMN columnname rule AFTER columnname;
ex.）ALTER TABLE users ADD COLUMN rest_partner_num int NOT NULL DEFAULT 20 AFTER tutorial;

s-tajima

require 'rubygems'
require 'pp'
require 'json'

def init
  `mkdir -p ./fetch_log_tmp`
end

def finalize 
  `rm -f ./fetch_log_tmp/*`

s-tajima

[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

[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

"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

"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