(Yuli) There is not magic solution to count table contents especially if you have a client that has a table with 40+ million records and you need to do the filtering using the ‘OR’ SQL statement.

(Ronald Bradford) When evaluating a MySQL system one of the first things to look at is the MySQL error log. This is defined by the log[_-]error variable in the MySQL Configuration file. Generally found like:

(Peter Zaitsev) As the part of analyzing surprising MySQL 5.5 vs 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and 5.6.10 to the different tables and ran the query:

(Tony Darnell) In my last few posts, I wrote about “How to install MySQL replication using GTID’s” (Part One, Part Two). In this post, I will show you how to install MySQL 5.6 and set up replication between two MySQL servers the “old fashioned way” using the binary log and binary log position.

(Shlomi Noach) Had a case recently where I had to merge data from two identically structured tables containing nearly identical data.

(Giuseppe Maxia) MySQL 5.6 is probably the version of MySQL with the biggest bundle of new features. You may want to try it soon, since it’s now released as GA, and I would like to offer some practical experience on how to use some of the advanced features.

(Guilhem Bichot) There are great features in MySQL 5.6. But not only that. We also tried to correct some old behaviors and limitations which, over the years, have shown to irritate our Community. The behavior of TIMESTAMP columns is one of them.

(Shlomi Noach) This is a sneak peek video introduction/preview of an in-development free and open source server side debugger & debugging API for MySQL stored routines.

(Michael Paquier) pageinspect is an extension module of PostgreSQL core allowing to have a look at the contents of relations (index or table) in the database at a low level. In the case of PostgreSQL, tuples of a table are stored in blocks of data whose size can be changed with –with-blocksize at co

(Shinguz) From time to time some maintenance work on the MySQL database has to be done. During the maintenance window we do not want to have application traffic on the database.