EmergencyEMERGENCY? Get 24/7 Help Now!

3 handy tools to remove problematic MySQL processes

 | February 27, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server

DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. I will highlight all of the tools via some […]

Read More

Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?

and  | February 26, 2015 |  Posted In: InnoDB, Insight for DBAs, MySQL

If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them:

Worry not as this is mostly harmless. It’s becoming a February tradition for me (Fernando) […]

Read More

Increasing Cloud Database Efficiency – Like Crows in a Closet

 | February 25, 2015 |  Posted In: Solutions Engineering, Tokutek, TokuView

In Mo’ Data, Mo’ Problems, we explored the paradox that “Big Data” projects pose to organizations and how Tokutek is taking an innovative approach to solving those problems. In this post, we’re going to talk about another hot topic in IT, “The Cloud,” and how enterprises undertaking Cloud efforts often struggle with idea of “problem […]

Read More

Is MySQL’s innodb_file_per_table slowing you down?

 | February 24, 2015 |  Posted In: Benchmarks, InnoDB, MySQL, Percona MySQL Consulting, Percona Server

MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many of you in the audience are responsible for running automated tests on your […]

Read More

How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)

 | February 20, 2015 |  Posted In: GTID, MySQL, Percona XtraBackup, Percona XtraDB Cluster

This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM tables (and FLUSH PRIVILEGES!) issued on a giving node of the cluster are recorded on a GTID set […]

Read More

More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar)

 | February 19, 2015 |  Posted In: MySQL, Percona XtraBackup

In a previous post, titled “Multi-threaded replication with MySQL 5.6: Use GTIDs,” I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Let’s see now how to perform the day-to-day operations when MTS and GTIDs are both enabled. (I’ll also be presenting a related webinar next week titled “Multi-threaded Replication […]

Read More

Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23)

 | February 18, 2015 |  Posted In: Events and Announcements, MySQL, OpenStack

Percona has submitted seven talks for the next OpenStack Summit in Vancouver this May. And as with all OpenStack Summit events, the community decides the content. Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free here. Percona’s Vancouver OpenStack Summit proposals Percona’s […]

Read More

Percona XtraBackup 2.2.9 is now available

 | February 17, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup

Percona is glad to announce the release of Percona XtraBackup 2.2.9 on February 17, 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 companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More