Search Results for: slow remote query

What do we optimize with mk-query-digest ?

When we’re looking at mk-query-digest report we typically look at the Queries causing the most impact (sum of the query execution times) as well as queries having some longest samples. Why are we looking at these ? Queries with highest Impact are important because looking at these queries and optimizing them typically helps to improve […]

Measuring the impact of tcpdump on Very Busy Hosts

A few years back Deva wrote about how to use tcpdump on very busy hosts. That post sparked my interest about exploring how to measure the impact of tcpdump on very busy hosts. In this post, I wanted to highlight how much of an impact there really is and what options you¬†have to make the […]

Percona XtraDB Cluster 5.6 GA release now available

Percona is pleased to announce the first General Availability release of¬†the leading open source High Availability solution for MySQL,¬†Percona XtraDB Cluster 5.6 on January 30, 2014. Binaries are available from downloads area or from our software repositories. Percona XtraDB Cluster 5.6 Percona XtraDB Cluster 5.6 is an active/active cluster solution for High Availability (HA) MySQL […]

Introducing Percona Cloud Tools for MySQL

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 developing Percona Cloud Tools (PCT), first in-house, then in private beta, […]

Percona Toolkit for MySQL Webinar Followup Questions

I didn’t have time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit¬†Tools That Could Save Your Day,” but as promised, here are all of the questions and my answers. (A recording is available here.) Q: One of the links to download the Percona Toolkit for MySQL (percona.com/get/percona-toolkit.tgz) doesn’t work! A: […]

MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. ¬†Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user or cart object built from several queries) Infrequently […]

Announcing Percona Server 5.1.66-14.2

Percona is glad to announce the release of¬†Percona Server¬†5.1.66-14.2 on January 15th, 2013 (Downloads are available¬†here¬†and from the¬†Percona Software Repositories). Based on¬†MySQL 5.1.66, including all the bug fixes in it,¬†Percona Server¬†5.1.66-14.2 is now the current stable release in the 5.1 series. All of¬†Percona‘s software is open-source and free, all the details of the release can […]

Announcing Percona Server 5.5.28-29.3

Percona is glad to announce the release of¬†Percona Server¬†5.5.28-29.3 on January 8th, 2012 (Downloads are available¬†here¬†and from the¬†Percona Software Repositories). Based on¬†MySQL 5.5.28, including all the bug fixes in it,¬†Percona Server¬†5.5.28-29.3 is now the current stable release in the 5.5 series. All of¬†Percona‘s software is open-source and free, all the details of the release can […]