Kouni Kouni

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

Doing a SELECT on a specific timestamp range

Here, the Athena table athena_table has the columns timestamp, day, month, year, id

select timestamp,month,day,year,id
from athena_table

WHERE month = 8 and day = 15
AND (CAST(timestamp as varchar) BETWEEN '2018-08-15 22:00:00' AND '2018-08-15 22:10:00')

Generate and add your key to GitHub
$ git config --global commit.gpgsign true ([OPTIONAL] every commit will now be signed)
$ git config --global user.signingkey ABCDEF01 (where ABCDEF01 is the fingerprint of the key to use)
$ git config --global alias.logs "log --show-signature" (now available as $ git logs)
$ git config --global alias.cis "commit -S" (optional if global signing is false)
$ echo "Some content" >> example.txt
$ git add example.txt
$ git cis -m "This commit is signed by a GPG key." (regular commit will work if global signing is enabled)

Credit to MadHatter

WINDOWS

Use your text editor of choice or if you don't have one use Windows Notepad
Opening with Notepad may or may not result in a fancy mess

Close Spotify
Open File Explorer and paste the following into the address bar %appdata%/Spotify
Open the file named prefs with your text editor
Change the numeric value following storage.size= . If storage.size= doesn't exist add it manually to the end of the file and assign numeric value. This value represents megabytes. One gigabyte equals 1024 megabytes. In the end, it should look something like this storage.size=1024
Save the file

The repository for the assignment is public and Github does not allow the creation of private forks for public repositories.

The correct way of creating a private frok by duplicating the repo is documented here.

For this assignment the commands are:

Create a bare clone of the repository. (This is temporary and will be removed so just do it wherever.)

git clone --bare [email protected]:usi-systems/easytrace.git

	#!/bin/bash

	AWS_DEFAULT_REGION="ap-northeast-1"
	AWS_ACCESS_KEY_ID="YOUR ACCESS KEY HERE"
	AWS_SECRET_ACCESS_KEY="YOUR SECRET ACCESS KEY HERE"

	INSTANCE_ID_URL="http://169.254.169.254/latest/meta-data/instance-id"
	INSTANCE_ID=$(curl -s ${INSTANCE_ID_URL})

	SERVER_STATUS_URL="http://localhost/php-fpm-status"

Kouni Kouni

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

Doing a SELECT on a specific timestamp range

Table of Contents

set -e, -u, -x, -o pipefail

WINDOWS