yuemori · October 29, 2023 08:37
diff --git a/0_初めに.md b/0_初めに.md
diff --git a/1_setup.md b/1_setup.md
diff --git a/2_my.conf b/2_my.conf
 [mysqld]
 bind-address            = 0.0.0.0
 # mysqlx-bind-address     = 0.0.0.0 # for version8.0
 key_buffer_size         = 16M
 myisam-recover-options  = BACKUP
 innodb_buffer_pool_size = 1G
 performance_schema = off
 log_error = /var/log/mysql/error.log
 slow_query_log          = 1
 slow_query_log_file     = /var/log/mysql/mysql-slow.log
 long_query_time = 0
 max_binlog_size   = 100M
 # innodb_log_writer_threads = off # for version 8.0
 innodb_doublewrite = 0 # When enabled (the default), InnoDB stores all data twice, first to the doublewrite buffer, then to the actual data files
 disable-log-bin
 innodb_flush_log_at_trx_commit = 2 # With a setting of 2, logs are written after each transaction commit and flushed to disk once per second. Transactions for which logs have not been flushed can be lost in a crash.
 innodb_flush_method = O_DIRECT # InnoDB uses O_DIRECT (or directio() on Solaris) to open the data files, and uses fsync() to flush both the data and log files.
 innodb_autoinc_lock_mode = 2 # In this lock mode, no “INSERT-like” statements use the table-level AUTO-INC lock, and multiple statements can execute at the same time
diff --git a/3_os.md b/3_os.md
diff --git a/4_nginx.conf b/4_nginx.conf
 # https://gist.github.com/south37/d4a5a8158f49e067237c17d13ecab12a
 worker_processes 2; # or equal cpu core

 worker_rlimit_nofile 65535; # must change os nofile before
 events {
  worker_connections 8192; # must change os nofile before
  accept_mutex_delay 100ms;
  multi_accept on;
  use epoll;
 }

 http {
  include /etc/nginx/mime.types;
  
  proxy_cache_path /dev/shm/proxy_cache keys_zone=zone1:1m max_size=1g inactive=2m;
  proxy_temp_path  /dev/shm/nginx_tmp;
  sendfile        on;
  tcp_nopush     on;
  tcp_nodelay on;
  open_file_cache max=2000 inactive=240s;
  
  log_format ltsv "time:$time_local"
                  "\thost:$remote_addr"
                  "\tforwardedfor:$http_x_forwarded_for"
                  "\treq:$request"
                  "\tstatus:$status"
                  "\tmethod:$request_method"
                  "\turi:$request_uri"
                  "\tsize:$body_bytes_sent"
                  "\treferer:$http_referer"
                  "\tua:$http_user_agent"
                  "\treqtime:$request_time"
                  "\tcache:$upstream_http_x_cache"
                  "\truntime:$upstream_http_x_runtime"
                  "\tapptime:$upstream_response_time"
                  "\tvhost:$host";

  access_log  /var/log/nginx/access.log  ltsv;
  #access_log  off;
  
  # client_body_temp_path /dev/shm/client_body_temp 1 2;
  # keepalive_requests 10000; # increase if needed
    
  gzip on;
  gzip_http_version 1.1;
  gzip_min_length 1000;
  gzip_types text/css
             application/font-tff
             application/font-woff
             application/javascript
             application/json
             application/octet-stream
             application/vnd.ms-fontobject
             application/x-www-form-urlencoded
             image/gif
             image/jpeg
             image/png
             image/svg+xml
             image/vnd.microsoft.icon;

  upstream local_app {
    server 127.0.0.1:1323 max_fails=0 fail_timeout=0;
    keepalive 30;
  }
    
  server {
    # static file の配信用の root
    root /home/isucon/webapp/public/; # change with specific app
    
    # add http1.1 version to location
    location /initialize {
      proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
      proxy_set_header X-Forwarded-Proto $scheme;
      proxy_set_header Host $http_host;
      proxy_http_version 1.1;
      proxy_pass   http://local_app;
    }

    location /api {
      proxy_http_version 1.1;
      proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
      proxy_set_header X-Forwarded-Proto $scheme;
      proxy_set_header Host $http_host;
            
      proxy_pass   http://local_app;
    }
    
    location /api/cached_endpoint {
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
        proxy_set_header Host $http_host;

        proxy_buffering on;
        proxy_cache zone1;
        proxy_cache_valid 200 302 60s;
        proxy_cache_key $scheme$proxy_host$uri$is_args$args;
        add_header X-Nginx-Cache $upstream_cache_status;

        proxy_pass http://local_app/api/cached_endpoint;
    }

    
    location ~* \.(png|ico|gif|jpg|jpeg|css|js|svg)$ {
      expires 7d;
      add_header Cache-Control "public";
    }
    
    #location ~ .*\.(htm|html|css|js|jpg|png|gif|ico) {
    #  expires 24h;
    #  add_header Cache-Control public;
    #  open_file_cache max=100;  # file descriptor などを cache
    #  gzip on;  # cpu 使うのでメリット・デメリット見極める必要あり。gzip_static 使えるなら事前にgzip圧縮した上でそちらを使う。
    #  gzip_types text/css application/javascript application/json application/font-woff application/font-tff image/gif image/png image/jpeg image/svg+xml image/x-icon application/octet-stream;
    #  gzip_disable "msie6";
    #  gzip_static on;  # nginx configure時に --with-http_gzip_static_module 必要
    #  gzip_vary on;
    #}
  }

 }
