(Rob Gravelle) In my The Wonderful (and not so Wonderful) Things about MySQL Triggers article, we saw how triggers can be useful in some contexts, and yet inferior to stored procedures in others. Today’s follow-up will demonstrate how stored procedures can be used in conjunction with triggers to en

(Shlomi Noach) If you use RANGE (or RANGE COLUMNS) partitioning, and in particular when partitioning by date/time, then your are subject to the following questions: how and when do you create the “next” partition? How and when do you drop your older partitions?

(Cédric PEINTRE) For the first time since the beginning of my long long career, I decided today to use an advice tool to check my MySQL configuration.

(Simon Greener) This article shows a Morton key function for PostGis and how to use it.

(Jørgen Løland) While the index merge access types certainly are useful for a number of queries, there has been some frustration expressed both from customers and the community about how it…

(Marko Mäkelä) This is the low-level view of data dictionary language (DDL) operations in the InnoDB storage engine in MySQL 5.6.

(Baron Schwartz) MySQL 5.6 will have “checksums in the binary log,” which can be variously described, but one phrase I’ve heard a few times is, loosely, that it helps ensure replication integrity.

(Calvin Sun) Ever since its first release, we are continuing consolidating and developing InnoDB Full-Text Search feature. There is one recent improvement that worth blogging about. It is an effort with MySQL Optimizer team that simplifies some common queries’ Query Plans and dramatically shorted th

(Miguel Angel Nieto) In the last blog post I wrote about how to log deadlock errors using Percona Toolkit. Foreign key errors have the same problems. InnoDB only logs the last error in the output of SHOW ENGINE INNODB STATUS, so we need another similar tool in order to have historical data.

(Rob Gravelle) There are many kinds of triggers. Some triggers set off addictive behavior. Others are components of weapons like guns. But perhaps the most dangerous triggers of all are those that are found within relational databases. While useful in some contexts, triggers are not the best opti