(Daniël van Eeden) In my previous post I talked about a transaction which blocked other transactions without doing anything. I talked about finding data from the blocking transaction using SYS and performance_schema.

(Sergei) I don’t think it’ll surprise anybody if I say that MariaDB or MySQL server knows a lot more about server system variables, then just their values.

(Daniël van Eeden) When I queried information_schema.innodb_trx (introduced in 5.1 with the InnoDB Plugin) I noticed there were a few transactions in LOCK WAIT state.

(Anders Karlsson) Now it’s time to get serious about replicating to MariaDB from Oracle, and we are real close now, right? What I needed was a means of keeping track of what happens in a transaction, such as a LOG table of some kind, and then an idea of applying this log to MariaDB when there is a C

(Pedro Gomes) The new addition to the MySQL planet, MySQL Group Replication is now on Labs Release for you to try it! It offers you update everywhere capabilities on any group of normal, out of the box, MySQL servers. Concurrent updates on a setup of several MySQL servers is now possible and this wi

(Krunal Bauskar) We have received a lot of requests from our user community regarding the ability to truncate UNDO tablespaces (‘truncate’ here means that the size of the tablespace is reset back to what it was when it was first created). We are happy to say that we’ve now been able to implement th

(Tiago J.) The multi master plugin for MySQL is here. MySQL Group Replication ensures virtually synchronous updates on any node in a group of MySQL servers, with conflict handling and failure detection. Distributed recovery is also in the package to ease the process of adding new nodes.

(Arjen Lentz) Friend and former colleague Roland Bouwman has written an excellent update on the GROUP BY implementation in MySQL.

(Ike Walker) As documented in the Reference Manual MySQL supports a maximum of 16 columns per index. That’s more than sufficient for most index use cases, but what about unique constraints? If I create a fact table with more than 16 dimension columns in my star schema, and then try to add an index t

(Anders Karlsson) In this third installment in this series, I’ll explain why the smart solution I described in the previous post actually wasn’t that good, and then I go on to explain how to fix it, and why that fix wasn’t such a smart thing after all. So, this was the design we ended with last time