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

Displaying posts with tag: xtradb (reset)

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...]
MySQL 5.5.8 and Percona Server: being adaptive
+3 Vote Up -0Vote Down

As we can see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you have a great release. However, there is one area I want to touch on in this post. At Percona, we consider it important not only to have the best peak performance, but also stable and predictable performance. I refer you to Peter's post, Performance Optimization and Six Sigma.

In Percona Server (and actually even before that, in percona-patches builds for 5.0), we added adaptive checkpoint algorithms, and later the InnoDB-plugin included an implementation of  "adaptive flushing". This post shows the differences between them and MySQL.

The post also answers the question of whether we are going to have releases of Percona

  [Read more...]
Percona Server 5.1.53-11.7
+1 Vote Up -0Vote Down

Percona Server version 5.1.53-11.7 is now available for download.

The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

Functionality Added or Changed

  •  Percona Server 5.1.53-11.7 is now based on MySQL 5.1.53.
  •  New Features Added: None
  •  Other Changes: None

Bugs Fixed

  • Bug #643149 - Slow query log entries were not being done in the usual parsing format. (Alexey Kopytov)
  • Bug #677407 - The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (Alexey Kopytov)

Release Notes for this and previous releases can be found in our

  [Read more...]
Percona Server now both SQL and NOSQL
+8 Vote Up -0Vote Down

Just yesterday we released Percona Server 5.1.52-12.3 which includes HandlerSocket. This is third-party plugin, developed Inada Naoki, DeNA Co., Ltd and explained in Yoshinori Matsunobu's blog post.

What is so special about it:

  • It provides NOSQL-like requests to data stored in XtraDB. So in the same time you can access your data in SQL and NOSQL ways. This is first open source solution which allows that.
  • It has persistent storage (XtraDB is persistent)
  • It handles really high load. In my tests using 2 dedicated web servers ( using perl clients) I reached 200,000 req/sec and the clients were real bottleneck, while Percona Server was busy only
  [Read more...]
Percona Training in London and Frankfurt
+1 Vote Up -0Vote Down

For those that missed it - last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September.

(While in Europe, we'd love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you're a meetup organizer in London or Paris, please feel free to get in touch.)


Entry posted by Morgan Tocker |

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 119 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.