PlanetMysql.ru – информация о СУБД MySQL

We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that's just single workload. That's why we are looking into different benchmarks, and one
of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration.

You can download it from our Lauchpad Percona-tools project, it's
bzr branch lp:~percona-dev/perconatools/tpcemysql

Important DISCLAIMER:
Using this package you should agree with TPC-E License Agreement,
which in human words is:

• You can't name results as "TPC Benchmark Results"
• You can't compare results with results published on http://www.tpc.org/ and you can't pretend the results are compatible with published by TPC.

And we are not going to do anything from that, your primary goals is XtraDB/InnoDB performance research and/or compare with available Storage Engines for MySQL.

The workload in tpce is quite different from tpcc. Tpcc is write intensive, while tpce
is read oriented.
To give more details, there is stats for 10 seconds:

The result is quite chatty,

but it allows you to see count of 11 different transactions per 10 secs and 90% response time.

and final result

where you can see count of successful TR (TradeResult) transactions, and
the summary result in TpsE (transactions per seconds).

Expect our results soon!

Entry posted by Vadim | No comment

Add to: | | | |

Dear Community,

As of today Release 9 of XtraDB storage engine is available.

The release includes following new features:

• The release is base on 1.0.6 version of InnoDB plugin.
• MySQL 5.1.42 as a base release
• Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was forgotten)
• New patch innodb_relax_table_creation
• Added extended statistics to slow log
• Adjust defaults with performance intention
• Added parameter to control checkpoint age
• Added recovery statistics output when crash recovery (disabled by default)
• Adjusted intraction of patches
• Patch to dump and restore innodb_buffer_pool

Fixed bugs:

• Bug#488315:
  rename columns and add unique index cause serious inconsistent with mysqld
• Bug #495342: “MySQL 5.1.41 + InnoDB 1.0.6 + XtraDB patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris”
• Bug #47621: change the fix of http://bugs.mysql.com/47621 more reasonable

The builds for RedHat 4, 5 , Debian and Ubuntu are located on http://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD.

There is an RPM Percona-release. It installs Percona.repo to /etc/yum.repos.d/ and the public key which we use to sign RPMs. The copy of the key is located on our web-site.

Once you install Percona-release repo the upgrade becomes as easy as

The latest source code of XtraDB, including development branch you can find on LaunchPAD.

Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

Dear Community,

As of today release 0.9.5rc is available.

In this release there are following changes:
Changelog:

• Option –no-lock is added to innobackupex-1.5.1. Use it only while ALL your
  tables are InnoDB and you DO NOT CARE about binary log
  position of backup
• XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported. We thank a well known Social Network site for the sponsorship.
  
• Windows conscious change more
• Impoved error messages in innobackupex
• Windows conscious experimental change
• Suppress purge when –stats
• Build number in RPM name. For instance, in the name xtrabackup-0.9.5rc-50.rhel5.x86_64.rpm 50 is the build number.
• Suppress master_thread ibuf operations for –stats
• Suppress ibuf operations for –stats
• fFx fatal bug at –backup when added –stats
• New option –stats to gather index stats
• Fixed some bugs for a 32bit platform

Fixed bugs:

• Bug #435634 in Percona-XtraBackup: “xtrabackup can’t write to a file on windows”
• Bug #437788 in Percona-XtraBackup: “xtrabackup.exe can’t write to a file”
• Bug #386535 in Percona-XtraBackup: “ibbackup_binlog_marker bug still persists”
• Bug #402884 in Percona-XtraBackup: “tries to create temporary tables in relative ./tmp directory”
• Bug #417178 in Percona-XtraBackup: “can’t backup tables with $ in name”

The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/.

The Debian package is also available via APT. Just add these lines  in /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Update the local database

# apt-get update

And install xtrabackup

# apt-get install xtrabackup

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

It’s time to announce our plans for Percona Performance Conference 2010. We will hold the event on April 13th and 14th in Santa Clara, California. In the months to come we will announce the theme, the exact location (we have it reserved, but it’s subject to change), the exact dates (we may add days), and we’ll open up registration and a Call For Proposals. Stay tuned!

Entry posted by Baron Schwartz | No comment

Add to: | | | |

Dear Community,

We are glad to present you release 8 of XtraDB.

The release includes following new features:

• The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4
• MySQL 5.1.39 as a base release

Fixed bugs:

• Bugs#413858: Crash from failed assertion in dict0dict.c
• Bug#417751:
  XtraDB crashes on startup on windows
• fix-import-extern-pages
• Number of mysql-tests are fixed

The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.39-8/
The latest source code of XtraDB, including development branch you can find on LaunchPAD.

We are launching also the repository with Debian packages.
To install XtraDB with APT put in your /etc/apt/sources.list

deb http://repo.percona.com/apt lenny main
deb-src http://repo.percona.com/apt lenny main

Then run

# apt-get update
# apt-get install mysql-server-5.1

Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona

Entry posted by Aleksandr Kuzminsky | 3 comments

Add to: | | | |

I’m happy to extend a warm welcome to two new members of the Percona team.

First is Yves Trudeau, about whom I can say many things:

