by Brock Wilson | Feb 24, 2015 | Benchmarks, MySQL, Percona Services, Percona Software
MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many...
by Tom Diederich | Feb 23, 2015 | MySQL, Percona Events, Percona Live
Have designs on Percona Live this April in Silicon Valley? Send them to us! The winning entry will appear on a cool limited edition t-shirt that we’ll award to a few dozen lucky recipients at our booth’s new Percona T-Shirt Bar. The winner will also get a...
by Fernando Laudares Camargos | Feb 20, 2015 | Insight for DBAs, MySQL, Percona Software
This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as
by Matt Griffin | Feb 18, 2015 | Insight for DBAs, MySQL, Percona Events
Percona has submitted seven talks for the next Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free MySQL and OpenStack Deep Dive Speakers: Peter Boros, Jay Pipes (Mirantis) MySQL on Ceph...
by Justin Swanhart | Feb 17, 2015 | MySQL
by Joe.Laflamme | Feb 11, 2015 | MySQL
Section I: Fractal Tree and Optimization Overview Tokutek’s Fractal Tree® technology provides fast performance by injecting small messages into buffers inside the Fractal Tree index. This allows writes to be batched, thus eliminating I/O that is required in...
by Stephane Combaudon | Feb 10, 2015 | Insight for DBAs, MySQL, Percona Software
Global Transaction IDs (GTIDs) are one of my favorite features of MySQL 5.6. The main limitation is that you must stop all the servers at the same time to allow GTID-replication. Not everyone can afford to take a downtime so this requirement has been a showstopper for...
by Rich.Prohaska | Feb 5, 2015 | MySQL
In the recently released TokuDB 7.5.5 the implementation of TokuDB hot-backup moved from a patch to the MySQL Server, to MySQL Plugin. Why did we make this change? TokuDB hot backup makes a transactionally consistent copy of the TokuDB files while applications...
by Kortney Runyan | Feb 3, 2015 | MySQL, Percona Live
It’s hard to believe that the Percona Live MySQL Conference and Expo is just over two months away (April 13-16 in Santa Clara, California). So if you’ve been thinking about submitting a proposal for the popular “Lightning Talks” and/or...
by Kortney Runyan | Jan 30, 2015 | Insight for DBAs, MySQL, Percona Live
This April 13-14 Percona is introducing an annual conference called OpenStack Live. I’ve seen a few questions about the new event so decided to help clarify what this show is about and who should attend. Unlike OpenStack Summits, held twice a year and dedicated to...
by David Busby | Jan 29, 2015 | MySQL, Security
Cloud security company Qualys announced Tuesday the issues prevalent in glibc since version 2.2 introduced in 2000-11-10 (the complete Qualys announcement may be viewed here). The vulnerability, CVE-2015-0235, has been dubbed “GHOST.” As the announcement...
by Stephane Combaudon | Jan 29, 2015 | Insight for DBAs, MySQL
MySQL 5.6 allows you to execute replicated events in parallel as long as data is split across several databases. This feature is named “Multi-Threaded Slave” (MTS) and it is easy to enable by setting slave_parallel_workers to a > 1 value. However if you...
by Peter Zaitsev | Jan 27, 2015 | Insight for DBAs, MariaDB, MySQL
About two years ago we held our first-ever Percona University event in Raleigh, N.C. It was a great success with high attendance and very positive feedback which led us to organize a number of similar educational events in different locations around the world. And...
by Hrvoje Matijakovic | Jan 26, 2015 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.13. Released January 26, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to...
by Michael Coburn | Jan 23, 2015 | MySQL, Percona Software
For months when speaking with customers I have been positioning Percona Cloud Tools (PCT) as a valuable tool for the DBA/Developer/SysAdmin but only recently have I truly been able to harness the data and make a technical recommendation to a customer that I feel would...
by Jon Tobin | Jan 22, 2015 | MySQL
Welcome to blog #2 in a series about the benefits of the Fractal Tree. In this post, I’ll be explaining Big Data, why it poses such a problem and how Tokutek can help. Given the fact that I am a lifelong fan of both Hip-hop and Big Data, the title was a no-brainer...
by Alok Pathak | Jan 20, 2015 | Insight for DBAs, MySQL
As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary logs – and there are a number of reasons for doing that. In this post, I’ll explain how you can get the important information about your write workload using MySQL row-based binary...
by Jon Tobin | Jan 15, 2015 | MySQL
In my recent travels, I’ve been speaking with database users at various meetups and trade shows worldwide. Very often, I got questions centering around the best use cases for our products, be it TokuDB, our MySQL storage engine, or, TokuMX, our distribution of...
by Aurimas Mikalauskas | Jan 15, 2015 | Benchmarks, Insight for DBAs, MySQL
The other day a customer asked me to do capacity planning for their web server farm. I was looking at the CPU graph for one of the web servers that had Hyper-threading switched ON and thought to myself: “This must be quite a misleading graph – it shows 30%...
by Hrvoje Matijakovic | Jan 14, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.8 on January 14, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
