June 18, 2013

Post: Is DNS the Achilles heel in your MySQL installation?

…? To disable two DNS lookups per authentication attempt, you just need to set skip_name_resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql… able to log in after you disable DNS resolution. For more information on how and why MySQL does both a forward and reverse…

Post: Updated msl (microslow) patch, installation walk-through!

… the slow log. Originally MySQL database offered a second time resolution and also a 2 second… If you don’t specify it in my.cnf file, the remaining part of the configuration…disabled for the replication thread. Can be changed at run time with both SET SESSION and SET GLOBAL. log_slow_verbosity=name