diff --git a/5_command.md b/5_command.md
diff --git a/6_sample.md b/6_sample.md
diff --git a/7_end.md b/7_end.md
	[mysqld]
	bind-address = 0.0.0.0
	# mysqlx-bind-address = 0.0.0.0 # for version8.0
	key_buffer_size = 16M
	myisam-recover-options = BACKUP
	innodb_buffer_pool_size = 1G
	performance_schema = off
	log_error = /var/log/mysql/error.log
	slow_query_log = 1
	slow_query_log_file = /var/log/mysql/mysql-slow.log
	long_query_time = 0
	max_binlog_size = 100M
	# innodb_log_writer_threads = off # for version 8.0
	innodb_doublewrite = 0 # When enabled (the default), InnoDB stores all data twice, first to the doublewrite buffer, then to the actual data files
	disable-log-bin
	innodb_flush_log_at_trx_commit = 2 # With a setting of 2, logs are written after each transaction commit and flushed to disk once per second. Transactions for which logs have not been flushed can be lost in a crash.
	innodb_flush_method = O_DIRECT # InnoDB uses O_DIRECT (or directio() on Solaris) to open the data files, and uses fsync() to flush both the data and log files.
	innodb_autoinc_lock_mode = 2 # In this lock mode, no “INSERT-like” statements use the table-level AUTO-INC lock, and multiple statements can execute at the same time
	# https://gist.github.com/south37/d4a5a8158f49e067237c17d13ecab12a
	worker_processes 2; # or equal cpu core

	worker_rlimit_nofile 65535; # must change os nofile before
	events {
	worker_connections 8192; # must change os nofile before
	accept_mutex_delay 100ms;
	multi_accept on;
	use epoll;
	}

	http {
	include /etc/nginx/mime.types;

	proxy_cache_path /dev/shm/proxy_cache keys_zone=zone1:1m max_size=1g inactive=2m;
	proxy_temp_path /dev/shm/nginx_tmp;
	sendfile on;
	tcp_nopush on;
	tcp_nodelay on;
	open_file_cache max=2000 inactive=240s;

	log_format ltsv "time:$time_local"
	"\thost:$remote_addr"
	"\tforwardedfor:$http_x_forwarded_for"
	"\treq:$request"
	"\tstatus:$status"
	"\tmethod:$request_method"
	"\turi:$request_uri"
	"\tsize:$body_bytes_sent"
	"\treferer:$http_referer"
	"\tua:$http_user_agent"
	"\treqtime:$request_time"
	"\tcache:$upstream_http_x_cache"
	"\truntime:$upstream_http_x_runtime"
	"\tapptime:$upstream_response_time"
	"\tvhost:$host";

	access_log /var/log/nginx/access.log ltsv;
	#access_log off;

	# client_body_temp_path /dev/shm/client_body_temp 1 2;
	# keepalive_requests 10000; # increase if needed

	gzip on;
	gzip_http_version 1.1;
	gzip_min_length 1000;
	gzip_types text/css
	application/font-tff
	application/font-woff
	application/javascript
	application/json
	application/octet-stream
	application/vnd.ms-fontobject
	application/x-www-form-urlencoded
	image/gif
	image/jpeg
	image/png
	image/svg+xml
	image/vnd.microsoft.icon;

	upstream local_app {
	server 127.0.0.1:1323 max_fails=0 fail_timeout=0;
	keepalive 30;
	}

	server {
	# static file の配信用の root
	root /home/isucon/webapp/public/; # change with specific app

	# add http1.1 version to location
	location /initialize {
	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
	proxy_set_header X-Forwarded-Proto $scheme;
	proxy_set_header Host $http_host;
	proxy_http_version 1.1;
	proxy_pass http://local_app;
	}

	location /api {
	proxy_http_version 1.1;
	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
	proxy_set_header X-Forwarded-Proto $scheme;
	proxy_set_header Host $http_host;

	proxy_pass http://local_app;
	}

	location /api/cached_endpoint {
	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
	proxy_set_header X-Forwarded-Proto $scheme;
	proxy_set_header Host $http_host;

	proxy_buffering on;
	proxy_cache zone1;
	proxy_cache_valid 200 302 60s;
	proxy_cache_key $scheme$proxy_host$uri$is_args$args;
	add_header X-Nginx-Cache $upstream_cache_status;

	proxy_pass http://local_app/api/cached_endpoint;
	}


	location ~* \.(png\|ico\|gif\|jpg\|jpeg\|css\|js\|svg)$ {
	expires 7d;
	add_header Cache-Control "public";
	}

	#location ~ .*\.(htm\|html\|css\|js\|jpg\|png\|gif\|ico) {
	# expires 24h;
	# add_header Cache-Control public;
	# open_file_cache max=100; # file descriptor などを cache
	# gzip on; # cpu 使うのでメリット・デメリット見極める必要あり。gzip_static 使えるなら事前にgzip圧縮した上でそちらを使う。
	# gzip_types text/css application/javascript application/json application/font-woff application/font-tff image/gif image/png image/jpeg image/svg+xml image/x-icon application/octet-stream;
	# gzip_disable "msie6";
	# gzip_static on; # nginx configure時に --with-http_gzip_static_module 必要
	# gzip_vary on;
	#}
	}

	}