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...
by Peter Zaitsev | Jan 14, 2015 | Benchmarks, MySQL
Over the past few months I’ve written a couple of posts about dangerous debt of InnoDB Transactional History and about the fact MVCC can be the cause of severe MySQL performance issues. In this post I will cover a related topic – InnoDB Transaction...
by Kortney Runyan | Jan 13, 2015 | MySQL, Percona Live
Today we announced the full conference sessions schedule for April’s Percona Live MySQL Conference & Expo 2015 and this year’s event, once again at the Hyatt Regency Santa Clara and Santa Clara Convention Center, looks to be the biggest yet with networking and...
by Hrvoje Matijakovic | Jan 12, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.22-71.0 on January 12, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server...
by Roman Vynar | Jan 7, 2015 | Insight for Developers, MySQL
This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes. Shortly, more about the problem. After reading the official documentation...
by Miguel Angel Nieto | Jan 6, 2015 | Insight for DBAs, MySQL
We have been using SHOW ENGINE INNODB MUTEX command for years. It shows us mutex and rw-lock information that could be useful during service troubleshooting in case of performance problems. As Morgan Tocker announced in his blog post the command will be removed from...
by Przemysław Malkowski | Jan 5, 2015 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be several reasons for that, where I think the most common is when a new version should spend some time in testing or a staging environment before...
by Stephane Combaudon | Dec 30, 2014 | MySQL, Percona Software
State Snapshot Transfer (SST) is used in Percona XtraDB Cluster (PXC) when a new node joins the cluster or to resync a failed node if Incremental State Transfer (IST) is no longer available. SST is triggered automatically but there is no magic: If it is not configured...
by Bill Karwin | Dec 29, 2014 | Insight for DBAs, MySQL, Percona Software
Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?” He used some special INFORMATION_SCHEMA tables developed for Percona Server 5.1 to report how much of each InnoDB table and index resides in your...
by Joel.Epstein | Dec 23, 2014 | MySQL
The MySQL 5.6 Release has introduced some changes to how two phase commit works and is managed. In particular, the commit phase of transactions to the binary log is now serialized and this behavior is something we identified fairly immediately. We implement a group...
by David Busby | Dec 23, 2014 | Insight for DBAs, MySQL, Security
This is a long overdue blog post from London’s 44con Cyber Security conference back in September. A lot of old memories were brought to the front as it were; the one I’m going to cover in this blog post is: file carving. So what is file carving? despite...
