(Chris Calender) In my previous post, Capturing Erroneous Queries with MySQL Proxy, I showed how to capture erroneous queries, along with relevant information, that one could not effectively obtain from the MySQL general query log. However, in that post, I simply output the information to the termin

(Peter Zaitsev) In my previous post I looked into how large table_cache actually can decrease performance. The “miss” path is getting more expensive very quickly as table cache growths so if you’re going to have high miss ratio anyway you’re better off with small table cache.

(Arnold Daniels) In the article ‘Versioning MySQL data‘, I showed the basics of implementing a revisioning system using trigger. As Jens Schauder already pointed out, often the data of a record is spread across multiple tables, like an invoice with multiple invoice lines. Having each invoice line ve

(Andrew Morgan) A MySQL Software preview is available which allows you to write Lua scripts to control replication on a statement-by-statement basis. Note that this is prototype functionality and is not supported but feedback on its usefulness would be gratefully received.The final version would all

(Chris) A lot of the time I have found that the only available backup taken from mysqldump contains all databases. This is ok but can be a head ache if you only need to restore one or some of the tables in one database. Below is a good way to restore only that which needs to be restored. I have […]

(Rob Gravelle) During the past few weeks, we’ve been getting better acquainted with XML support in MySQL. In the last article, we expanded the discussion to include a third-party tool called MySqlDump. We used it to produce an XML document that we queried using a stored procedure. Today, we’ll be fi

(Peter Zaitsev) There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state.

(Rob Gravelle) In the “Working with XML Data in MySQL” article, we explored some of MySQL’s XML capabilities, including the –xml command line option, which provides a means of formatting query output as XML, as well as a couple of new XML-specific functions that were introduced in MySQL 5.1.5. In t

(Peter Zaitsev) Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mo

(Chris) There have been times that I needed to restore one database from a dump file that contains all of the databases from the server. There are a few ways to accomplish this goal. One way would be to grep through the entire file for the table schema and insert statements. There are some problems