by Terry Erisman | Apr 15, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
The Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and entertaining with the presentation of the Community Awards and the
by Alexey Stroganov | Apr 15, 2013 | Benchmarks, MySQL, Percona Software
In addition to the problem with trx_list scan we discussed in Friday’s post, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this...
by Alexey Kopytov | Apr 12, 2013 | Benchmarks, MySQL
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection...
by David Hildebrandt | Apr 12, 2013 | MySQL, Percona Events
If you are looking for a class that is designed to jump-start your knowledge on MySQL 5.6 features, a class that provides hands-on labs, and a class that shows various migration methods – look no further. We have been hard at work building a new class to ensure...
by Peter Zaitsev | Apr 11, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live
In preparing for this month’s Percona Live MySQL Conference and Expo, I’ve been reminiscing about the annual MySQL User Conference’s history – the 9 times it previously took place in its various reincarnations – and there are a lot of...
by Hrvoje Matijakovic | Apr 10, 2013 | MySQL
Percona is glad to announce the release of Percona Server for MySQL 5.5.30-30.2 on April 10, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.30, including all the bug fixes in it, Percona Server 5.5.30-30.2 is now the...
by Stewart Smith | Apr 10, 2013 | Cloud, Insight for DBAs, MySQL, Percona Software
We just released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups on the fly (full documentation here). This feature is different than simply piping the backup stream through the openssl or gpg binaries, which...
by Hrvoje Matijakovic | Apr 9, 2013 | MySQL
Percona is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to another....
by Tokutek | Apr 9, 2013 | MySQL
If T.S. Eliot were a MySQL DBA, I think he would have been more upbeat about April. We are gearing up for an incredible second half of April. We will be presenting three separate sessions at the Percona Live: MySQL Conference and Expo 2013, April 22-25, in Santa...
by Stewart Smith | Apr 8, 2013 | MySQL
This post was initially going to be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come up with your own...
by Stephane Combaudon | Apr 5, 2013 | MySQL, Percona Software, Webinars
I didn’t have time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are all of the questions and my answers. (A recording is available here.) Q: One of...
by Peter Zaitsev | Apr 4, 2013 | MySQL, Percona Live
This is my 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back in 2003), and for me it does not get tiring. So what is there in this conference for me as an attendee, speaker and...
by Zardosht.Kasheff | Apr 3, 2013 | MySQL
Earlier, I talked about the transactional semantics we are introducing to MongoDB. As I hinted at the end of the post, we are actually doing more. We are introducing multi-statement transactions. That’s right, multiple queries, updates, deletes, and inserts will be...
by Terry Erisman | Apr 3, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live
5.6 has redefined MySQL performance and usability. Some great talks at the Percona Live MySQL Conference and Expo will provide insight into the new features and benefits of this major release. The conference is April 22-25, 2013 at the Santa Clara Convention Center...
by Hrvoje Matijakovic | Apr 2, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL alpha on April 2, 2013. Downloads are available from our download site here. For this ALPHA release, we will not be making APT and YUM repositories available, just base deb and RPM packages...
by Zardosht.Kasheff | Apr 2, 2013 | MySQL
People claim that MongoDB is not transactional. It actually is, and that’s a good thing. In MongoDB 2.2, individual operations are Atomic. By having per database locks control reads and writes to collections, write operations on collections are Consistent and...
by Jay Janssen | Apr 1, 2013 | Percona Live, Percona Software
As is typical at the beginning of every April, many of us who submitted talks to the Percona Live MySQL Conference and Expo are wondering why we submitted so many. I had 3 official talks selected, including one that is a 6-hour tutorial, as well as a BoF....
by Mike Benshoof | Mar 29, 2013 | MySQL
A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static...
by Tim.Callaghan | Mar 28, 2013 | MySQL
Last month my colleague Rich Prohaska covered the technical details of our “Fast Update” feature which we added to TokuDB in version 6.6. The message based architecture of Fractal Tree Indexes allows us to defer certain operations while still maintaining...
by Terry Erisman | Mar 28, 2013 | MySQL, Percona Events, Percona Live
We’re very pleased with the speaker lineup for the Percona Live MySQL Conference and Expo. We have outstanding MySQL experts speaking on a variety of topics during the breakout sessions and tutorials. And the keynote speakers are all top notch, MySQL technology and...
