Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 24

Displaying posts with tag: Maria (reset)

Ghosts of MySQL Past Part 5: The Era of Acquisitions
+1 Vote Up -0Vote Down

This week I’ve been writing based on my linux.conf.au 2014 talk, which you can watch the recording of.

Also see Part 1, Part 2, Part 3 and Part 4. My feed feel off Planet MySQL

  [Read more...]
Where are they now: MySQL Storage Engines
+3 Vote Up -0Vote Down

There was once a big hooplah about the MySQL Storage Engine Architecture and how it was easy to just slot in some other method of storage instead of the provided ones. Over the years I’ve repeatedly mentioned how this

  [Read more...]
Create MariaDB Windows Service
+3 Vote Up -0Vote Down

I’d had some difficulty manually creating my own windows service for MariaDB (worked fine from the installer), but it was due to the way I was creating it, so I wanted to share the proper approach:

Old Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\""
DisplayName= "Maria55" start= "auto"

New Way:

sc create "maria55" binpath= "\"C:/Program Files/MySQL/MariaDB 5.5/bin/mysqld\"
\"--defaults-file=C:/Program Files/MySQL/MariaDB 5.5/data/my.ini\" maria55"
DisplayName= "Maria55" start= "auto"

The key is adding the name, maria55, after the –defaults-file=.. option, but still within the “” that belong to “binpath”.

This extra parameter exists so that mysqld knows whether or not it was started as a service or

  [Read more...]
SkySQL Raises $4 Million in Series A Round Funding
+2 Vote Up -1Vote Down

I am very pleased to say that earlier today, SkySQL announced it has raised $4 Million in Series A Round Funding.

Let me post the main part of the press release here:

SAN JOSE – April 18, 2012SkySQL, the first choice in affordable database solutions for the MySQL® and MariaDB® databases in the enterprise and the cloud, today announces that the company has raised $4 million in Series A funding from a number of investors, including OnCorps, an elite peer-based community of veteran technology investors and advisors committed to bringing better, cost-disruptive technologies into the mainstream. Also funding the round are European investors including Finnish Industry Investment Ltd., Spintop Ventures and Open Ocean Capital.

SkySQL will primarily use the investment to fund growth in its new product development, including adding

  [Read more...]
MariaDB 5.5 is now GA
+4 Vote Up -0Vote Down

Well, as you or may not have heard, MariaDB 5.5 (5.5.23) was declared GA last week!

It was only about 6-ish weeks ago that MariaDB 5.5 had been released as alpha, so the fact it’s already GA is excellent news for all MariaDB users (and MySQL 5.5 users looking to migrate).

