Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 13 3 Older Entries

Displaying posts with tag: webscalesql (reset)

MySQL Thread Pool Improvements @ Twitter
+0 Vote Up -0Vote Down

At Twitter, MySQL is an important part of our storage story. We can have a typical database node with thousands of open connections. It works mostly fine because generally only a few of these connections actively working inside the server. Given the scale at which we have to operate spikes happen – mostly at unexpected times and with unexpected ferocity. The challenge is how to control concurrency within MySQL server during spikes.

Historically we have been using innodb_thread_concurrency to control number of active threads within the server. In Twitter MySQL-5.5 we introduced the idea of Query Throttling where incoming requests are throttled if the number of active threads goes beyond a configurable threshold. These solutions focus on maintaining the health of the system.

  [Read more...]
MariaDB 10.1.0 Overview and Highlights
+0 Vote Up -0Vote Down

MariaDB 10.1.0 was recently released, and is available for download here:

This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.

These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):

  • InnoDB: Allow > 16K pages on InnoDB – InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that
  •   [Read more...]
    A technical WebScaleSQL review and comparison with Percona Server
    +1 Vote Up -0Vote Down

    The recent WebScaleSQL announcement has made quite a splash in the MySQL community over the last few weeks, and with a good reason. The collaboration between the major MySQL-at-scale users to develop a single code branch that addresses the needs of, well, web scale, is going to benefit the whole community. But I feel that the majority of community opinions and comments to date have been based on the announcement itself and the organizational matters only. What we have been missing is an actual look at the code. What actual new features and bug-fixes are there? Let’s take a

      [Read more...]
    Per query variable settings in MySQL/Percona Server/WebScaleSQL
    +1 Vote Up -0Vote Down

    Recently there was a discussion on the webscalesql mailing list started by Chip Turner on a proposed change to the MAX_STATEMENT_TIME patch. This feature has been known as per query variable settings (WL#681) and even shipping in Percona Server 5.6 as per-query variable statement.

    This feature has piqued my interest since 2009, when the MySQL project (then owned by Sun Microsystems) participated in Google Summer of Code 2009, and we

      [Read more...]
    MySQL related IRC discussion channels
    +0 Vote Up -0Vote Down

    There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I’m missing?

    Freenode (

    • #mysql – main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally)
    • #maria – main channel for all kinds of MariaDB related discussions
    • #webscalesql – for all kinds of WebScaleSQL discussions
    • #percona – main channel for all kinds of Percona related discussions
    • #tokutek – main channel for Tokutek discussions (TokuDB or TokuMX)
    • SkySQL-specific channels: #maxscale and #mariadb-mgr

    OFTC (

    • #debian-mysql – for all kinds of Debian MySQL related bits (packaging, bugs, etc.)
      [Read more...]
    MMUG7: Madrid MySQL Users Group meeting to take place on 24th April 2014
    +1 Vote Up -0Vote Down

    Madrid MySQL Users Group will have its next meeting on the 24th of April. Details can be found on the group’s Meetup page.

    We plan to talk about WebScaleSQL and I will give a short presentation on how to build WebScaleSQL RPMs on CentOS 6.  The meeting will be in Spanish.

    We’ve changed the place that we’ll be holding the meeting. See the Meetup URL for details. Looking forward to seeing you there.

    La próxima reunión de Madrid MySQL Users Group tendrá lugar el jueves 24 de abril. Se puede encontrar más detalles en la página del grupo.  Hablaremos sobre WebScaleSQL y ofreceré una breve presentación sobre como

      [Read more...]
    WebScaleSQL on Windows? I wish, but not quite yet, it seems …
    +1 Vote Up -0Vote Down

    For fun, I tried building WebScaleSQL on Windows, even though it’s not [yet?] a support platform.

    Using the following (as I would to build MySQL/MariaDB):

    cd c:\mysql\webscalesql-5.6.16
    mkdir bld
    cd bld
    cmake ..
    cmake --build . --config relwithdebinfo --target package

    I end up with:

        238 Warning(s)
        110 Error(s)
    Time Elapsed 00:05:08.53

    Looking through the output, the main error is this:

    fatal error C1083: Cannot open include file: 'atomic':
    No such file or directory

    Of course the directory does exist, and permissions are correct.

    C:\mysql\webscalesql-5.6.16\include\atomic_stat.h contains the following line:

    #include <atomic>

    And this exists:

      [Read more...]
    Facebook’s Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live
    +3 Vote Up -0Vote Down

    Facebook’s Yoshinori Matsunobu

    I spoke with Facebook database engineer Yoshinori Matsunobu here at Percona Live 2014 today about a range of topics, including MySQL at Facebook, the company’s recent move to WebScaleSQL, new MySQL flash storage technologies – and why attending the Percona Live MySQL Conference and Expo each year is very important to him.

    Facebook engineers are hosting several sessions at

      [Read more...]
    WebScaleSQL RPMs for CentOS 6
    +0 Vote Up -0Vote Down

    Looks like this post was rather unclear. See the bottom for how to build the rpms quickly.

    WebScaleSQL was announced last week. This looks like a good thing for MySQL as it provides a buildable version of MySQL which includes multiple patches from Facebook, Google, LinkedIn, and Twitter needed by large users of MySQL, patches which have not been incorporated into the upstream source tree.  Making this more visible will possibly encourage more of these patches to be brought into the code sooner.

    The source is provided as a git repo at and as detailed at the documentation says there is currently no

      [Read more...]
    When the Innovator's Dilemma hit the MySQL World
    +2 Vote Up -5Vote Down
    What’s the connection between databases and fruit flies?
    Some of you may be familiar with the bestseller in business literature The Innovator's Dilemma: When New Technologies Cause Great Firms to Fail, by Harvard professor Clayton Christensen. In his book, Prof. Christensen compared disk drives to fruit flies. The comparison relates to the rapid changes that disrupted the disk drive industry for decades. That disruption is compared to the rapid changes that take place to fruit flies that live only for few hours, and for this reason researchers can study and analyse their behaviour.

    In the software business, you can replace disk drives with databases. Obviously, databases live longer than fruit flies, but it is an industry that sometimes shows schizophrenic changes. Whilst it is true that relational databases have being dominated the

      [Read more...]
    Showing entries 1 to 10 of 13 3 Older Entries

    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.