Adding new column on a large SQL Database table posted 1 year ago
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.
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 6 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 7 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 7 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 7 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.