(aadant) MySQL provides commands to see the overall index size versus the data size.

(Ike Walker) Recently I checked a MySQL database for duplicate indexes using common_schema, and I want to share my approach. Before I get into the details, I want to define what I mean by duplicate indexes. In the past I’ve used the terms duplicate index and redundant index somewhat interchangeably,

(Mark Callaghan) What is a modern database? We have some terms that wander between marketing and technical descriptions – NewSQL, NoSQL. We have much needed work on write-optimized database algorithms – Tokutek, LevelDB, RocksDB, HBase, Cassandra.

(Noel Herrick) Whenever I have a problem query in MySQL, I say to myself, I know, I’ll use Explain Plan. Now I have two problems. I run the explain plan, but then I have to look up all the cryptic terms and read through the documentation to know what in the world is going on. Well, over the weekend,

(Stephane Combaudon) When we are hired for a MySQL performance audit, we are expected to review the MySQL configuration and to suggest improvements. Many people are surprised because in most cases, we only suggest to change a few settings even though hundreds of options are available. The goal of th

(Michael Paquier) The new foreign data wrapper available with PostgreSQL core called postgres_fdw (to basically query foreign Postgres servers and fetch back data locally) makes possible a couple of interesting things with a little bit of imagination.

(Noel Herrick) In the previous article, we learned how you can design your database schema so that many customers can share one database and one set of tables. The examples I used were fairly simple: they consisted of single tables or simple hierarchies like the order and line item tables. In those

(Ian Barwick) A recent thread on -general sparked my interest as I’m working with a large and heterogeneous code base recently converted from Oracle which makes heavy use of TO_DATE(), and it seems this function has a couple of gotchas worthy of consideration.

(Todd Farmer) Last Wednesday, I spoke at the San Francisco MySQL Meetup on the topic of changes coming in MySQL 5.7 (and later). We actually went through two different slide decks; the first on features being considered for deprecation in MySQL 5.7 (or later), and the second set providing a brief o

(Leo Hsu and Regina Obe) I’ve read from many that PL/V8 mathematic operations are generally faster than what you get with SQL functions and PL/pgsql functions. One area where I thought this speed would be really useful was for writing Map Algebra call-back functions.