MySQL has two primary storage engines: MyISAM and InnoDB.
Each has its own performance characteristics and considerations but generally MyISAM is good for read-intensive data and InnoDB is good for transactional data.
mysql
How to install and configure LEMP (Nginx, MySQL and PHP) server on a Debian 6 (squeeze) VPS
Nginx is a free, open-source, high-performance HTTP server which unlike his ‘friends’, it does not rely on threaded handling of the requests but instead it uses a much more scalable event driven (asynchronous) architecture. This uses a very small and predictable amount of memory under heavy load. Nginx in combination with the simple and very robust FastCGI Process Manager for PHP (PHP-FPM) and the world most popular database server MySQL can give you a lot of power and performance while still using a small memory footprint.
The following article looks at how to install and configure this stack on one of our Debian based VPSes.
How to Reset MySQL Root Password
We will show you, how to reset MySQL root password. If you assigned a root password previously but have forgotten it, you can assign a new password. Resetting the root password of MySQL server, is fairly easy task, and it can be accomplished in less than 10 minutes.