Adding new column on a large SQL Database table posted 2 years ago

Just Using ALTER column on a huge database table to add a new column can bring the database down.

How to allow remote access to database on Digital Ocean Server (from Scratch) posted 4 years ago

We will show you how you can set up database and grant remote access to all or specific server from scratch.

Syntax error or access violation: 1118 The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size posted 8 years ago

Increase the Innodb_log_file_size to a bigger value. Generally the rule of thumb is to increase the Innodb_log_file_size to 10 times the size of the plugin.

Can't connet to local MySQL server through mysqld.sock posted 9 years ago

Solution for: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) or Connection for controluser as defined in your configuration failed while trying to access via phpmyadmin.

What if you screw up your phpmyadmin? posted 9 years ago

Sometime you might screw up your phpmyadmin after upgrading Apache or the PHP. This article show you how to remove and reinstall phpmyadmin easily in Ubuntu.

When should you denormalize a database? posted 9 years ago

When should you denormalize a database and when you shouldn't. Pros and Cons of denormalizing a database. How can performance be optimized by denormalizing a database.