by Hrvoje Matijakovic | Nov 11, 2013 | MySQL
Percona Server 5.6.11-60.3 has introduced a new feature called Log Archiving for XtraDB. This feature makes copies of the old log files before they are overwritten, thus saving all the redo log for a write workload. When log archiving is enabled, it duplicates all...
by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Software
8PM. One of the servers found a critical bug. Hop online and discuss, log bug. 10PM. Patch ready. 10:30PM. New build ready. 10:45PM. New RQG run initiated. This was by no means an uncommon sight during the months of testing that went into Percona Server 5.6, in fact...
by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL
How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination of them? For example: will a different innodb_log_file_size combined with more innodb_log_files_in_group and a modified innodb_fast_shutdown setting...
by Roel Van de Paar | Nov 11, 2013 | Insight for DBAs, Insight for Developers, MySQL
This post builds on the How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump? post written about a year ago. A day after that post was released, Shane Bester wrote an improved version, How to obtain all executing queries from a core file on...
by Dave Rosenlund | Nov 8, 2013 | MySQL
Attending Percona Live in London next week? Don’t miss the chance to hear Tokutek’s Vice President of Engineering, Tim Callaghan, discuss how to use your MySQL knowledge to become an instant MongoDB Guru and the advantages of using Fractal Tree® indexes in...
by Zardosht.Kasheff | Nov 7, 2013 | MySQL
From the application’s perspective, TokuMX behaves very similarly, if not identically, to MongoDB in many ways. But in one subtle yet important way, on non-sharded clusters, TokuMX is different. With MongoDB, operations on each single document are transactional. With...
by Hrvoje Matijakovic | Nov 7, 2013 | MySQL, Percona Software
Percona Server has implemented per-query variable statement support in version 5.6.14-62.0. This feature provides the ability to set variable values only for a certain query, after execution of which the previous values will be restored. Per-query variable values can...
by Frederic Descamps | Nov 6, 2013 | MySQL
As every year in February, in Brussels, the FOSDEM will take place! And as every year, the MySQL Community will also be present! For the 3rd year in a row, I have the honour of organising the MySQL & Friends Devroom. Let’s start with the most important...
by Daniel Nichter | Nov 5, 2013 | Cloud, MySQL, Percona Software
I am proud to announce Percona Cloud Tools, the next generation of tools for MySQL. I have been developing tools for MySQL for 10 years. For the last 5 years, I have been developing Percona Toolkit (formerly “Maatkit”). Almost 1 year ago, we began...
by Michael Rikmas | Nov 5, 2013 | Insight for DBAs, MySQL
A few years ago Yves Trudeau and Aleksandr Kuzminsky wrote posts about different ways for recovering orphaned .ibd files: Connecting orphaned .ibd files A recovery trivia or how to recover from a lost ibdata1 file Today I want to show you how to do that in a more easy...
by Hrvoje Matijakovic | Nov 4, 2013 | MySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.34-23.7.6 on November 4, 2013. Binaries are available from the downloads area or from our software repositories. Bugs Fixed: Fixed the issues with upgrade on Debian caused by debian-start script....
by Daniel Nichter | Nov 1, 2013 | MySQL, Percona Software
In this post I wanted to highlight percona.com/bugs/<tool> , for example: percona.com/bugs/pt-stalk. This only works for Percona Toolkit. We often advise people to check a tool’s current bugs, but we don’t always say how. The official link for...
by Zardosht.Kasheff | Oct 31, 2013 | MySQL
Since our initial release last summer, TokuMX has supported fully ACID and MVCC multi-statement transactions. I’d like to take this post to explain exactly what we’ve done and what features are now available to the user. But before beginning, an important note: we...
by Jay Janssen | Oct 31, 2013 | MySQL, Percona Software
The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes. Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes....
by Dave Rosenlund | Oct 30, 2013 | MySQL
You love MySQL for its ease of deployment – but are you worried about how your application will perform when it starts to scale? SPEAKER: Gerry Narvaja, Tokutek DATE: Wednesday, November 6th TIME: 1pm ET Register Now! Join this interactive webinar with Gerry...
by Alexey Stroganov | Oct 30, 2013 | MySQL, Percona Software
In MySQL 5.6 InnoDB has a dedicated thread (page_cleaner) that’s responsible for performing flushing operations. Page_cleaner performs flushing of the dirty pages from the buffer pool based on two factors: – access pattern – the least recently used...
by Fernando Ipar | Oct 29, 2013 | Insight for DBAs, Percona Events, Webinars
Next week, on Nov. 6, I will be delivering a webinar about running MySQL on Windows, with a strong focus on Linux-based sysadmins and DBAs – and how not to go crazy in the process. An interesting (and challenging!) part of working for Percona is that you never...
by Stephane Combaudon | Oct 28, 2013 | MySQL, Webinars
I want to thank all attendees of my webinar, “MySQL 5.6 New Replication Features: Benefits, Challenges and Limitations”. We had questions that I didn’t have the time to answer: Q: If I run on Amazon’s RDS, do I need to worry about enabling...
by Hrvoje Matijakovic | Oct 28, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.34-32.0 on October 28th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.34, including all the bug fixes in it, Percona Server 5.5.34-32.0 is now the...
by Hrvoje Matijakovic | Oct 28, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.72-14.10 on October 28th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.72, including all the bug fixes in it, Percona Server 5.1.72-14.10 is now the...
