Tech Tips

Several parameters have defaults that differ from the previous versions and the mail reason for these changes to provide better out-of-box performance and to eliminate the need for the database administrator to change settings manually. Upgrades also give you access to new enhancements made in the newer versions. Following are the instructions for upgrading MySQL... Continue Reading

MySQL stopped running due to improper shutdown or abrupt close of the query. To start the MySQL service, please use the following reasons and solutions. MySQL not start due to existing lock file # servicemysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] Above command will shows that the MYSQL is not running. We... Continue Reading

MySQL is an open source RDBMS that supports all platforms like Unix, Windows and Linux. MySQL is mostly associated with web apps and online publishing. MySQL can be used to a wide range of applications as the working model is a client-based server. There would be situations where the MySQL database server would crash and... Continue Reading

LAMP is a very common example of a web service stack that contains four components – Linux OS, Apache Web Server, MySQL Database and PHP programming language. LAMP Stack is suitable for building dynamic websites and web applications. The following command installs LAMP with a single command on Ubuntu based distro servers.                 $ sudo... Continue Reading