MySQL Slow Query Logs

“Slow Query” :-  Slow Query in simple terms can be defined as the query which took long time to get executed.. By default MySQL server is configured to mark the query which takes more then 10 sec to get executed as Slow Query. It is best pratice to log all...

mysqldump with selected tables

Mysql Command to take Dump of Selected Tables in the Mysql Database If you wish to take dump of on few tables such as table1, table2 & table3 use the command mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql If you wish to...

Table ‘mysql.servers’ doesn’t exist.

On Linux Plesk server if while adding mysql user or the database  you are getting error as follows Connection to the database server has failed: Table ‘mysql.servers’ doesn’t exist. The issue indicates that the mysql version on the server needs...