Monthly Archives: November 2013

CLI Database optimization

MariaDB & 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:

vacuumdb -afvz -h yourdatabasehost -U postgres
reindexdb -a -h yourdatabasehost -U postgres
 
*updated* November, 04, 2021
Docker example:
docker exec -it postgres-server vacuumdb -afvz -U postgres

Amazon Web Services – Free Tier

How to get started with AWS free?
Just go to http://aws.amazon.com/free/ and make your account.
Credicard will be needed even for a free account.

What can be done with the free account?
It’s up to you! If you are going to make a light traffic website free tier can handle it. πŸ™‚

You can have up to two EC2 instances (1 Linux, 1 Windows) with 613M Ram and up to 30GB EBS Size. You can go with all your 30GB on a Linux instance it’s the best way to spend your β€˜free’ resources. (Windows is memory hungry.)

You can have up to one RDS instance (postgres, mysql, …) with 20GB of DB storage and 20GB for backups.

You can have up to one S3 with 5GB of storage with up to 20k put and 20k get requests.

You can have up to one Memcached server with 213MB

And some more things (ELB, DynamoDB, SNS, CloudWatch, …)

Continue reading

Check you website performance

WebPageTest, GTmetrix, PageSpeed Insights and Website Grader can test your website and your webserver and helps you to see if you are using optimal configurations!