EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Monitoring and Management 1.3.0 Query Analytics Support for MongoDB

 | September 28, 2017 |  Posted In: Database Monitoring, MongoDB, Percona Monitoring and Management

Percona Monitoring and Management 1.3.0

Percona is pleased to announce the General Availability of Query Analytics (QAN) from Percona Monitoring and Management 1.3.0 (PMM). This new release introduces the support of MongoDB. In general, the purpose of QAN is to help detect queries that consume the most amount of time inside of your database server. It provides detailed real-time analysis of […]

Read More

Percona Live Europe Session Interview: Building Multi-Petabyte Data Warehouses with ClickHouse

 | September 27, 2017 |  Posted In: Percona Live, XtraDB Cluster

Percona Live Europe

Percona Live Europe provides open source professionals with an opportunity to discuss how various technologies get used in order to solve database problems. Alexander Zaitsev of LifeStreet/Altinity gave one such session: Building Multi-Petabyte Data Warehouses with ClickHouse. LifeStreet needed to scale their real-time ad analytics platform to multiple petabytes. They evaluated and used a number of […]

Read More

Percona Live Europe Session Interviews with Yandex ClickHouse: A DBMS for Interactive Analytics at Scale and Quick Tour of ClickHouse Internals

 | September 27, 2017 |  Posted In: Percona Live, Yandex ClickHouse

Percona Live Europe

Percona Live Europe 2017 keeps providing excellent sessions with useful information on great open source database technologies. Yandex’s Clickhouse was one of these technologies that was well covered at the conference this year. There were several talks that featured Clickhouse this year. I was able to attend two of them. The first was a discussion of […]

Read More

Pepper Turns to Percona to Ensure a Great Customer Experience at Pepper.com

 | September 27, 2017 |  Posted In: Events and Announcements, MySQL, Percona Managed Services, Percona MySQL Support, Percona Server, Percona XtraBackup

Pepper.com

Pepper.com, the world’s largest community deal platform, has selected Percona to manage its open source database performance. Pepper.com’s around-the-clock community seeks and finds the best offers in fashion, electronics, traveling and much more. With 500 million page views, over 25 million users and over 65,000 user-submitted deals per month across communities in America, Europe and […]

Read More

Percona Live Europe 2017 Keynotes Day One

 | September 26, 2017 |  Posted In: MongoDB, MySQL, open source databases, Percona Live, Percona Monitoring and Management

Percona Live Europe 2017 Keynotes

After yesterday’s very successful tutorial day, everyone looked forward to an inspiring first day of the conference and the Percona Live Europe 2017 keynotes. There were some fantastic keynotes delivered, and some excellent sessions scheduled. Laurie Coffin, Chief Marketing Office of Percona, opened proceedings with a welcome address where she paid tribute to Jaako Pesonen: […]

Read More

Percona Monitoring and Management 1.3.0 Is Now Available

 | September 26, 2017 |  Posted In: Events and Announcements, MongoDB, MySQL, Percona Live, Percona Monitoring and Management

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.3.0 on September 26, 2017. Percona Monitoring and Management 1.3.0 introduces basic support for the MyRocks storage engine. There is a special dashboard in Metrics Monitor that presents the essential metrics of MyRocks as separate graphs. Also, Metrics Monitor graphs now feature on-demand descriptions that remain visible as long […]

Read More

Avoid Shared Locks from Subqueries When Possible

 | September 25, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

Shared Locks

In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:

This query, when executed with autocommit=1, is normally harmless. However, this can have bad effects when combined with other statements in the […]

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.