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 30 of 113 Next 30 Older Entries

Displaying posts with tag: xtradb (reset)

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:

https://downloads.mariadb.org/mariadb/10.1.0/

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 single row size must be
  • InnoDB:
  •   [Read more...]
    MariaDB 10.0.12 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.12/

    This is the third GA release of MariaDB 10.0, and 13th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • Updated Spider storage engine to version 3.2.4.
  • Updated Connect engine.
  • Updated pcre to version 8.35.
  • Exists-to-In optimization is now enabled by default.
  •   [Read more...]
    MariaDB 5.5.38 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 5.5.38 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.38/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

    • Includes all bugfixes and updates from 5.5.38

    read more

    MariaDB 5.5.38 Overview and Highlights
    +1 Vote Up -0Vote Down

    MariaDB 5.5.38 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.38/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

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

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

    https://downloads.mariadb.org/mariadb/10.0.11/

    This is the second GA release of MariaDB 10.0, and 12th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • Updated TokuDB engine to version 7.1.6
  • Updated Spider storage engine to version 3.2 (now Gamma)
  • Updated XtraDB storage engine to version 5.6.17-65.0
  • Updated InnoDB storage engine to version 5.6.17
  • Updated
  •   [Read more...]
    MariaDB 10 – XtraDB & InnoDB versions
    +1 Vote Up -0Vote Down

    I’ve had this question several times when presenting and once via an internal email thread so I figure I might as well write about it: What is the default transactional engine in MariaDB 10.0? The answer is simple – it is XtraDB.

    However this answer has some history: initial releases of MariaDB 10 actually shipped with InnoDB from MySQL 5.6. Only in 10.0.9 RC did the default switch back to being XtraDB. As MariaDB users previously know, XtraDB was the default InnoDB in 5.1, 5.2, 5.3, and 5.5 too. As always, you can switch easily between InnoDB/XtraDB – read more in: Using InnoDB instead of XtraDB

    How do you tell what version of InnoDB or XtraDB you are running? Simply, run: SHOW GLOBAL VARIABLES LIKE 'innodb_version';

    MariaDB 10.0 (read

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

    MariaDB 5.5.37 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.37/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

    read more

    MariaDB 10.0.10 Overview and Highlights
    +2 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.10/

    This is the first GA ("Generally Availability", aka "recommended for production systems") release of MariaDB 10.0, and 11th overall release of MariaDB 10.0.

    Since this is the initial 10.0 GA release, this is primarily a bug-fix and polishing release.

    Here are the main items of note:

    read more

    MariaDB 10.0.9 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.9/

    This is the second RC (“Release Candidate”) release of MariaDB 10.0, and 10th overall release of 10.0. All features planned for MariaDB 10.0 GA are included in this release.

    There were 6 notable changes in MariaDB 10.0.9:

  • InnoDB upgraded to version 5.6.15
  • Extended-keys optimization is now enabled by default.
  • MariaDB can be compiled to use the system’s PCRE library.
  • Added MASTER_GTID_WAIT() and
  •   [Read more...]
    MariaDB 5.5.36 Overview and Highlights
    +1 Vote Up -0Vote Down

    MariaDB 5.5.36 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.36/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a couple items worth mentioning:

  • Includes all bugfixes and updates from: MySQL 5.5.36
  • TokuDB is now included in RPM packages for CentOS 6 on x86-64
  • Note this release did not contain the bugfixes from XtraDB 5.5.36 yet. There is one bug fix in XtraDB 5.5.36 that is fairly serious, so if you are a *heavy* XtraDB+ user, I might wait for MariaDB 5.5.37 to be released, so you get this fix. I should note the bug was partially fixed in

      [Read more...]
    MariaDB 10.0.9 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate release.

    Among other changes, XtraDB is now the default InnoDB implementation, Oracle’s InnoDB is included as a plugin and can be dynamically loaded if desired. Packages for Ubuntu 14.04 “trusty” and Debian “Sid” have also been added to the MariaDB Ubuntu and Debian repositories.

    See the Release Notes and Changelog for detailed information on this release and the

      [Read more...]
    Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL
    +0 Vote Up -0Vote Down
    Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server. I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post. So here I will be doing a high-level comparison between MySQL NDB Cluster and Percona XtraDB Cluster.
    MariaDB 5.5.32 Now Available
    +3 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. 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.

    Download MariaDB 5.5.32

    Release Notes Changelog

      [Read more...]
    Comprehensive How-To for Enabling the Standard InnoDB Plugin in MariaDB and MySQL
    +4 Vote Up -0Vote Down

    I’m always switching back-and-forth between the 2 different InnoDB flavors in MariaDB – XtraDB+ and the standard InnoDB plugin, so I thought I’d simply post all of the various combinations in a single place. (And then I cover enabling the InnoDB Plugin in MySQL, since it’s an option in 5.1.) [Addition: Thanks to Andrew and Sergei for the tips on shortening plugin-load=. The changes are reflected below.]

    Note: Below is for Windows. For Linux, simply change “.dll” to “.so” where appropriate.

    MariaDB 10.0:

    Do not add anything, as the standard InnoDB plugin is the current default (as of 10.0.3, although I do anticipate this changing in the near future, and I’ll update the post accordingly when that happens).

    MariaDB 5.5:

    # Enable the 2 below to disable XtraDB+ and enable the standard InnoDB
      [Read more...]
    TokuDB vs Percona XtraDB using Tokutek’s MariaDB distribution
    +1 Vote Up -0Vote Down

    Following are benchmark results comparing Tokutek TokuDB and Percona XtraDB at scale factor 10 on the Star Schema benchmark. I’m posting this on the Shard-Query blog because I am going to compare the performance of Shard-Query on the benchmark on these two engines. First, however, I think it is important to see how they perform in isolation without concurrency.

    Because I am going to be testing Shard-Query, I have chosen to partition the “fact” table (lineorder) by month. I’ve attached the full DDL at the end of the post as well as the queries again for reference.

    I want to note a few things about the results:
    First and foremost, TokuDB was configured to use quicklz compression (the default) and InnoDB compression was not used. No tuning of TokuDB was performed, which means it will use up to 50% of memory by

      [Read more...]
    Percona XtraBackup 2.1.0 ‘release candidate’ for MySQL available for download
    +0 Vote Up -0Vote Down

    Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here. For this RC release, we will not be making APT and YUM repositories available, just base deb and RPM packages

    This is an Release Candidate quality release and is not intended for production. If you want a high-quality, generally available release, the current stable version should be used (currently

      [Read more...]
    Percona XtraBackup 2.0.7 for MySQL available for download
    +0 Vote Up -0Vote Down

    Percona XtraBackup 2.0.7 was released May 6.

    Percona is glad to announce the release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases.

    This release is the current GA (Generally Available) stable release in the 2.0

      [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...]
    InnoDB Plugin Version Numbering in MySQL and MariaDB
    +2 Vote Up -0Vote Down

    As some of you may or may not know, I’ve maintained a list of all InnoDB Plugin versions as they’ve historically contained a different version (entirely different numbering scheme) than the MySQL distribution they were included with.

    This list was most helpful for troubleshooting various InnoDB issues when the plugin may (or may not) have been involved, and/or for benchmarking, etc. And it’s fair to say it was more useful when the InnoDB plugin was not the mainstream, which it is now.

    However, with the latest releases, in MySQL and MariaDB, the “InnoDB Version” simply matches the “MySQL Version”. These “latest releases” include: MySQL 5.6.10, MySQL 5.5.30, MySQL 5.1.68, and MariaDB 5.5.30

    Of course this isn’t the most newsworthy story, but having maintained this

      [Read more...]
    Log Buffer #277, A Carnival of the Vanities for DBAs
    +0 Vote Up -1Vote Down
    Database bloggers are blowing their trumpets at full throttle warming up the hearts of readers across the globe with cool tips, nifty tricks and gems. This Log Buffer Edition in Log Buffer #277 picks those gems and present to you. Oracle: Charles Hooper is dealing with a parallel execution challenge. why a very simple query [...]
    How to Enable the Original InnoDB Plugin in MariaDB 5.5
    +7 Vote Up -0Vote Down

    As I mentioned here, there is a slight change for enabling the [original] InnoDB Plugin in MariaDB 5.5 (as compared to how you would enable it in 5.1).

    Remember, in MariaDB 5.5, if you do not “enable” (i.e., add anything to the config file to do so) the InnoDB Plugin in MariaDB 5.5, you’ll end up with XtraDB+ for your InnoDb plugin. However, if you do “enable” the InnoDB plugin, then you end up with the original InnoDB plugin provided by Oracle/InnoDB.

    The change is that the plugin file (.dll for Windows, .so file for Linux) which was previously named “ha_innodb_plugin.dll” is now just “ha_innodb.dll”.

    Thus, if you previously enabled the plugin with (would have been in a 5.1 instance):

    [mysqld]
    ignore_builtin_innodb
      [Read more...]
    Building XtraDB on Windows
    +1 Vote Up -0Vote Down

    As you may or may not know, Windows is not yet a supported platform for XtraDB.

    I thought I’d try to build it, and see what happens:

  • Download XtraDB 5.5 Source
  • cd C:\xtradb-5.5
  • mkdir bld
  • cd bld
  • cmake ..
  • VS08: File -> Open -> Solution -> C:\xtradb-5.5\bld\MySQL.sln

    Build Ended With:

    ========== Build: 70 succeeded, 17 failed, 2 up-to-date, 10 skipped ==========

    The first failure had to do with innobase:

    18>Generating Code...
    18>Build log was saved at "file://c:\..\innobase.dir\Debug\BuildLog.htm"
    18>innobase - 9 error(s), 3 warning(s)

    I checked the innobase build log and found this:

    sql_prepare.cc
    ..\sql_prepare.cc(2199) : error C3861:
  •   [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...]
    Effects of ALL_O_DIRECT on a TPCC workload
    +1 Vote Up -0Vote Down
    Recently Mark Callaghan blogged about using O_DIRECT for the InnoDB transaction log. He noted that there was not a significant performance gain if the number of concurrent connections increases. I've done my share of testing and retesting over the past months to determine how useful this is. Based on a small TPCC workload (100 warehouses, 64 connections, 1 hour test, 5 minute rampup), I've seen huge performance gains by setting ALL_O_DIRECT for the variable innodb_flush_method using Percona XtraDB.

    Without using Direct I/O, the benchmark generated a TpmC score of approximately 24,500 (HP DL160 G6, 2 x Xeon E5620 2.40GHz, 16GB mem, 4x300 GB SAS, RAID-10). After setting the variable to ALL_O_DIRECT, TpmC score went up to 48,000. Huge increase. This deserves some more investigation and some more testing. I want to also try this out on some older hardware to see if similar performance gains can be achieved.
    Percona Server 5.1.55-12.6
    +1 Vote Up -2Vote Down

    Percona Server version 5.1.55-12.6 is now available for download. It is now the current stable release version.

    Changes

    • Fixed compiler warnings in both the core server and in XtraDB. (Alxey Kopytov, Yasufumi Kinoshita)

    Bugs Fixed

    • Bug #602047 – The ROWS_READ columns of TABLE_STATISTICS and INDEX_STATISTICS were not properly updated when a query involved index lookups on an InnoDB table. (Yasufumi Kinoshita)
    • Bug #707742 – The server could crash when trying to import a table which had not been previously prepared using xtrabackup --prepare --export. Also, on servers with huge buffer pools, adding or removing an index even on an empty InnoDB table could take a long time due to excessive locking when
      [Read more...]
    Percona Server 5.5.8 Beta Release
    +2 Vote Up -0Vote Down

    It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights:

    • Performance and scalability improvements throughout the server and storage engine
    • Optimizations for flash storage such as SSD, Virident, and FusionIO
    • Optimizations for cloud computing
    • The HandlerSocket plugin for NoSQL access
    • There’s an Amazon OS repository, as well as Yum and Apt repositories
    • Improvements to replication, partitioning, stored procedures
    • More diagnostics and tunability
    • More pluggability, including pluggable authentication


    In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases:

    New
      [Read more...]

    Percona Server 5.1.54-12.5
    +1 Vote Up -0Vote Down

    Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.

    Functionality Added or Changed

      [Read more...]
    Percona Server 5.1.53-12.4
    +4 Vote Up -0Vote Down

    Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version.

    Functionality Added or Changed

    •  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.
    •  New Features Added:
      • Precompiled UDFs for Maatkit (FNV and MurmurHash hash functions to provide faster checksums) are now included in distributions. Fixes feature request #689992. (Aleksandr Kuzminsky)
    •  Other Changes:
      • innodb_doublewrite_file - It's no longer necessary to recreate your database and InnoDB system files when a dedicated file to contain the doublewrite buffer is
      [Read more...]
    MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
    +4 Vote Up -0Vote Down

    This is to follow up on my previous post and show the results for MySQL 5.5.8 and Percona Server on the fastest hardware I have in our lab: a Cisco UCS C250 server with 384GB of RAM, powered by a Virident tachIOn 400GB SLC card.

    To see different I/O patterns, I used different innodb_buffer_pool_size settings: 13G, 52G, an 144G on a tpcc-mysql workload with 1000W (around 100GB of data). This combination of buffer pool sizes gives us different data/memory ratios (for 13G - an I/O intensive workload, for 52G - half of the data fits into the buffer pool, for 144G -

      [Read more...]
    Showing entries 1 to 30 of 113 Next 30 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.