Just Using ALTER column on a huge database table to add a new column can bring the database down.
We will show you how you can set up database and grant remote access to all or specific server from scratch.
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.
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.
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 and when you shouldn't. Pros and Cons of denormalizing a database. How can performance be optimized by denormalizing a database.