MySQL Server Performance Tips

MySQL Server Performance Tips: Do regular maintenance of MyISAM tables with analyze and optimize commands. Choose better backup policy for DBs. It completely depends on which storage engine we are using. Always try compress static data so can save the space and no need to take backup often. Check MySQL memory utilization before set any…

How to install Drupal 7.0 on Ubuntu 10.04

Drupal is a free and robust content-management system which runs on LAMP(Linux, Apache, MySQL and PHP) server. PostgreSQL and MariaDB are also compatible with with Drupal. Before start Drupal 7.0 installation, we have to install following packages related to LAMP. Here, I’m imagine that Ubuntu 10.04 is already installed 🙂 – A web server. Apache…

Quick Reference of MySQL Data Types

    Quick Reference of MySQL Data Types There are three primary categories, which is true for almost every database software: Text Numbers Dates and times Within each of these, there are a number of variants—some of which are MySQL-specific—you can use. Choosing your column types correctly not only important what information can be stored…