Category Archives: Generic
In end of May I told about the numbering plans for the next version of MariaDB in the blog post What comes in between MariaDB now and MySQL 5.6?. We received quite a lot of feedback and criticism on the idea of calling the next version MariaDB 10.0. Here is a little more information about why it makes sense to call the next version 10.0.
This is not news for most of you. MariaDB is not just a set of patches applied on top of MySQL. MariaDB includes features which are similar to the corresponding features in MySQL, but the implementations differ, like for example the thread pool, microsecond support and query annotations in RBR binlog. …
Like others we were not satisfied with the fix for a bug in MySQL which caused the query cache and partitioning to not work reliably together. The bug, in simple terms, was that if the query cache was enabled and you used partitioned tables and if a partitioned table was using a transactional engine like InnoDB or XtraDB, the query cache could, under certain circumstances, return incorrect results.
Returning incorrect results is a definite, high-priority bug. However, the upstream fix was to disable all caching of queries from partitioned tables. We wanted a better solution because the query cache can be very useful and beneficial for partitioned tables, just like it is useful and beneficial for non-partitioned tables. …
A screencast about the MariaDB release process.
httpv://www.youtube.com/watch?v=aOsddictJU4
(I recommend watching it in full screen 720p, so you can see the details.)
Some links mentioned in the video:
- The MariaDB homepage
- The AskMonty Knowledgebase
- Southeast Linux Fest
- Buildbot
- The MariaDB Buildbot
- The MariaDB Tools project on Launchpad
- The MariaDB Downloads page
- The maria-discuss mailing list on Launchpad
- MariaDB on Twitter
- MariaDB on Facebook
- MariaDB on Google+
…
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. This tool:
- Helps unmangle explains (both vertical and tabular format)
- Displays explains in an easy-to-read format.
- Highlights and provides explanations for some terms.
…
A screencast demonstrating the MariaDB Windows installer.
httpv://www.youtube.com/watch?v=yQPnCxJMOWI
(I recommend watching it in full screen 720p, so you can see the details.)
Some links:
- The MariaDB homepage
- The AskMonty Knowledgebase
- The MariaDB Downloads page
- Installing MariaDB on Windows documentation
- The HeidiSQL homepage
Acknowledgments:
A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast. …
Continue reading “Screencast: Installing MariaDB on Windows”
Here’s another MariaDB screencast, this time highlighting some of the GIS functionality in MariaDB.
httpv://www.youtube.com/watch?v=LpDm_8L1oyI
(I recommend watching it in full screen 720p, so you can see the details.)
Some links and notes:
- GIS Functionality in MariaDB
- Data used in this screencast
- OpenJUMP
- JUMP database plugin
- To use the database plugin, unpack it into the OpenJUMP lib/ext/ directory (not a subdirectory, but directly into that directory). Also place the mysql-connector-java.jar into the lib/ext/ directory.
Acknowledgments:
A big thanks to Alexey Botchkov, MariaDB’s GIS guru, for the example data and help with the screencast. …
Instead of the usual text-heavy blog posts that appear here, I thought it would be fun to mix things up and do a screencast showing exactly how easy it is to upgrade MySQL to MariaDB:
httpv://www.youtube.com/watch?v=rF7wChx0uzQ
Some notes:
- The laptop I’m using had MySQL 5.1.55 installed with one database (apart from the system database). Installing MariaDB does not impact existing data in any way and once the install completed I had instant access to my data.
- As part of the install you are given the option to set a new password for the root user.
…
The MySQL community has something new on their radar. First up, it looks like MySQL is now part of Oracle Software Security Assurance, and this is something all MySQL users should be happy about. Next, it is worth noting that MySQL is now part of the Oracle Critical Patch Update (Oracle CPU), as the MySQL product line has made it into its first Oracle CPU advisory for January 2012.
As part of the MySQL community, CPU’s are new to us — they are released on the Tuesday closest to the 17th day of January, April, July and October.
…
Continue reading “Oracle’s 27 MySQL security fixes and MariaDB”