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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 513 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

Exciting times: SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We’re also co-sponsoring the Red Hat Tour 2013 in Amsterdam this week

 

SkySQL named one of the 2013 Top 100 Europe Winners by Red Herring

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

Celebrate the end of a full week dedicated to MySQL and related technologies, with Black Vodka!
+1 Vote Up -0Vote Down

Join in our Finnish ritual, next Friday, at the closing of MySQL & Cloud Database Solutions Day after Percona Live!

read more

Continuent Tungsten at SkySQL & Cloud Database Solutions Day, Friday 4/26
+1 Vote Up -0Vote Down
Join Continuent, SkySQL and MariaDB for a day of free tutorials and interactive discussions around the MySQL and Maria databases, the Cloud, and High Availability, immediately following Percona Live: MySQL User Conference and Expo 2013. Robert Hodges (CEO, Continuent) and Edward Archibald (CTO, Continuent) will be talking about "Scalable MySQL Operation in the Cloud with Continuent Tungsten" at
Latest Addition to MySQL & Cloud Database Solutions Day: Calpont CTO Jim Tommaney joins as guest speaker
+1 Vote Up -0Vote Down

Join us next Friday in Santa Clara for a free day of learning and fun from the SkySQL & MariaDB gang & their partners

We’re proud to announce that Jim Tommaney, CTO of Calpont, has just signed on to speak at the MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB - taking place next Friday, April 26, directly after Percona Live: MySQL Conference & Expo.

read more

The state of the MySQL ecosystem
+1 Vote Up -2Vote Down

I’ll be on a whistle-stop tour of California next week, including two presentations at the Percona Live MySQL Conference and Expo.

On day one at 1:20pm I’ll be presenting CAP Theorem: Two out of three ain’t right, in which I will be challenging the popular ‘two out of three’ explanation of CAP Theorem, examining the evidence from a variety of experts, including Dr Eric Brewer.

Then on day three at 9:00am I’m very honoured to be providing a keynote presentation, The State of the MySQL Ecosystem.

Here’s an overview of the presentation:

It

  [Read more...]
Solutions Lounge and Giveaway Details for MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB
+1 Vote Up -0Vote Down

Finish off the day and week with Continuent-sponsored Biergarten!

read more

Upcoming talks in Santa Clara
+4 Vote Up -0Vote Down

