Max Castro kaioken

WordPress database clean up queries

Orphan rows
Other

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.

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

Frontend Development

Attention: the list was moved to

https://github.com/dypsilon/frontend-dev-bookmarks

This page is not maintained anymore, please update your bookmarks.

	# install build dependencies
	sudo yum install -y git-core zlib zlib-devel gcc-c++ patch readline readline-devel libyaml-devel libffi-devel openssl-devel make bzip2 autoconf automake libtool bison curl sqlite-devel

	# clone and install rbenv environment
	cd ~
	git clone git://github.com/sstephenson/rbenv.git .rbenv
	git clone git://github.com/sstephenson/ruby-build.git ~/.rbenv/plugins/ruby-build
	echo 'export PATH="$HOME/.rbenv/bin:$HOME/.rbenv/plugins/ruby-build/bin:$PATH"' >> ~/.bash_profile
	echo 'eval "$(rbenv init -)"' >> ~/.bash_profile

	// Reference: http://www.blackdogfoundry.com/blog/moving-repository-from-bitbucket-to-github/
	// See also: http://www.paulund.co.uk/change-url-of-git-repository

	$ cd $HOME/Code/repo-directory
	$ git remote rename origin bitbucket
	$ git remote add origin https://github.com/mandiwise/awesome-new-repo.git
	$ git push origin master

	$ git remote rm bitbucket

	<?php
	/**
	* Returns a pre-signed URL to access a restricted AWS S3 object.
	*
	* @param string $access_key the AWS access key
	* @param string $secret_key the AWS secret key associated with the access key
	* @param string $bucket the S3 bucket
	* @param string $canonical_uri the object in the S3 bucket expressed as a canonical URI.
	* This should begin with the / character, and should not be URL-encoded
	* @param int $expires the time that the pre-signed URL will expire, in seconds

	;###################################################
	; NOTE
	;####################################################
	; change your curl.ini on /etc/php.d/curl.ini
	;
	;This config was only tested on amazon AMI
	;Please check if /etc/ssl/certs/ca-bundle.crt exists
	;
	;If you don't have the ca-bundle root certificate you
	; can get this in

	# Don't show errors which contain full path diclosure (FPD)
	# Use that line only if PHP is installed as a module and not per CGI
	# try using a php.ini in that case.
	# Change mod_php5.c to mod_php7.c if you are running PHP7
	<IfModule mod_php5.c>
	php_flag display_errors Off
	</IfModule>

	# Don't list directories
	<IfModule mod_autoindex.c>

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048