Mysql dba tips and tricks

Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replicati...

Mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control th...

Add this in my.cnf and then restart MySQL server: general_log = 1 log=/var/log/mysql_slowquery.log You can check whether the general_l...

 The easiest way is ALTER TABLE table_name ENGINE = InnoDB; InnoDB uses row level locks

 use mysqlcheck with --optimize and --databases combination. mysqlcheck is a command-line interface for administrators  mysqlcheck -uroo...

Depending on the size of the databases you have in mysql innodb the time it takes mysql to restart can be very slow.Some tricks that can sp...

You can also issue  SELECT  without a table. For example, you can  SELECT  an expression or evaluate a built-in function. mysql> sele...

Simple and smart reset mysql root password # /etc/init.d/mysql stop # mysqld_safe --skip-grant-tables & # mysql -u root mysql> ...

Using SELECT INTO, we can save the output of a select command into a file.Instead of displaying the output on the screen mysql> SELECT...

mysql can do that for you. Use mysql -H or mysql-X. mysql generates an HTML table from each query result set if you use the -H (or --html...