by Stephane Combaudon | Jul 22, 2015 | MySQL, Percona Software
I recently worked with a customer who had a weird issue: when their MySQL server was started (Percona Server 5.5), if they try to run service mysql start a second time, the init script was not able to detect that an instance was already running. As a result, it tried...
by Tom Diederich | Jul 21, 2015 | MongoDB, MySQL
Today Percona announced the immediate availability of 24/7, enterprise-class support for MongoDB and TokuMX. The new support service helps organizations achieve maximum application performance without database bloat. Customers have round-the-clock access (365 days a...
by Roel Van de Paar | Jul 21, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh...
by Kortney Runyan | Jul 20, 2015 | MySQL, Percona Events, Percona Live
The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible event. With a new expanded focus on MySQL, NoSQL, and Data in the Cloud, this conference will be jam-packed with talks from some of the industry’s...
by Vadim Tkachenko | Jul 20, 2015 | MongoDB, Percona Software
As you may know, Tokutek is now part of Percona and I would like to explain some internals of TokuDB and TokuMX – what performance benefits they bring, along with further optimizations we are working on. However, before going into deep details, I feel it is...
by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
In my previous post, I used incremental backups in Percona XtraBackup as a method for rebuilding a Percona XtraDB Cluster (PXC) node without triggering an actual SST. Practically this reproduces the SST steps, but it can be handy if you already had backups available...
by Jay Janssen | Jul 16, 2015 | MySQL, Percona Software
Beware the SST In Percona XtraDB Cluster (PXC) I often run across users who are fearful of SSTs on their clusters. I’ve always maintained that if you can’t cope with a SST, PXC may not be right for you, but that doesn’t change the fact that SSTs with...
by Roel Van de Paar | Jul 15, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode #6! Today we will look into analyzing and filtering our QA run. We’ll use tools like pquery-prep-red.sh, pquery-clean-known.sh & pquery-results.sh 1. Quick re-cap and QA run setup 2. pquery-prep-red.sh 3. pquery-clean-known.sh 4....
by Vadim Tkachenko | Jul 14, 2015 | Benchmarks, MongoDB
In this post I’ll share the results of a sysbench-mongodb benchmark I performed on my server. I compared MMAP, WiredTiger, RocksDB and TokuMXse (based on MongoDB 3.0) and TokuMX (based on MongoDB 2.4) in an IO-intensive workload. The full results are available...
by Roel Van de Paar | Jul 13, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode #5! In this episode we’ll be setting up and running pquery for the first time… and I’ll also trigger some actual bugs (fun guaranteed)! I’ll also introduce you to mtr_to_sql.sh and pquery-run.sh. pquery-run.sh (the...
by Akshay Suryawanshi | Jul 10, 2015 | Insight for DBAs, MySQL, Webinars
Have you ever wondered what could happen if your MySQL database goes down? Although it’s evident such a crash will cause downtime – and surely some business impact in terms of revenue – can you do something to reduce this impact? The simple answer is...
by Tom Diederich | Jul 9, 2015 | MySQL, Percona Events, Percona Live
The conference and tutorial schedule for Percona Live Europe 2015, September 21-23 in Amsterdam, was published this morning and this year’s event will focus on MySQL, NoSQL and Data in the Cloud. Conference sessions, which will follow each morning’s keynote addresses,...
by Hrvoje Matijakovic | Jul 9, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.25-73.1 on July 9, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.25, including all the bug fixes in it, Percona Server 5.6.25-73.1...
by Fernando Ipar | Jul 9, 2015 | Insight for DBAs, MySQL
I recently helped a customer figure out why a minor version MySQL upgrade was indicating that some tables needed to be rebuilt. The mysql_upgrade program should be run for every upgrade, no matter how big or small the version difference is, but when only the minor...
by Roel Van de Paar | Jul 8, 2015 | Insight for DBAs, Insight for Developers, Percona Software
Welcome to MySQL QA Episode 4! In this episode we’ll look into setting up our QA Framework: percona-qa, pquery, reducer & more. 1. All about percona-qa 2. pquery Shell $ cd ~; bzr branch lp:percona-qa 1 $ cd ~; bzr branch lp:percona-qa 3. reducer.sh Shell $...
by Roel Van de Paar | Jul 7, 2015 | Insight for DBAs, Insight for Developers, MySQL
Welcome to MySQL QA Episode 3: “Debugging: GDB, Backtraces, Frames and Library Dependencies” In this episode you’ll learn how to use debugging tool GDB. The following debugging topics are covered: 1. GDB Introduction 2. Backtrace, Stack trace 3. Frames 4....
by Jay Janssen | Jul 6, 2015 | MySQL, Percona Software
I noticed that in the latest release of Percona XtraDB Cluster (PXC), the behavior of wsrep_OSU_method changed somewhat. Prior to this release, the variable was GLOBAL only, meaning to use it you would: mysql> set GLOBAL wsrep_OSU_method='RSU'; mysql> ALTER...
by Hrvoje Matijakovic | Jul 1, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.44-37.3 on July 1, 2015. Based on MySQL 5.5.44, including all the bug fixes in it, Percona Server 5.5.44-37.3 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Hrvoje Matijakovic | Jul 1, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.25-73.0 on July 1, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.25, including all the bug fixes in it, Percona Server 5.6.25-73.0...
by Vadim Tkachenko | Jul 1, 2015 | MongoDB, MySQL
Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical...
