MySQL 5.6 @ Facebook development tree
Steaphan is a hero (well, everyone else on database engineering team are too) and he is driving efforts to publish MySQL 5.6 changes we’re making to the open. Now they’re on the github (yet not in production, we’re in active testing though with our workloads).
I recently wrote about Where are they now: MySQL Storage Engines and The MERGE storage engine: not dead, just resting…. or forgotten. Today, it’s the turn of the MEMORY storage engine – otherwise known as HEAP.
This is yet another piece of the MySQL server that sits largely unmaintained and unloved. The MySQL Manual even claims that it supports encryption… with the caveat of having to use the SQL functions for encryption/decryption rather than in the engine itself (so, basically, it supports encryption about as much as every other engine does).
The only …
[Read more]Stewart Smith recently questioned the current relevance of the MERGE storage engine, and it prompted me to finish a similar recent exercise I’ve been thinking about related to MySQL clients (UPDATE: and programs). This originally came up when I listed the contents of the MySQL bin directory:
D:\mysql-advanced-5.6.11-win32>dir bin\*.exe
Volume in drive D is Data
Volume Serial Number is 4015-B2FF
Directory of D:\mysql-advanced-5.6.11-win32\bin
04/05/2013 06:52
AM
123,392 echo.exe
04/05/2013 06:53
AM 4,696,064
innochecksum.exe
04/05/2013 06:54
AM 5,084,672
myisamchk.exe
…
Percona Server for MySQL version 5.1.68-14.6
Percona is glad to announce the release of Percona Server 5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is now the current stable release in the 5.1 series. All …
[Read more]I don’t get to say this often, but “I’m hiring” (at Percona):
I’ve been with Percona for about 5 years, so I can tell you: it’s probably the best company to work at: great pay, great benefits, great people, and truly driven by a desire to do right by customers and do good work. What more can you ask for? Of course, all these jobs are MySQL-related: Perl + MySQL, PHP + MySQL–maybe the UI/UX job less so, but still close enough.
Instant Innodb, by Matt Reid
This book does a good job of explaining the InnoDB internals. I have found particularly useful the section where it describe in detail all the server variables affecting InnoDB. Although these variables are also in the MySQL manual, some of them have never been explained to me as thoroughly as this book as done.
The title claims that it is a InnoDB reference. If is more than that, as the reference part id covered in three chapters. The rest of the book gives useful advice on maintenance, monitoring, and troubleshooting.
Join in our Finnish ritual, next Friday, at the closing of MySQL & Cloud Database Solutions Day after Percona Live!
Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.
Oracle:
Arup Nanda asks. Application Design is the only Reason for Deadlocks? Think Again.
It’s time that businesses took a good, hard look at the way they manage their cloned database environments, Kyle Opines.
Randolf touches the interesting topic of ASM AU Size And LMT AUTOALLOCATE.
…
[Read more]Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration.
Probably most readers of this blog know (or should know) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm.swappiness = 0″ to “/etc/sysctl.conf” and run “sysctl -p” and we are done.
Swappiness solves part of the swapping issue but not all. With Numa systems, the picture is more complex and swapping can occur because of a memory imbalance between the physical cpus, the sockets and not cores. Jeremy Cole explained this here and …
[Read more]New 5.6.11 out
