by Emily Ikuta | Dec 30, 2015 | MySQL, Webinars
Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue? In our upcoming webinar Tired of...
by Kortney Runyan | Dec 29, 2015 | Cloud, Insight for DBAs, MongoDB, Percona Events, Percona Live
We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, including insights into InnoDB, MySQL...
by Sveta Smirnova | Dec 29, 2015 | Insight for DBAs, MySQL
by Sveta Smirnova | Dec 28, 2015 | Insight for DBAs, MySQL
by Vadim Tkachenko | Dec 23, 2015 | MongoDB, MySQL
We recently released the GA version of Percona Server for MongoDB, which comes with a variety of storage engines: RocksDB, PerconaFT and WiredTiger. Both RocksDB and PerconaFT are write-optimized engines, so I wanted to compare all engines in a workload oriented...
by Sveta Smirnova | Dec 22, 2015 | Insight for DBAs, MySQL
by Przemysław Malkowski | Dec 21, 2015 | Insight for DBAs, MySQL, Percona Software
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of...
by Jervin Real | Dec 18, 2015 | Insight for DBAs, MySQL
Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a quick...
by Kortney Runyan | Dec 17, 2015 | Percona Events, Percona Live
On behalf of the Percona Live Conference Committee, I am excited to announce the sneak peek schedule for the Percona Live Data Performance Conference and Expo 2016! Percona Live Data Performance Conference and Expo Live 2016 will feature a variety of formal tracks and...
by Sveta Smirnova | Dec 17, 2015 | Insight for DBAs, MySQL
by Hrvoje Matijakovic | Dec 17, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.3.3 on December 17th, 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 Alok Pathak | Dec 16, 2015 | Insight for DBAs, MySQL
We work on data recoveries quite often. In many cases, we recover table structures from the .frm files because there was no backup available. There is already a great blog post by my colleague Miguel Ángel Nieto about how we can recover structures from .frm files...
by Kortney Runyan | Dec 15, 2015 | Insight for DBAs, Percona Live
Our Super Saver discount rate for Percona Live 2016 is only available ‘til December 31st! This rate gets you all the excellent and amazing opportunities that Percona Live offers, at a discount. The Percona Live Data Performance Conference is the premier open source...
by Vadim Tkachenko | Dec 15, 2015 | Benchmarks, MongoDB
MongoDB 3.2 was recently released with WiredTiger as the default storage engine. In just over five years, MongoDB has evolved into a popular database. MongoDB 3.0 supported “pluggable storage engines.” The B-Tree-based WiredTiger should outperform IO-optimized RocksDB...
by Sveta Smirnova | Dec 14, 2015 | Insight for DBAs, MySQL
by Hrvoje Matijakovic | Dec 14, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the first release candidate of Percona Server 5.7.10-1 on December 14, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. This release contains all the bug fixes from latest Percona Server...
by Alexey Zhebel | Dec 14, 2015 | MongoDB, Percona Events, Percona Software
Percona is pleased to announce the GA release of Percona Server for MongoDB 3.0.7-1.0 on December 14, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully...
by Sveta Smirnova | Dec 10, 2015 | Insight for DBAs, MySQL
At the end of my talk LinuxPiter conference, a user asked me a question: “What does the EXPLAIN ‘filtered’ field mean, and how do I use it?” I explained that this is the percentage of rows that were actually needed, against the equal or bigger...
by Sveta Smirnova | Dec 8, 2015 | Insight for DBAs, MySQL
When you work with complicated queries, especially ones which contain subqueries, it is easy to make a typo or misinterpret column name. While in many cases you will receive a column not found error, sometimes you can get strange results instead. Like finding 4079...
by Hrvoje Matijakovic | Dec 4, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.27-76.0 on December 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.27, including all the bug fixes in it, Percona Server...