Some of the 5.5 enhancements include:

  • Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
  • Non-blocking client API Library (MWL#192)
  • @@skip_replication option (MWL#234)
  • SphinxSE updated to version 2.0.4.
  • “extended keys” support for XtraDB and InnoDB
  • New INSTALL SONAME statement
  • New LIMIT ROWS EXAMINED optimization.
  • mysql_real_connect() Changes
    In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect() removes from the MYSQL object
  [Read more...]
MariaDB 5.3 is now GA
+4 Vote Up -0Vote Down

This is another, in-case-you-missed-it, but it is definitely worth mentioning again:

MariaDB 5.3 is now GA

So, if you’re using MariaDB 5.1 or 5.2, I’d definitely recommend upgrading to the new MariaDB 5.3.

Also, if you’re a Windows user using MySQL 5.1, I’d highly consider making the switch to MariaDB 5.3 due to all of the Windows-specific improvements in it.

MariaDB 5.3 Enhancements:

  • Subquery optimizations
  • Semi-join subquery optimizations
  • Non-semi-join optimizations
  • Subquery Cache
  • Subquery Optimizations Map
  • Optimizations for derived tables and views
  • Disk access optimization
  • Join optimizations
  • Index Merge improvements
  • Optimizer control
  • NoSQL-style interfaces
  • Group commit for the binary log
  • Replication and binary logging enhancements
  • Microsecond support for NOW() and timestamp, time, and
  [Read more...]
MariaDB 5.5 has been Released
+4 Vote Up -0Vote Down

In case you didn’t notice it last week, MariaDB 5.5 (5.5.20, specifically) has been released.

It’s a release I’ve been looking forward to for a while now, so I’m very excited that it’s now available!

Note that it is currently ‘alpha’ since it is the very first release of MariaDB 5.5. However, it is not your typical new ‘alpha’, so I would expect it to be GA in the not-so-distant future (please don’t quote me on this though, as I have no idea of the true time table – but the goal is for the next 5.5 release to be ‘beta’).

You can download MariaDB 5.5 from the following location:


There are also more details on this

  [Read more...]
Building MariaDB 5.3 on Windows
+2 Vote Up -0Vote Down

I just wanted to share my steps for building MariaDB 5.3 on Windows. (Note, this is not much different than the instructions Wlad posted here).

But, things are not always so smooth, and of course I ran into a couple small issues, so I wanted to share my outputs plus those issues and their solutions (once again many thanks go to Wlad!) for those out there who might encounter the same.

Here are the steps to build:

  • Download MariaDB 5.3 and extracted to C:\mariadb-5.3
  • cd C:\mariadb-5.3
  • mkdir bld
  • cd bld
  • cmake .. -G "Visual Studio 9 2008"
  • cmake --build . --config relwithdebinfo --target package

    * By making a sub-dir named ‘bld’ and cd’ing into it, you’ll keep

  •   [Read more...]
    Building MariaDB 5.1 on Windows
    +2 Vote Up -0Vote Down

    Recently, I found myself needing MariaDB 5.1.60 for Windows for some testing purposes. Therefore, I needed to build it from source. I ended up using what I’d call a “blend” of the commands listed in this “how-to” and the readme file INSTALL-WIN-SOURCE, so I thought I’d post those steps.

  • Download 5.1.60 MariaDB source from here.
  • cd C:\mariadb-5.1
  • win\configure.js
  • cmake .
  • VS: File -> Open -> Solution -> MySql.sln
  • VS: Build -> Build Solution
  • VS: Right-click “PACKAGE” -> Build (in “Solution Explorer” View)

    That’s it.

    Let’s fire it up:

    MariaDB> select version();
    | version()            |
  •   [Read more...]
    InnoDB Plugin Version History
    +4 Vote Up -0Vote Down

    I’m often wondering what version of the InnoDB Plugin is included with which version of MySQL (or MariaDB). The MySQL changelogs used to denote which version of the InnoDB plugin was included with that particular release of MySQL, but sadly this is no longer the case.

    Therefore I’ve compiled a comprehensive list which contains all of this info, and then some (and note all InnoDB Plugin changelog links are provided at the bottom).

    Hope you find it helpful

    MySQL 5.6:

    MySQL     Plugin     Status Date 5.6.4 1.2.4 Milestone 7 12/20/2011 5.6.3 1.2.3 Milestone 6 10/03/2011 5.6.2 1.2.2 Milestone 5       04/11/2011

    MySQL 5.5:

    MySQL      [Read more...]
    Traversing larger graphs with OQGRAPH 3. Time for Bacon?
    +1 Vote Up -0Vote Down
    Using the IMDB data, I have loaded the actor and actress database into a few simple InnoDB tables and have performed the following test: MariaDB [imdb]> show status like "Innodb_rows_read"; +------------------+---------+ | Variable_name | Value | +------------------+---------+ | Innodb_rows_read | 1237459 | +------------------+---------+ 1 row in set (0.00 sec) MariaDB [imdb]> select x.*
    Visiting Monty HQ
    +1 Vote Up -5Vote Down

    On this big trip, I made particular effort to finally visit Monty at his home near Helsinki. Somehow, in all my years at MySQL AB, this never happened – a sad omission. So, I spent the Easter days with Monty, Anna and now 5yo Maria.

    I’m not a fan of most meetings, and in many cases in-person meetings are not actually necessary to get things organised or done, but I think this was both most enjoyable as well as productive for our respective businesses and joint interests. Good company, discussion, food, drink, sauna… fabulous.

    It’s a great pity we live on opposite sides of the planet, as we do get along very well together. We definitely don’t agree on everything, but we’re always absolutely direct with each other, and try to provide good arguments whenever we disagree, to explore things further.

    OpenSQLCamp Videos online!
    +2 Vote Up -0Vote Down

    OpenSQLCamp was a huge success! I took videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded). Unfortunately, I was busy doing administrative stuff for opensqlcamp for the opening keynote and first 15 minutes of the session organizing, and when I got to the planning board, it was already full….so I was not able to give a session.

      [Read more...]
    Are closed-source MySQL storage engines compatible with MariaDB?
    +0 Vote Up -0Vote Down

    Following the launch of the Open Database Alliance some people have assumed that it is only a matter of time before MariaDB becomes the de facto replacement for MySQL.

    That assumes that Oracle will allow the development of MySQL to stagnate, either deliberately or through neglect - something that we have expressed our doubts about, but even if that were the case it appears that the GPL (or more to the point MySQL’s dual licensing strategy) may restrict the potential for MariaDB.

    Curt Monash recently raised the question of whether closed-source storage engines can be used with MySQL (and, by

      [Read more...]
    Perl and Java Stored Procedures for MariaDB 5.1
    +1 Vote Up -0Vote Down
    I just applied the external stored procedure patch to a branch of MariaDB and uploaded it to LaunchPad.You can see the branch at https://code.launchpad.net/~atcurtis/maria/5.1-wl820Note that this is not in any reasonable condition to merge into MariaDB. Hopefully we can engage in dialog as to how we can bring this feature properly to MariaDB, MySQL and Drizzle, hopefully making the plugins
    Understanding the various MySQL Products & Variants
    +0 Vote Up -0Vote Down

    The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL (http://mysql.com) produces.
    The MySQL server product in general is released under the GNU General Public License (GPL) v2, however you should carefully review the MySQL Legal Policies (http://www.mysql.com/about/legal/) as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.

    Looking into the MySQL ecosystem for products, I’ve produced the following categories:

    • Sun/MySQL Official Products
      • MySQL Versions
    • MySQL Variants
      • Community
      • Enterprise
    • MySQL Plugins

      [Read more...]
    451 CAOS Links 2009.02.06
    +0 Vote Up -0Vote Down

    All change at Sun. A new CEO at Zend. Ingres enjoys revenue up 32%. Purple Labs raises funding. Is open source a danger to Microsoft or will Danger bring open source to Microsoft? (Not) open source food. And more.

    It’s a good week for business card printers
    There was a rush of new appointment and departure announcements this week. As already noted today, Sun has confirmed the departure of Marten Mickos as Sun is combining its Software Infrastructure organization with its Database Group to form a unified open source product group under the leadership of Karen Tegan Padir, vice president of MySQL & Software Infrastructure.

    Earlier in the week Monty Widenius confirmed

      [Read more...]
    PERFORMANCE_SCHEMA, Maria and the Tokutek Challenge
    Employee +0 Vote Up -0Vote Down

    As Peter Gulutzan just announced - we’re opening up a “new” worklog that we’ve been working on, Worklog #2360. PERFORMANCE_SCHEMA.

    In fact - it’s not “new”, it’s something that has been in the worklog system for a long time, and has had much much much discussion internally between some of the brightest engineers in the group.

    The astute among you out there that read my post on the benchmark with Maria for the the tokutek challenge, may have noted this in the configure line that I used:

    ./configure –prefix=/usr/local/mysql –localstatedir=/data0/mysqldata \

      [Read more...]
    Maria trundles the tokutek challenge
    Employee +0 Vote Up -0Vote Down

    So I saw the tokutek challenge, and wondered to myself how Maria would get along with it. I duly downloaded a 6.0 tree, and the iiBench code, tinkered with it to make it actually build, and fired things up.

    I watched it closely, for about a day, then got bored and forgot about it. I remembered today that I should take a look!

    CPU Usage (Quad Core)

    Average rows per second inserted

      [Read more...]
    Monty speaks about Maria
    +0 Vote Up -0Vote Down

    Michael Widenius, commonly referred to as Monty, gave a very interesting talk on Maria at OSCON 2008. He not only had a talk in the main session, that was well attended, titled Architecture of Maria, the New Transactional Storage Engine for MySQL (slides are available in ODP there), he also gave one at the Sun booth, where we were running our own little “unconference”.

    For those reading this in a feed reader, there’s a 23 minute video of Monty telling us more about Maria, a bit about its motivations, architecture, and where the team is at now. If you’re interested in grabbing the code, check out the MySQL + Maria Storage Engine branch on Launchpad.

    MySQL Conference and Expo 2008, Day Two
    +0 Vote Up -0Vote Down

    Day two of the conference was a little disappointing, as far as sessions went. There were several time blocks where I simply wasn’t interested in any of the sessions. Instead, I went to the expo hall and tried to pry straight answers out of sly salespeople. Here’s what I attended.

    Paying It Forward: Harnessing the MySQL Contributory Resources

    This was a talk focused on how MySQL has made it possible for community members to contribute to MySQL. There was quite a bit of talk about IRC channels, mailing lists, and the like. However, the talk gave short shrift to how MySQL plans to become truly open source (in terms of its development model, not its license). I think there was basically nothing to talk about there. I had a good conversation about some of my concerns with the speaker and some others from MySQL right afterwards.

      [Read more...]
    Liveblogging: Architecture of Maria By Monty Widenius
    +0 Vote Up -0Vote Down

    Architecture of Maria: A New Storage Engine with a Transactional Design

    Goals of Maria:

    • ACID compliant
    • MVCC, transactional
    • default non-transactional and default transactional storage engine for MySQL
    • MyISAM replacement, including temporary table use
    • Storage engine good for data warehousing.
    • Allow any length transactions to take place
    • all indexes should have equal speed (clustered indexes are not in the plan)
    • log shipping — incremental backups just by copying the logs
    • used as a standalone library
    • fast count(*)
    • allow copying of Maria tables between different Maria servers
    • Better blob handling (than MyISAM) — no memory copying, or extra memory used for

      [Read more...]
    Storage Engines at the MySQL Conference
    +0 Vote Up -0Vote Down

    I’ll be following closely the progression of Storage Engines available in the MySQL Database server, well soon to be available when 5.1 gets to GA (hopefully by end of Q2 which is what we have been told). Tick, Tick, time is running out.

    PrimeBase XT (PBXT) and Blob Streaming is obviously my clear focus, actually now working for PrimeBase Technologies, the company which I want to note for people is an Open Source company, committed at providing an open source alternative to the other commercial players. You also have at the MySQL Conference talks on the the existing InnoDB from Innobase (a subsidiary of market RDBMS leader Oracle). There is a

      [Read more...]
    Maria (aka MyISAM++)
    Employee_Team +0 Vote Up -0Vote Down

    Monty has started blogging and has announced the Early Release of the sources and Specs for Maria (aka MyISAM++). Also check out comments from Guiseppe (the Data Charmer) and from the Performance blog.

    Maria and Falcon are the two newest

      [Read more...]
    Showing entries 1 to 24

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.