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

Displaying posts with tag: xtradb (reset)

Innodb transaction history often hides dangerous ‘debt’
+1 Vote Up -0Vote Down

In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous “debt” being accumulated – unpurged transaction “history” which if not kept in check over time will cause serve performance regression or will take all free space and cause an outage. Let’s talk about where it comes from and what can you do to avoid running into the trouble.

Technical Background: InnoDB is an MVCC engine which means it keeps multiple versions of the rows in the database, and when rows are deleted or updated they are not immediately removed from the database but kept for some time – until they can be removed. For a majority of OLTP workloads they can be removed seconds after the change actually took place. In some cases though they might need to be kept for a long period of time

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

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

https://downloads.mariadb.org/mariadb/5.5.40/

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.14 Overview and Highlights
+1 Vote Up -0Vote Down

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

https://downloads.mariadb.org/mariadb/10.0.14/

This is the fifth GA release of MariaDB 10.0, and 15th overall release of MariaDB 10.0.

This is primarily a bug-fix release. (MariaDB 10.0 is the current stable series of MariaDB. It is an evolution of the MariaDB 5.5 with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL 5.6.)

Here are the main items of note:

  • TokuDB upgraded to 7.5.0
  • XtraDB upgraded to 5.6.20-68.0
  • InnoDB upgraded
  •   [Read more...]
    MariaDB 10.0.13 Overview and Highlights
    +0 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.13/

    This is the fourth GA release of MariaDB 10.0, and 14th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • InnoDB upgraded to 5.6.19.
  • XtraDB upgraded to
  •   [Read more...]
    MariaDB 5.5.39 Overview and Highlights
    +0 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/5.5.39/

    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.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
  •   [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...]
    Showing entries 1 to 10 of 118 10 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.