Even though there are lot of variables that you can tweak to improve the performance of MySQL, only few of them are more important. The main variables are :- innodb_buffer_pool_size :- This is very important variable if you are using InnoDB while comparing with MyISAM. InnoDB much more sensitive in the buffer pool size. Since… Read More »
Introduction MySQL is the most widely used open source relational database management system (RDBMS) and act as a database server providing multiple user access to number of databases. SQL means structured query language. The first version of MySQL was released on 23 May 1995 and was owned and sponsored by a Swedish Company MySQL AB… Read More »
For using mysqlhotcopy the database user must have RELOAD privilege. To set this we need root access of database. [root@server]# mysql -u root -p Enter password : mysql > grant reload on *.* to <user_name>; mysql > \q There are two options for mysqlhotcopy. “allowold” and “keepold” –keepold : keeps two copy of backup. One is <databasename> and… Read More »