nguaman’s gists

nguaman / install-mongodb.md

Created June 21, 2016 16:33 — forked from adamgibbons/install-mongodb.md

Install MongoDB on Mac OS X 10.9

brew install mongodb
mkdir -p /data/db

Ensure that user account running mongod has correct permissions for the directory:

nguaman / gist:7d34152458e2b70d6eea3c852cadd707

Created June 16, 2016 15:51 — forked from douglasjarquin/gist:2208690

Amazon RDS Performance Tuning Settings

	rds-modify-db-parameter-group {param-group-name} \
	--parameters="name=character_set_server, value=utf8, method=pending-reboot" \
	--parameters="name=collation_server, value=utf8_general_ci, method=pending-reboot" \
	--parameters="name=tmp_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=max_heap_table_size, value={DBInstanceClassMemory/16}, method=pending-reboot" \
	--parameters="name=query_cache_type, value=1, method=pending-reboot" \
	--parameters="name=query_cache_size, value=131072, method=pending-reboot" \
	--parameters="name=table_open_cache, value=2500, method=pending-reboot" \
	--parameters="name=join_buffer_size, value={DBInstanceClassMemory/64}, method=pending-reboot" \
	--parameters="name=thread_cache_size, value={DBInstanceClassMemory/12582880}, method=pending-reboot" \

nguaman / rds.sh

Created June 16, 2016 14:44 — forked from onyxraven/rds.sh

Amazon RDS Performance Tuning Settings

	#XLarge DBInstanceClassMemory = 15892177440 = 14.8GB
	#/32 = 496630545 = 473MB
	#/64 = 248315272 = 236MB
	#/128 = 124157636 = 118MB
	#/256 = 62078818 = 59MB
	#/512 = 31039409 = 29MB
	#/12582880 = 1263 #default same divisor as max_connections = 4041.6MB = 4237924762
	#/25165760 = 623 # half of max_connections = 1993.6MB
	#/50331520 = 315 # quarter of max_connections = 1008MB = 1056964608
	#*(3/4) #default innodb pool size = 11922309120

nguaman / clone-mysql-db.sh

Created June 9, 2016 13:59 — forked from christopher-hopper/clone-mysql-db.sh

Clone a MySQL database to a new database on the same server without using a dump file. This is much faster than using mysqldump.

	#!/bin/bash

	DBUSER="root";
	DBPASS="";
	DBHOST="localhost";

	DB_OLD=mydatabase
	DB_NEW=clone_mydatabase

	DBCONN="--host=${DBHOST} --user=${DBUSER} --password=${DBPASS}";

Created May 26, 2016 16:54 — forked from kymtwyf/bash: cannot create temp file for here-document: No space left on device.md

bash: cannot create temp file for here-document: No space left on device

参考很奇怪的事情

cd /m

之后打了一个tab给我提示：

bash: cannot create temp file for here-document: No space left on device

查了一圈之后找到答案：(具体原因不明，需要以后查看）

Created May 16, 2016 22:56 — forked from nestoru/Solution for mysql Warning: Using a password on the command line interface can be insecure

Solution for mysql Warning: Using a password on the command line interface can be insecure

	# Let us consider the following typical mysql backup script:
	mysqldump --routines --no-data -h $mysqlHost -P $mysqlPort -u $mysqlUser -p$mysqlPassword $database

	# It succeeds but stderr will get:
	# Warning: Using a password on the command line interface can be insecure.
	# You can fix this with the below hack:
	credentialsFile=/mysql-credentials.cnf
	echo "[client]" > $credentialsFile
	echo "user=$mysqlUser" >> $credentialsFile
	echo "password=$mysqlPassword" >> $credentialsFile

Nelson Guamán nguaman