MariaDB Blog

January 13, 2012

MySQL Cluster training Jan 24 - 26 in DC

We still have a few seats left for our MySQL Cluster training in Washington DC January 24 - 26. If you're interested in learning about MySQL Cluster, the architecture, how to install it, administer it and troubleshoot it this is the course for you.

Read More

January 05, 2012

Demystifying identifier mapping

While tinkering with some things the other day, I noticed that if I create a table named "ñ", MySQL creates a .frm file with the name of @0x.frm. Similar "encoding" is done for any file that needs to be created (.MYI, .ibd, .TRG, .TRN, et cetera).

Read More

December 23, 2011

Learning to love the InnoDB Lock Monitor

A customer opened a support issue to ask about some help determining why they were seeing a lot of Lock Wait Timeouts. I asked them to enable the InnoDB Lock Monitor so that I could get a look at what was going on in their transactions and whether there might be some locks held longer than necessary.

Read More

December 14, 2011

Taming the EC2 API

I've been spending some time lately familiarizing myself with EC2, setting up some MySQL servers & clusters here and there, and doing some really basic configuration testing. One situation you'll run into when interacting with EC2 is that it gets unwieldy to use the AWS Management Console web interface for interacting with your instances.

Read More