(Rob Gravelle) Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Each normal form is a progression of these rules as successive normal forms achieve a better database design than the previous ones did. The de facto standard, called T

(Chris Travers) Every time we see people look at PostgreSQL and MySQL on the internet it falls into a flame war fast. I think that a large part of the problem is that advocates of these databases look at the other database (and advocacy of the other database) through a specific lens and therefore a

(Shlomi Noach) This post exposes some of the internals, and the SQL behind QueryScript’s split. common_schema/QueryScript 1.1 introduces the split statement, which auto-breaks a “large” query (one which operates on large tables as a whole or without keys) into smaller queries, and executes them in s

(Stephane Combaudon) While doing a performance audit for a customer a few weeks ago, I tried to improve the response time of their top slow query according to pt-query-digest‘s report. This query was run very frequently and had very unstable performance: during the time data was collected, response

(Shlomi Noach) common_schema’s new split statement (see release announcement) auto-splits complex queries over large tables into smaller ones: instead of issuing one huge query, split breaks one’s query into smaller queries, each working on a different set of rows (a chunk).

(Todd Farmer) The recent MySQL 5.6.6 release includes a new password verification plugin. This is a great tool for enforcing passwords that meet certain strength thresholds. Quoting the options from the manual, there are three different criteria levels that can be applied:

(Ernie Souhrada) Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last week with an interesting MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something like this:

(Shlomi Noach) I’m very happy to announce the release of common_schema, version 1.1 (revision 300).

(scott_liu) My company has the need to synchronize data on a real time basis from MS SQL Server 2008 to a MySQL database. At first I thought that it could be done with table triggers after setting up a linked server to a MySQL table, and then it would not be a big problem.

(Michael McLaughlin) While staging to rebuild the Oracle DB Console (Oracle Enterprise Manager – OEM), I needed to check something in my MySQL instance and ran into the following error after changing the machine’s hostname for that OEM test. The message basically says that MySQL Workbench can’t reso