Although, hosting the event on a weekend, which is an inconvenience to those who have family, and ignoring the fact that it's Oracle's third MySQL Connect event, I would have to say that this year's Oracle MySQL Connect conference was the best one yet.
This past year, I have been mostly heads-down working at +LinkedIn so I haven't been paying close attention to what Oracle has been doing for +
Today, while at Oracle's MySQL Connect conference in San Francisco, I had the opportunity to talk to Gerardo Narvaja and that inspired me to try using OQGraphv3 and TokuDB. Of course, the first challenge is to compile it on my MacBook which has MacOS Lion 10.7. I installed the Apple's latest XCode Command Line tools and eventually compiled a MariaDB which had both TokuDB and OQGraph available
One of our customers sometimes observed lots of simple insertions taking far longer than expected to complete. Usually these insertions completed in milliseconds, but the insertions sometimes were taking hundreds of seconds. These stalls indicated the existence of a serialization bug in the Fractal Tree index software, so the hunt was on. We found that these stalls occurred when a big transaction was committing and the Fractal Tree index software was taking a checkpoint. This problem was fixed in both TokuDB 7.0.3 and TokuMX 1.0.3. Please read on as we describe some details about this bug and how we fixed it. We describe some of the relevant Fractal Tree index algorithms first.
What is a Big Transaction?
Each transaction builds a rollback log as it performs Fractal Tree index operations. The rollback log is maintained in memory until it gets too big and is spilled to the TokuDB rollback file. We define a small …
[Read more]
MariaDB has a feature called Dynamic Columns which is not
in MySQL, and this feature requires some explanation. It is used
for example by the Cassandra Storage Engine, which is also unique
to MariaDB, and as this is a schema-less database, which means we
need a way to handle the fact that one one end MariaDB has a
fixed set of columns defined by the schema, and on the other end,
Cassandra provides any kind of attribute that the developer feels
he wants to have for a particular "row" (which is a row in
MariaDB but is not called a row in Cassandra).
But ignoring the Cassandra engine for a while, let's look at what
us mere mortals, brought up on mothers milk, SQL and Relational
Theory under the watching eyes of E.F. Codd, can use this for,
and fact is that it can be quite useful. All in all, what Dynamic
Columns provide here is a means of adding non-schema data to a
row in a structured way, you know where you used to emulate an …
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.33. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the AskMonty Knowledgebase for general information about the MariaDB 5.5 series.
[Read more]Just mentioning it here because hard work deserves to be recognised and mentioned: Andrew McDonnell is doing an awesomely good job of testing, understanding and fixing bugs in OQGraph... which is no mean feat because the core of the code is based on the Boost Graph Library which isn't a trivial C++ library.
By going to the download section of SkySQL website some users have noticed “MariaDB Audit Plugin”. This auditing feature for MySQL has been requested by more and more customers. Legal constraints make it mandatory for more and more companies to keep logging information about database access and activity.
It is very important for the MySQL [...]
Spider storage engine is bundled in MariaDB 10.0.4.
https://downloads.mariadb.org/mariadb/10.0.4/
After this release, you can use Spider immediately by installing
MariaDB.
For using Spider after installing MariaDB, please execute
"install_spider.sql"
which under share directory.
MariaDB 10.0.4 is still alpha version, so please don't use on
production systems.
Currently, MariaDB bundled Spider has the following difference
than MySQL bundled Spider.
New features
batched key access
This is a feature for join performance
improvement.
You can use BKA by setting
join_cache_level to 5 and more.
assisted discovery
This is a feature for taking table
structure from data node.
…
One thing you might have missed from the MariaDB 10.0.4 Alpha release announcement is that SPIDER is finally in-tree, inside MariaDB. I’ve been watching the SPIDER engine for quite some years and fondly remember the time when Kentoku Shiba dressed up as spiderman at a MySQL Conference.
There are many factors that plays to an engines success. Distribution is one of them. Having a company backing it with services is another, so it is with great pleasure that I also show you Spiral Arms Ltd by Kentoku and Goto.
Overall, a good time to celebrate and I’m very happy for Kentoku and Goto. Now to promote its use. …
[Read more]There was some suggestion after my previous post (Who works on MariaDB and MySQL?) that I look at MariaDB 10.0 – so I have. My working was very simple, in a current MariaDB 10.0 BZR tree (somewhat beyond 10.0.3), I ran the following command:
bzr log -n0 -rtag:mariadb-10.0.0..|egrep '(author|committer): '| \ sed -e 's/^\s*//; s/committer: //; s/author: //'| \ sort -u|grep -iv oracle
MariaDB foundation/MontyProgram/SkySQL: