Patches/Sources
For MySQL 5.0 we do two builds, ourdelta (standard) and ourdelta-sail (bleeding edge) where the latter contains newer patches that may not (yet) be stable. The dN indicator (e.g., d7) shows from which patchset build the feature is included. For MariaDB 5.1, there’s only an ourdelta build, Monty intends 5.2 to be the more bleeding edge tree.
If you see a certain patch not yet available for a version of MySQL, that means you have an opportunity to contribute: you port it, we build it! See the OurDelta project on Launchpad, where you can also find the individual patches and other support files we use. Everything we do is all open and public. You can join the OurDelta-developers team which also has a mailing list, and bug tracking.
We provide proper repositories so you can simply add us to your favourite package manager! If you need to build from source (for instance, for a platform we don’t handle), we also provide source tarballs incorporating our patches (we generate this once per build and feed it into the build systems), and generic binary tarballs for Linux. The repositories also contain source packages wrapped in the format appropriate for each distro.
| Patch/Plugin | MySQL 5.0 | MariaDB 5.1 | MariaDB 5.2 | |
|---|---|---|---|---|
| SHOW PATCHES | d6 | - | - | |
| Allow redirect output of error.log to syslog-ng | d6 | Debian, Ubuntu | - | |
| Extended statistics in slow.log | d6 | MariaDB 5.1.38 | - | |
| Extended InnoDB statistics in slow.log | d6 | coming | - | |
| SHOW USER|CLIENT|TABLE|INDEX_STATISTICS (v1) | (see v2) | - | - | |
| SHOW USER|CLIENT|TABLE|INDEX_STATISTICS (v2)
INFORMATION_SCHEMA.*_STATISTICS |
d6 | coming | - | |
| Mirrored Binlog | d7-d8 | - | - | |
| Fast Master Promotion | d7 | - | - | |
| KILL IF IDLE | d7 | - | - | |
| InnoDB Freeze | d7-d8 | - | - | |
| Milliseconds in PROCESSLIST | (bugs) | MariaDB 5.1.38 | - | |
| Add locks held, remove locked records in SHOW INNODB STATUS | d6 | in XtraDB | - | |
| show innodb buffer pool content | d6 | in XtraDB | - | |
| InnoDB control insert buffer and flushing | d6-Sail,d9 | in XtraDB | - | |
| InnoDB control count of IO threads | d6-Sail,d9 | in XtraDB | - | |
| InnoDB fix buffer pool scalability | d6-Sail,d9 | in XtraDB | - | |
| Fix of InnoDB r/w locks | d7-Sail,d9 | in XtraDB | - | |
| Adaptive flush of InnoDB buffer pool | d7-Sail,d9 | in XtraDB | - | |
| 3rd party storage engines | ||||
| XtraDB (enhanced InnoDB) storage engine plug-in | - | MariaDB 5.1.38 | - | |
| Sphinx storage engine | d6 | - | - | |
| PBXT storage engine | - | MariaDB 5.1.38 | - | |
| FederatedX storage engine | - | MariaDB 5.1.39 | - | |
| OQGRAPH computation engine | d10-Sail | MariaDB 5.1.42 | - | |
Build engineering and infrastructure by Open Query, excellent collaboration with Monty Program Ab, plus numerous useful contributions by Percona, Proven Scaling, PrimeBase Technologies, Sphinx Technologies, Mark Callaghan, Google, and others. Thanks everybody!
April 9th, 2009 at 6:50 pm
Hi! First of all congratulations to your great work!
Is there any chance to include in your packages the Regular Expressions UDF for mysql? (http://udf-regexp.php-baustelle.de/trac/wiki/WikiStart)It adds functions for update data with regexp.
it would be really helpful for me, and possible for most people here as well.
Thanks!
April 23rd, 2009 at 5:58 pm
With MySQL 5.4 released and Mark Callaghan’s latest IO patches, is there going to be a new d9 build soon?
October 27th, 2009 at 6:02 pm
MySQL 5.4 is very much in Beta, I wouldn’t advise using it in production environments yet. No point wasting time patching it to d9 until it’s stable and worth it.
October 31st, 2009 at 2:55 am
LD, For 5.1 we build MariaDB + XtraDB, so it already has a number of IO patches. Some are different from Mark’s.
October 31st, 2009 at 2:56 am
Handrus, thanks!
Include UDFs… that’s a great idea – just like engines (even with 5.1 plugins) it’s just a hassle to have to compile them yourself. Would you care to help with this?
November 17th, 2009 at 11:21 pm
I think it should be possible to make use of the build system in 5.1 to build UDFs by simply declaring it as aa dynamic-only plugin to be built. That would mean that no major surgery of the build framework is required.
April 13th, 2010 at 1:08 pm
Hello,
How about ‘SHOW USER STATISTICS’ for MariaDB5.1?
Does it simply stay in the queue, or are there any fundamental difficulties which make it hard?
We would like to upgrade from MySQL 5.0 to MariaDB 5.1
but we relay heavily on SHOW USER_STATISTICS -> CPU_time for performance/abuse monitoring on our webhosting platform.
thanks
April 8th, 2011 at 10:12 am
What’s the best Graph Database to use with PHP + MySQL?…
It depends what you mean by best – Neo4j is very good, but if you want something easier to use then the sail builds of MySQL from Ourdelta (http://ourdelta.org/patches) include the open source version of OQGRAPH (http://openquery.com/products/graph-eng…