(Todd Farmer) Quite some time ago, I published scripts to implement password policies for MySQL, and promised to show how to expose violations of that policy via MySQL Enterprise Monitor (MEM). That stalled somewhat with other objectives, but I want to revisit it now that MEM 3.0 is GA. If you hav

(Joe Abbate) In a comment to my previous post, David Fetter challenged me to “find a case for multisets. That we’re stuck with them doesn’t mean they’re useless.” My response was that I couldn’t help him because multisets (or bags) are not part of the relational model (which was the point of my post

(Miguel Angel Nieto) Recently Oracle announced several new features for the latest available development version of MySQL that is 5.7.2 at the time of writing this article. Most of them are performance and replication related that show us how incredible the new release will be.

(Baron Schwartz) I have followed the “Use the Index, Luke!” blog for a while. Today Marcus wrote that (I’ll paraphrase) MongoDB disgraces NoSQL the same way that MySQL disgraces SQL. I agree with a lot of this, actually, although I’m not sure I’d put it so strongly. People often like products for go

(Ike Walker) In yesterday’s post I was fairly prescriptive about how to do an upsert in MySQL. I’m aware that there are other ways to do an upsert in MySQL, but I intentionally emphasized INSERT … ON DUPLICATE KEY UPDATE over REPLACE because I think it’s almost always the better choice.

(Shlomi Noach) MySQL offers plugin API, with which you can add different types of plugins to the server. The API is roughly the same for all plugin types: you implement an init() function, a deinit(); you declare status variables and global variables associated with your plugin, and of course you im

(Peter Gulutzan) Here are examples comparing MySQL 5.6 against PostgreSQL 9.3 Core Distribution, where MySQL seems to comply with “standard SQL” more closely than PostgreSQL does.

(Ike Walker) The upsert (or merge) is a useful statement in SQL, but the syntax in MySQL is not self evident. If you search the MySQL manual for “upsert” you’ll probably get this page. If you search for “merge” you’ll probably get the page on index merge optimization or the merge storage engine. Non

(Narayanan Venkateswaran) Let us start by listing the scenarios in which we will need to perform shard maintenance. In addition to periodic maintenance operations the following situations might mandate performing shard maintenance.

(rsomla) Since introduction of PERFORMANCE_SCHEMA in MySQL Server, it is possible to trace what happens inside the server when it executes client queries. The client-side protocol tracing framework is a similar mechanism in the MySQL Client Library. It allows tracing communication of the client with