I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.

  • MariaDB Cassandra Interoperability with Sergei Petrunia on 23 April 1:20pm – 2:10pm @ Ballroom D
  • MariaDB BoF on 23 April 6:00pm – 7:00pm @ Ballroom F
  • MariaDB
  •   [Read more...]
    More SkySQL Experts Speaking at Percona Live: MySQL Conference & Expo
    +2 Vote Up -1Vote Down

    Stick around one more day for the 2nd Annual MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB

    read more

    April is the Coolest Month
    +0 Vote Up -0Vote Down

    If T.S. Eliot were a MySQL DBA, I think he would have been more upbeat about April.

    We are gearing up for an incredible second half of April. We will be presenting three separate sessions at the Percona Live: MySQL Conference and Expo 2013, April 22-25, in Santa Clara, CA. In addition, we will be presenting at SkySQL’s MySQL & Cloud Database Solutions Day on Friday, April 26 at the same location.

    Come by to see us in Booth #114, or stop by one of our sessions:

      [Read more...]
    This just in: Tokutek Joins the MySQL & Cloud Database Solutions Day Speaking Roster
    +0 Vote Up -0Vote Down

    Tokutek Technical Lead, Gerry Narvaja, among list of experts at free event hosted by SkySQL and MariaDB

    read more

    Speaker Details For MySQL & Cloud Database Solutions Day, hosted by SkySQL & MariaDB, in Santa Clara
    +0 Vote Up -0Vote Down

    Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

    As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

    read more

    Refactoring Internal temporary tables (another stab at it)
    +1 Vote Up -2Vote Down

    A few weekends ago, I started to again look at the code in Drizzle for producing internal temporary tables. Basically, we have a few type of tables:

    • Standard
    • Temporary (from CREATE TEMPORARY TABLE)
    • Temporary (from ALTER TABLE)
    • Internal temporary (to help with query execution)

    If you’re lucky enough to be creating one of the first three types, you go through an increasingly lovely pile of code that constructs a nice protobuf message about what the table should look like and hands all responsibility over to the storage engine as to how to do that. The basic idea is that Drizzle gets the heck out of the way and lets the storage engine do its thing. This code path looks rather different

      [Read more...]
    Gearing up for the Percona Live: MySQL Conference & Expo!
    +1 Vote Up -0Vote Down
    Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

    Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

    read more

    Awesome to see the MySQL Ecosystem Flourishing
    +6 Vote Up -0Vote Down

    I just wanted to take a moment and thank, notice, what ever you want to call it, but share some love with all those and all things MySQL.

    I read the post Let’s Celebrate MySQL 5.6 GA! – MySQL Community Reception by Oracle by Oracle MySQL Group and it got me to thinking of how proud I am of (and proud to be a part of) the whole MySQL Ecosystem.

    We *should* all celebrate MySQL 5.6 GA! I well remember the 3.22 and 3.23 days, and there were many folks before me already using MySQL!!!

    I love to see how it has continued to grow, the ecosystem and all things MySQL, that is. MySQL is better than ever. MariaDB is better than ever. Percona Server is better than ever. You have great Support options with MySQL/Oracle, SkySQL/MariaDB, and Percona as well – not to mention numerous others. I

      [Read more...]
    Enabling the Verbose InnoDB Lock Monitor in MariaDB and Percona Server for XtraDB+ and XtraDB
    +0 Vote Up -0Vote Down

    I enabled the InnoDB Lock Monitor in my MariaDB 5.5 instance (using XtraDB+ as the InnoDB – which is the default in MariaDB) and noticed that while the SHOW ENGINE INNODB STATUS was being logged to the error log, it wasn’t logging the “additional” lock information – it just looked like the plain ‘ole INNODB STATUS.

    Long story short, Percona added a new variable so one has better control over what gets logged:

    innodb_show_verbose_locks

    If off (default), then the InnoDB Lock Monitor logs the normal INNODB STATUS, and if enabled, then it logs it with the extended lock information.

    They also created another variable that goes along with this one (and the InnoDB Lock Monitor), which is:

    innodb_show_locks_held

    This

      [Read more...]
    Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
    +3 Vote Up -1Vote Down

    I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time.

    Shortly thereafter, the MySQL world saw acquisitions, forks, times of uncertainly, more acquisitions, more forks, rumors (“Oracle is going to kill MySQL and the whole Internet”) and just a lot of drama and politics.

    And now, after all this time some 6 or 7 years later, it feels like a MySQL Renaissance. All of the major MySQL players are coming to the

      [Read more...]
    Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
    +1 Vote Up -0Vote Down

    Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

    read more

    OQGraph presentation at SCaLE 11x
    +2 Vote Up -0Vote Down
    I did a presentation on OQGraph for the +Southern California Linux Expo on Sunday and some of the audience seemed really interested. Demonstrated finding the shortest path in a graph of millions of edges, with a deliberately crippled config running in a VirtualBox environment. (edit, updated URLs on slides)
    Using MariaDB on CentOS 6
    +4 Vote Up -0Vote Down

    This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

    yum update
    cd /etc/yum.repos.d/
    wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
    yum list mariadb\*
    yum install mariadb-server mariadb
    /etc/init.d/mysqld start

    That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

    Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

    Related posts:

  •   [Read more...]
    Announcing Percona Server for MySQL 5.6.10-60.2
    +0 Vote Up -0Vote Down

    Percona Server for MySQL version 5.6.10-60.2

    Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2 on March 14, 2013.  (Downloads are available here and from the experimental Percona Software Repositories). Based on MySQL 5.6.10, including all the bug fixes in it, Percona Server 5.6.10-60.2 is the third ALPHA release

      [Read more...]
    diffstat of MySQL 5.6 versus 5.5
    +0 Vote Up -0Vote Down

    Yesterday I wrote about what the diffstat between MySQL 5.5 and MariaDB 5.5 was, and previously to that, about the MariaDB code size as reported by sloccount. Let’s look at MySQL 5.6.

    A naive wc based “lines of code” for MySQL 5.6 sql/ directory is ~490kLOC which contasts with MySQL 5.5 being ~375kLOC by the same measure. If we diffstat the sql/ directory like I did for MariaDB 5.5 we get:

     357 files changed, 172871 insertions(+), 67922 deletions(-)

    Versus, as you remember from yesterday for MariaDB 5.5 over MySQL 5.5:

     250 files changed, 83639
      [Read more...]
    So what about the diffstat of MariaDB compared to MySQL?
    +0 Vote Up -4Vote Down

    So, I’ve looked at what sloccount says on the differences between Oracle MySQL over versions of itself and the various MySQL branches around. What I haven’t looked at is the diffstat. Firstly, let’s look at MariaDB.

    I’m going to look at MariaDB 5.5.29 as compared to MySQL 5.5.29, both checked out from bzr. A naive diffstat would give us:

     5261 files changed, 1086165 insertions(+), 122751 deletions(-)

    And this looks like an awful lot of code that has changed: about 1,086,165 lines! This actually includes a whole other copy of InnoDB in the form of XtraDB. If we take that into account we get:

     5032 files changed, 864997 insertions(+), 125099 deletions(-)

    Which is still incredibly

      [Read more...]
    Which is bigger: MySQL or PostgreSQL?
    +1 Vote Up -0Vote Down

    From my previous posts, we have some numbers (excluding NDB) for the size of MySQL, so what about PostgreSQL? Here, I used PostgreSQL git trunk and classing things in the contrib/ directory as plugins. I put the number of lines of code in the src/backend/storage directory down as storage engines LoC but did not count it as non-kernel code.

    Version Total LoC Plugin LoC Storage Engines LoC Remaining (kernel) MySQL 5.5.30 858,441 2,706 171,009 684,726 (79% kernel) MySQL 5.6.10 1,049,344 29,122 236,067 784,155 (74% kernel) MariaDB 5.5 1,142,118 11,781 304,015 826,322 (72% kernel) Drizzle trunk 334,810 31,150 130,727 172,933 (51% kernel) PostgreSQL trunk 648,691 61,934 17,802 586,757  [Read more...]
    MariaDB 5.5.30 now available
    +2 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.30. This is a bug fix release. See the release notes and changelog for details.

    Download MariaDB 5.5.30

    Release Notes  Changelog  Overview of 5.5

    APT and YUM Repository Configuration Generator

      [Read more...]
    Sessions at Percona Live MySQL Conference 2013: fun, competition, novelties, and a free pass
    +3 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo 2013 is almost 1 month away. It's time to start planning, set the expectations, and decide what to attend. This post will give a roundup of some of the sessions that I recommend attending and I look forward to.

    First, the unexpected!

    After much talk and disbelief, here they come! Oracle (http://www.mysql.com) engineers will participate to the Percona Live conference. This is wonderful! Their participation was requested by the organizers, by the attendees, and by community advocates, who all told the Oracle management how important it is to be in this conference. Finally, they have

      [Read more...]
    Is MySQL bigger than Linux?
    +0 Vote Up -0Vote Down

    I’m going to take the numbers from my previous post, MySQL Modularity, Are We There Yet? for the “kernel” size of MySQL – that is, everything that isn’t a plugin or storage engine.

    For Linux kernel, I’m just going to use the a-bit-old git tree I have on my laptop. I’ve decided that the following directories are for “plugins” drivers/ arch/ sound/ firmware/ crypto/ usr/ virt/ tools/ scripts/ fs/*/* and everything else is core kernel code.

    Version Total LoC Total Plugin LoC Remaining (kernel) MySQL 5.6.10 1,049,344 265,189 784,155 (74% kernel) MariaDB 5.5 1,142,118  [Read more...]
    MySQL modularity, are we there yet?
    +2 Vote Up -1Vote Down

    MySQL is now over four times the size than it was with MySQL 3.23. This has not come in the shape of plugins.

    Have we improved modularity over time? I decided to take LoC count for plugins and storage engines (in the case of Drizzle, memory, myisam and innobase are storage engines and everything else comes under plugin). I’ve excluded NDB from these numbers as it is rather massive and is pretty much still a separate thing.

    Version Total LoC Plugin LoC Storage Engines LoC Remaining (kernel) MySQL 3.23.58 371,987 0 (0%) 176,276 195,711 (52% kernel) MySQL 5.1.68 721,331 228 237,124 483,979 (67% kernel) MySQL 5.5.30 858,441 2,706 171,009 684,726 (79% kernel)  [Read more...]
    Other MySQL branch code sizes
    +1 Vote Up -0Vote Down

    Continuing on from my previous posts, MySQL code size over releases and MariaDB code size I’ve decided to also look into some other code branches. I’ve used the same methodology as my previous few posts: sloccount for C and C++ code only.

    There are also other branches around in pretty widespread use (if only within a single company). I grabbed the Google, Facebook and Twitter patches and examined them too, along with Percona Server 5.1 and 5.5.

    Codebase LoC (C, C++) +/- from MySQL Google v4 patch 5.0.37 970,110 +26,378 (from MySQL 5.0.37) MySQL@Facebook 1,087,715 +15,768  [Read more...]
    MariaDB code size
    +3 Vote Up -0Vote Down

    Continuing on from my previous post, MySQL code size over releases.

    I wanted to look at the different branches/patch sets of MySQL out there and work out how far from upstream they deviated. I’m just going to compare against whatever upstream version the most easily accessible version is based on (be it 5.0.x, 5.1.x or whatever).

    For MariaDB versions, I removed innodb_plugin and replaced it with xtradb for stats purposes as the MariaDB innodb_plugin is essentially the same as upstream and I don’t want to artificially inflate the diff size.

    The first three major versions of MariaDB were all based on MySQL 5.1. I used sloccount and only counted C and C++ code.

    So, let’s look at some of the MySQL patch

      [Read more...]
    MariaDB Galera Cluster 5.5.29 Stable (GA) released
    +5 Vote Up -0Vote Down

    After some final testing and polishing, the MariaDB project and Codership are pleased to announce the release of MariaDB Galera Cluster 5.5.29. This is a Stable (GA) release. MariaDB Galera Cluster links:

    About MariaDB Galera  [Read more...]

    Previous 30 Newer Entries Showing entries 31 to 60 of 513 Next 30 Older Entries

    Planet MySQL © 1995, 2013, 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.