English
| Showing entries 1 to 30 of 98 | Next 30 Older Entries |
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 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...]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...]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...]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...]
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:
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:
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.
cd C:\mariadb-5.1
win\configure.js
cmake .
That’s it.
Let’s fire it up:
MariaDB> select version(); +----------------------+ | version() |
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/2011MySQL 5.5:
MySQL [Read more...]Percona Server version 5.1.55-12.6 is now available for download. It is now the current stable release version.
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:
In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases:
Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.
Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version.
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...]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 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.
Release Notes for this and previous releases can be found in our
[Read more...]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:
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...]Percona Server version 5.1.52-12.3 is now available for download.
The main purpose of this release is to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server.
Percona XtraBackup 1.5-Beta is now available for download.
This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup.
This is a beta release.
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not - it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona Server however adds number of tables to Information Schema which makes this information possible. It is just few queries away:
PLAIN TEXT SQL:Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so using less space,
it is just OPTIMIZE TABLE might not be best way to do it.
If you're running Innodb Plugin on Percona Server with XtraDB you get benefit of a great new feature - ability to build indexes by sort instead of via insertion. This process can be a lot faster, especially for large indexes which would get inserts in very random order, such as indexes on UUID column or something similar. It also produces a lot better fill factor. The problem is.... OPTIMIZE TABLE for Innodb tables does not get advantage of it for whatever reason.
Lets take a look at little benchmark I done by running OPTIMIZE for a second time on a table
[Read more...]Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0.
Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL 5.0 is still actually question for many users, so I accepted invitation. Event details are on Meetup.com page. So if you are up for free pizza, soda and do not mind to listen to me, welcome to join!
Entry posted by Vadim | No comment
Add to:
[Read more...]Percona Server version 5.1.52-rel11.6 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.
I do not know if it is because we're hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb.
Webinar will cover the process in a lot more details though I would like to go over basics in advance. You can also check my old post on this topic about Moving MyISAM to Innodb as well as searching the blog - We've blogged so much on this topic.
So what are the basics ?
Regression Benchmarks - Make sure to run regression benchmarks in particular in terms of
[Read more...]
-0
Percona XtraBackup 1.4 is now available for download.
Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it's strongly recommended that you upgrade to this release.
The open-source xtrabackup tool from Percona brings much needed hot backup functionality to MySQL deployments. In this database journal article we discuss logical, cold, and hot backups, then explain how to use xtrabackup on your MyISAM, InnoDB, and XtraDB tables to create at-the-ready backups. We then take you through the step-by-step process to restore them, and even the process of point-in-time recovery too.
Percona Community,
Percona Server version 5.1.51-rel11.5 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.
The
[Read more...]We've published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under much more traffic, the database is still outperforming their previous version.
I thought I'd write a few notes that didn't seem appropriate to include in the case study, because this was a fun project that might be interesting to readers.
As usual, it was all about diagnosing the problem correctly. I used a variety of tools to help with this, foremost among them "stalk" and "collect" from Aspersa. There were several problems, not just one, and they required
[Read more...]| Showing entries 1 to 30 of 98 | Next 30 Older Entries |
