I found time to continue my previous work on group commit for the binary log in MariaDB. In current code, a (group) commit to InnoDB does not less than three fsync() calls: Once during InnoDB prepare, to make sure we can recover the transaction in InnoDB if we crash after writing it to the binlog.… Continue reading Even faster group commit!
Tag: mysql
Tale of a bug
This is a tale of the bug lp:798213. The bug report has the initial report, and a summary of the real problem obtained after detailed analysis, but it does not describe the processes of getting from the former to the latter. I thought it would be interesting to document this, as the analysis of this… Continue reading Tale of a bug
Benchmarking thread scheduling in group commit, part 2
I got access to our 12-core Intel server, so I was able to do some better benchmarks to test the different group commit thread scheduling methods: This graph shows queries-per-second as a function of number of parallel connections, for three test runs: Baseline MariaDB, without group commit. MariaDB with group commit, using the simple thread… Continue reading Benchmarking thread scheduling in group commit, part 2
Benchmarking thread scheduling in group commit
The best part of the recent MariaDB meeting in Lisbon for me was that I got some good feedback on my group commit work. This has been waiting in the review queue for quite some time now. One comment I got revolve around an optimisation in the implementation related to how threads are scheduled. A… Continue reading Benchmarking thread scheduling in group commit
My presentation from OpenSourceDays2011
Here are the slides from my talk at Open Source Days 2011 on Saturday. The talk was about MariaDB and other parts of the MySQL development community outside of MySQL@Oracle. For me, the most memorable part of the conference was the talk by Noirin Shirley titled Open Source: Saving the World. Noirin described the Open… Continue reading My presentation from OpenSourceDays2011
Speaking at OpenSourceDays2011
Again this year, I will be speaking about MariaDB and stuff at the OpenSourceDays2011 conference in Copenhagen, Denmark. The conference will take place on Saturday March 5, that’s just over a week from now! The program is ready and my talk is scheduled for the afternoon at 15:30. Hope to meet a lot of people… Continue reading Speaking at OpenSourceDays2011
MariaDB replication feature preview released
I am pleased to announce the availability of the MariaDB 5.2 feature preview release. Find the details and download links on the knowledgebase. There has been quite good interest in the replication work I have been doing around MariaDB, and I wanted a way to make it easy for people to use, experiment with, and… Continue reading MariaDB replication feature preview released
Christmas @ MariaDB
The Danish “julehjerte” is apparently a Danish/Northern Europe Christmas tradition (at least according to Wikipedia). But hopefully people outside this region will also be able to enjoy this variant: I have been doing “julehjerter” ever since I was a small kid, and every Christmas try to do something different with it. As seen above, this… Continue reading Christmas @ MariaDB
The future of replication revealed in Istanbul
A very good meeting in Istanbul is drawing to an end. People from Monty Program, Facebook, Galera, Percona, SkySQL, and other parts of the community are meeting with one foot on the European continent and another in Asia to discuss all things MariaDB and MySQL and experience the mystery of the Orient. At the meeting… Continue reading The future of replication revealed in Istanbul
Dynamic linking costs two cycles
It turns out that the overhead of dynamic linking on Linux amd64 is 2 CPU cycles per cross-module call. I usually take forever to get to the point in my writing, so I thought I would change this for once 🙂 In MySQL, there has been a historical tendency to favour static linking, inpart because… Continue reading Dynamic linking costs two cycles