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

Displaying posts with tag: xtradb (reset)

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 …

  [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:

  1. Download XtraDB 5.5 Source
  2. cd C:\xtradb-5.5
  3. mkdir bld
  4. cd bld
  5. cmake ..
  6. 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 ==========
…  [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.

  1. Download 5.1.60 MariaDB source from here.
  2. cd C:\mariadb-5.1
    
  3. win\configure.js
    
  4. cmake .
    
  5. VS: File -> Open -> Solution …
  [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
  [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 …

  [Read more...]
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 …
  [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 …
  [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

  • Percona Server 5.1.54-12.5 is based on MySQL 5.1.54.
  • New Features Added: None
  • Other Changes:
  [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)
  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 124 10 Older Entries

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