• One of the top MySQL Cluster (NDB Cluster) experts in the world.
• An expert on all things High Availability, including DRBD and Heartbeat.
• Many years of experience with Huge Data.
• Half of the Waffle Grid team.
• A really nice person!

Yves joins us after a tenure of several years as a senior consultant at Sun/MySQL. Together with Matt Yonkovit, he plans to work on WaffleGrid (but as a new project under a new name, to be determined), and integration with XtraDB. Yves lives in Quebec with his family.

Next is Fernando Ipar. Fernando is our first dedicated Shift Support Captain^[1]. Fernando specializes in MySQL, GNU/Linux, systems administration, and high availability. Fernando has been involved in computer programming since he was 11, and in Open Source since 2001. He loves shade-grown coffee, music, and natural history. He lives in Uruguay with his wife and family. Fernando brightens our IRC channel with his helpful and cheerful presence!

Welcome, Yves and Fernando!

[1] Shift Support Captain is kind of a dispatcher for 24-hour service. We have been doing 24×7 service through an on-call phone number for years, but a few months ago we started literally manning the desk 24×7 — something that we have grown large enough to both need and justify, at our current size of around 30 people. Our customers can now use email, Skype, AOL messenger, or Google Chat (as well as the phone number) to get immediate attention, 24×7, from a technically savvy person.

Entry posted by Baron Schwartz | No comment

Add to: | | | |

I wanted to write a few administrative updates in one so I didn’t spam everyone’s feed readers too much. Here we go:

• We’ve had reports of some lost comments.  We reported this via Twitter a while ago, but thought it was fixed.  We’ll try and pay more attention to spam filtering, but we wanted to reach out and say – let us know if you are one of the people having problems.  We’re listening.  (Of course if you have any suggestions on how to manage/filter through thousands of spam items/week, we’d like to know as well).
• Pingbacks were recently dropped when we upgraded to Wordpress 2.8.  Miss them?  We’ve turned them back on.
• Our training sales for Santa Clara and San Francisco are going well.  As a result we’re planning to have an east coast location at some point in the future.  Please feel free to comment where you would like that to be!
• We have notified the winners of of our training competition.  I wanted to share their comments:
  My favorite Percona patch : innodb fast recovery patch. Reason: Innodb recovery has always been a big headache for any DBA since it used to take ages to complete a recovery after crash. Now with the patch I am able to do a recovery in less than a tenth of the time it used to take. Great job by Yasufumi in hacking the code(not just this patch ) which has been a nightmare for all DBA's.

  And:

  My favorite patch is "Micro second slow query patch" as it actively allows me to identify the queries which takes few seconds to execute but their frequencies is just too high i.e. few hundred times a hour. By optimizing these queries I can freeup the server resources to do other useful work.


• A the last item is a reminder: the deadline for our early bird registration on training is Monday.

Entry posted by Morgan Tocker | No comment

Add to: | | | |

Dear Community,

The release 0.9 of the opensource backup tool for InnoDB and XtraDB is available for download.

Changelog:

• tar4ibd could not treat over 8GB file, now max 64GB
• prepare-speed-hack is added

Fixed bugs:

• Bug #386179: “InnoDB: Error: space id in fsp header 143088, but in the page header 0″
• Bug #394374: “Can’t compile with MySQL 5.1″
• Bug #394781: “xtrabackup requires write permissions on original ibdata1″
• Bug #395977: “xtrabackup 0.8 crashes during prepare after tar4ibd”
• Bug #396069: “hardcoded XTRABACKUP_VERSION”
• Bug #395407: “innobackupex reports “perl is too old””
• Bug #408966: “Unclear license terms”
• Bug #389360: “Partition files not being copied in innobackupex-1.5.1”
• Bug #394464: “batch scp copy of .frm, .MRG etc files”

The binary packages for RHEL4,5, Debian, FreeBSD, MacOS as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9/.

The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.

For general questions use our Pecona-discussions group, and for development question Percona-dev group.

For support, commercial and sponsorship inquiries contact Percona.

Entry posted by Aleksandr Kuzminsky | No comment

Add to: | | | |

I will be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application.

We also will have the raffle for 2 tickets for Performance Optimization for MySQL with Innodb and XtraDB Single Day Intense Training Workshop for either Santa Clara or San Francisco locations.

Entry posted by peter | No comment

Add to: | | | |

Today, we are announcing that we’re ready to offer training for InnoDB and XtraDB in Santa Clara and San Francisco.  The course was developed by Morgan Tocker with input from all our team – and covers a lot of the performance problems we run through in our consulting practice.

The Details:

14th Sept – Santa Clara Hilton
1 day intensive course
Cost: $300*

16th Sept – San Francisco
1 day intensive course
Cost: $300*

(* includes a copy of High Performance MySQL if you register before 31st Aug).

The delivery format:

Being only one day, we elected to deliver the course in a predominately lecture-format – but there will be a few opportunities to try examples.  For more information see the Percona Website.

Get a Free ticket!
We’re giving away the first two tickets to readers of our blog.  To enter, send an email to contest[at]percona.com or Twitter @Percona before August 10th to explain what your favorite Percona patch is and why. Yasufumi Kinoshita has kindly accepted to be our judge – which should make things interesting!

Entry posted by morgan | No comment

Add to: | | | |