The explain statement can be an important tool for understanding how a query is being executed and what you can do to make it run better. Although the output of EXPLAIN is relatively straightforward it can be confusing to inexperienced users or can be mangled by terminal wrapping. To help with these problems as well as provide a pastebin for MariaDB developers to share explains during development we created The MariaDB/MySQL Explain Analyzer.
The good news is that we have just released plenty of MariaDB & MySQL training dates covering the summer months and even into October across the globe.
I came across an interesting error reported on #mysql the other day. When I went through it with the reporter it looks like we uncovered up to two bugs in InnoDB (or rather XtraDB as it was Percona Server). I thought it might be useful to go through the error message, including the stack trace, to show that you don't need to be a developer to track down some useful information. If you look at http://pastie.org/3836611 you'll see the error message.
The SkySQL & MariaDB: Solutions Day for the MySQL Database (the first of its kind) took place last Friday (April 13th) in Santa Clara, and we’d like to thank everyone who attended, participated and generally helped make it the successful day that it was!
The SkySQL booth ready for the stampede of visitors that stopped by each day. We hope it was as productive and fun for all of you as it was for us at SkySQL! We started out the week at Percona Live, which was an excellent conference. Thanks to the Percona folks for making this a great get-together for the MySQL community. Excellent job, guys!
We are pleased to announce the immediate availability of MariaDB 5.5.23. This stable (GA) release incorporates MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes.
We hope you all are having a productive and fun time at Percona Live! We at SkySQL sure are. In fact, we have another announcement to make here at the show. We’re happy to share that our already excellent service and support will also include PalominoDB's operational excellence, 24x7 on-call support and access to PalominoDB’s skilled team of DBAs.
The second day of the Percona Live MySQL Conference and Expo is off to a great start! We’re excited here in Santa Clara to share the news that we’re teaming up with hastexo to further enhance expert high-availability knowledge for our professional services customers.
We are pleased to announce the immediate availability of MariaDB 5.3.6. This stable (GA) release incorporates MySQL 5.1.62, some performance improvements, and several bug fixes. Most importantly, MariaDB 5.3.6 includes a fix for a bug which, under certain rare circumstances, allowed a user to connect with an invalid password.
We are pleased to announce the immediate availability of MariaDB 5.1.62 andMariaDB 5.2.12. Both of these stable (GA) releases incorporate MySQL 5.1.62 and several bug fixes. Most importantly, MariaDB 5.1.62 and 5.2.12 include a fix for a bug that under certain rare circumstances allowed a user to connect with an invalid password.