mitkot

alias em='emacsclient'
alias cpidrsa='cat ~/.ssh/id_rsa|pbcopy'
alias dsl='sudo pmset -a disablesleep 1'
alias esl='sudo pmset -a disablesleep 0'
export PYENV_ROOT="$HOME/.pyenv"
export PATH="$PYENV_ROOT/bin:$PATH"
eval "$(pyenv init -)"

mitkot

;; Environment to Japanese /  encoding to utf-8
(set-locale-environment nil)
(set-language-environment "Japanese")
(set-terminal-coding-system 'utf-8)
(set-keyboard-coding-system 'utf-8)
(set-buffer-file-coding-system 'utf-8)
(set-default-coding-systems 'utf-8)
(prefer-coding-system 'utf-8)
(menu-bar-mode 0)
(setq inhibit-startup-message t)        ;; Surpress Startup message

mitkot

#!/usr/bin/env python
# _*_ coding: utf-8 _*_

#
# OBJECTIVES
# ============
# On Windows OS, the following command can export the hotfixes list.
# 
# "wmic qfe list full /format:list > hotfixes.txt"
# 

mitkot

select t.trx_mysql_thread_id
       , t.trx_state
       , t.trx_started
       , t.trx_isolation_level
       , p.HOST host
       , p.TIME seconds
       , p.INFO query
from information_schema.INNODB_TRX t
  inner join information_schema.PROCESSLIST p
   on t.trx_mysql_thread_id = p.ID

mitkot

select tb.trx_mysql_thread_id blocking_id
       , tb.trx_state blocking_state
       , tb.trx_started blocking_starttime
       , pb.HOST blocking_host
       , pb.TIME blocking_seconds
       , pb.INFO blocking_info       
       , tw.trx_mysql_thread_id requesting_id
       , tw.trx_state requesting_state
       , tw.trx_started requesting_starttime
       , pw.HOST requesting_host

mitkot

#!/bin/sh
    aws ec2 describe-instances|jq -r '.Reservations[].Instances[]|select (.State.Name=="running")|"\(.InstanceId)\t\(.InstanceType)\t\(.Tags[].Value)\t\(.PublicIpAddress)\t\(.PublicDnsName)\t\(.State.Name)"'

mitkot

$ rpm2cpio ../hoge.src.rpm | cpio -i

mitkot

#!/bin/sh
if [ -z "$1"];then
    user="(master user)"
else
    user=$1
fi
PGPASSWORD=(password) psql -h (redshift endpoint) -U $user -p (port) -d (database name)

mitkot

aws s3 cp s3://(CloudTrail Bucket)/AWSLogs/(Account ID)/CloudTrail/(region)/yyyy/mm/dd/(cloud trail log file name).json.gz - |zcat |jq -r '.Records[]|select (.eventName=="ModifyInstanceAttribute")|[.eventTime, .requestParameters.instanceId,.requestParameters.instanceType.value]|@csv'

mitkot

#!/usr/bin/env ruby

require 'ipaddr'


begin
  puts IPAddr.new(ARGV[0]).to_range.to_s.gsub(/\.\./,"-")
rescue
  puts 'i.e.) $ cidr 192.168.1.0/24'
end