Posts Tagged: MySQL

Powerful Redmine in AWS

In this post i will show how to make a installation of Redmine in AWS with some nice tools from AWS (EC2, RDS, S3, SES, ElastiCache) and making it auto scalable.

redmine

Press continue reading for more.

RDS Instance Sizes, maximum concurrent connections

amazon_rds_logo

RDS Class max_connections

t1.micro 34
m1.small 125
m1.medium 296
m1.large 623
m1.xlarge 1263
m2.xlarge 1441
m2.2xlarge 2900
m2.4xlarge 5816

CLI Database optimization

MySQL:

sudo apt-get install mysql-client

mysqlcheck -h yourdatabasehost -u root -p --auto-repair --check --all-databases
mysqlcheck -h yourdatabasehost -u root -p --auto-repair --optimize --all-databases

PostgreSQL:

Vacuum
vacuumdb -afvz -h yourdatabasehost -u postgres

ReindexDB
reindexdb -a -h yourdatabasehost -u postgres