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.
A customer recently asked if I could help clarify the relationship between
rows_examined (in the slow query log) and the Handler% variables (in SHOW STATUS output) for a simple UNION.
I just wanted to let you all know that MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.53 has been released. Yoshinori Matsunobu discusses the release in much more detail here:
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).
The much-anticipated, long-awaited, and possibly irrelevant (Sphinx? Lucene?) InnoDB Fulltext finally makes a semi-official appearance in MySQL 5.6.4! MySQL 5.6.4, release December 20, 2011, is the newest "development milestone release" ("DMR") of MySQL 5.6
I've been spending some time looking through the new features of MariaDB 5.3, and one of the big items is an improved and configurable optimizer. Much of the functionality of the new optimizer is controlled using the
optimizer switch variable [http://kb.askmonty.org/en/mariadb-53-optimizer_switch].
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.
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.
Just in time for the holidays, SkySQL has published new white papers to keep you occupied while dealing with holiday travel delays, waiting for your turkey to roast, or hiding from your in-laws! Download them, today:
Come listen to us talk about MariaDB together with SpamExperts at Open Source Conference 2011 in Amsterdam.
We welcome everyone to Amsterdam where on Friday at 16:00 CET we will be giving a talk together with SpamExperts at the Open Source Conference 2011. The talk will be about MariaDB and how SpamExperts successfully overcame their problems with MySQL by migrating to MariaDB.