EmergencyEMERGENCY? Get 24/7 Help Now!

High-load clusters and desynchronized nodes on Percona XtraDB Cluster

 | August 31, 2015 |  Posted In: MySQL, Percona XtraDB Cluster

There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons.  This can happen a few ways: An IST or SST joining node catching up after a state transfer (Joined/Joining state) Using wsrep_desync for something like a backup Executing a rolling-schema-upgrade using […]

Read More

Percona Toolkit 2.2.15 is now available

 | August 28, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is pleased to announce the availability of Percona Toolkit 2.2.15.  Released August 28, 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 perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is […]

Read More

ObjectRocket’s David Murphy talks about MongoDB, Percona Live Amsterdam

 | August 26, 2015 |  Posted In: MongoDB, Percona Live

Say hello to David Murphy, lead DBA and MongoDB Master at ObjectRocket (a Rackspace company). David works on sharding, tool building, very large-scale issues and high-performance MongoDB architecture. Prior to ObjectRocket he was a MySQL/NoSQL architect at Electronic Arts. David enjoys large-scale operational tool building, high performance OS and database tuning. He is also a […]

Read More

Advanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&A

 | August 24, 2015 |  Posted In: MySQL, Technical Webinars

Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions). Q: Here is the explain example:

why is site_id a covered index for […]

Read More

Find unused indexes on MongoDB and TokuMX

 | August 21, 2015 |  Posted In: MongoDB

Finding and removing unused indexes is a pretty common technique to improve overall performance of relational databases. Less indexes means faster insert and updates but also less disk space used. The usual way to do it is to log all queries’ execution plans and then get a list of those indexes that are not used. […]

Read More

Featured Talk: The Future of Replication is Today: New Features in Practice

 | August 18, 2015 |  Posted In: Events and Announcements, Percona Live, Replication

In the past years, both MySQL 5.6, MySQL 5.7 and MariaDB 10 have been successful implementing new features. For many DBAs, the “old way” of replicating data is comfortable so taking the action to implement these new features seems like a momentous leap rather then a simple step. But perhaps it isn’t that complicated… Giuseppe […]

Read More

MySQL is crashing: a support engineer’s point of view

and  | August 17, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

Read More

The language of compression

 | August 13, 2015 |  Posted In: Events and Announcements, MySQL, Percona Live

Storage. Everyone needs it. Whether your data is in MySQL, a NoSQL, or somewhere in the cloud, with ever-growing data volumes – along with the need for SSDs to cut latency and replication to provide insurance – an organization’s storage footprint is an important place to look for savings. That’s where compression comes in (squeeze!) […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.