(Andriy Lysyuk) Human mistakes are inevitable. Wrong “DROP DATABASE” or “DROP TABLE” may destroy critical data on the MySQL server. Backups would help however they’re not always available. This situation is frightening but not hopeless. In many cases it is possible to recover almost all the data tha

(Keith Murphy) With the majority of the clients where I perform server audits I find an issue where both the host server and MySQL are not configured with anything other than the default values for the open files limit.

(Walter Heck) Anemometer is a MySQL slow query monitoring tool. It’s used to analyze/visualize slow query log, collected from MySQL instance to identify the problematic queries.

(Ike Walker) If you are using FULLTEXT indexes in MySQL and plan to switch from MyISAM to InnoDB then you should review the reference manual section on Fine-Tuning MySQL Full-Text Search to see what configuration changes may be required.

(Brian Moon) I have found myself using UNION in MySQL more and more lately. In this example, I am using it to speed up queries that are using IN clauses. MySQL handles the IN clause like a big OR operation. Recently, I created what looks like a very crazy query using UNION, that in fact helped our M

(Ike Walker) As I prepare to convert some MySQL tables with FULLTEXT indexes from MyISAM to InnoDB I want to verify that running a standard production query set against the tables will return the same results with InnoDB that it did with MyISAM.

(Matthew Boehm) Yay! My first blog post! As long as at least 1 person finds it useful, I’ve done my job. 😉 Recently, one of my long-term clients was noticing that while their INSERTs were succeeding, a particular column counter was not incrementing.

(Aleksandr Kuzminsky) Managing many hosts is quite challenging task. There are many tools to solve the problem. My favorite is pdsh.

(Abdel-Mawla Gharieb) In previous posts, I was talking about how to set up MySQL replication, Classic Replication (based on binary logs information) and Transaction-based Replication (based on GTID). In this article I’ll summarize how to troubleshoot MySQL replication for the most common issues we m

(Daniel van Eeden) I was recently asked about if MySQL Enterprise Backup would be able to restore single databases.