So, I recently ran into one of those situations where a customer complains that his MySQL database is slow, and it worked great until about two weeks ago. The first thing I look at in these situations is not the queries or any code, but the indexes. Once I determined that the indexes were almost non

(Danil Zburivsky) Quite often we need to perform a so-called MySQL instance audit. This common DBA procedure should give you a general view of the MySQL environment. You may be interested in a basic understanding of what kind of operation MySQL performs, how much memory does it use, or how well does

(Baron Schwartz) The trouble with slave lag is that you often can’t see it coming. Especially if the slave’s load is pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from one that’s at 5% of its capacity.

(Raj Thukral) Do you have a master-slave MySQL set up? Ever do DDL changes on the master? You may be hit with a serious data integrity bug. Read on.

(Gregory J. Haase) Im in the process of converting some very large data tables to partitioned tables. By In the process I mean scripts are running as we speak and Im monitoring whats going on.

(Nicklas Westerlund) Yesterday evening, a friend of mine had some issues with installing DBD::mysql, and asked if I had encountered the same issue. The problem, as the output from make test showed, was that certain symbols was missing:

(Adrian Mato Gondelle) Hi folks! In this tutorial We will learn how to create a database for a complete and professional forums system. I want to present you an awasome utility for designing and creating databases: MySQL Workbench.

(Giuseppe Maxia) Two of the most common tasks for database administrators are cleaning the process list from unresponsive queries and remove idle connections that are filling the connection pool. Both tasks are related to poor usage of the database. In a perfect world, users would only run queries

(Xaprb) I have recently added some features to Maatkits mk-table-checksum tool that can make it easy to checksum the relevant parts of your data more frequently (i.e. continually, but not continuously). This in turn makes it possible for you to find out much sooner if a slave becomes different from

(Keith Murphy) Over the weekend, I worked on a clients two computers, trying to get a slave in sync with the master. It was during this time that I began thinking about: a) how this never should have happened in the first place. b) how slave drift could be kept from happening. c) how this is pr