ISUCON5 事前準備いろいろメモ

memo.mkd

公式情報

• ISUCON5 予選ポータル
• ISUCON5 予選レギュレーション : ISUCON公式Blog
• ISUCON参加者向け Google Cloud Platform (GCP)の使い方 : ISUCON公式Blog
• idobata
  • https://idobata.io/organizations/isucon5/rooms/qualifier-sun/join_request/f63b7610-599b-4122-9993-b345842355a9

技術情報

• google computer platform
  • https://console.developers.google.com/project/serious-unison-108009/compute/instances?graph=GCE_CPU&duration=PT1H
  • ssh-config
    • gcloud compute config-ssh
  • disk サイズで性能が変わる!!
• kernel
  • sysctl

net.ipv4.tcp_max_tw_buckets = 2000000
net.ipv4.ip_local_port_range = 10000 65000
net.core.somaxconn = 32768
net.core.netdev_max_backlog = 8192
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_fin_timeout = 10

• Percona
  • slowlog
    • mysql -e 'set global LOG_QUERIES_NOT_USING_INDEXES=1'
  • my.cnf
    • https://gist.github.com/mapk0y/b70c99878448aca318ea
  • setup
    • https://www.percona.com/doc/percona-server/5.6/installation/apt_repo.html

sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
echo "deb http://repo.percona.com/apt "$(lsb_release -sc)" main" | sudo tee /etc/apt/sources.list.d/percona.list
sudo apt-get update
sudo apt-get install -y percona-server-server-5.6

• nginx
  • 1.9?
    • apt
      • https://www.nginx.com/resources/wiki/start/topics/tutorials/install/
      • http://nginx.org/en/linux_packages.html#mainline
    • http://nginx.org/download/nginx-1.9.5.tar.gz

mkdir -p /opt/{app,src}
cd /opt/src
wget http://nginx.org/download/nginx-1.9.5.tar.gz
tar xzf nginx-1.9.5.tar.gz
cd nginx-1.9.5
./configure --prefix=/opt/app/nginx-1.9.5

• lua
• cache