Please join Percona Principal Support Engineer Marcos Albe as he presents his talk “Flame Graphs 2013 on Thursday, August 22th, 2019 at 11:00 AM PDT (UTC-7). Register Now Visualizing profiling information can be a very powerful tool for performance diagnostics, especially if we zoom right into the problem. Flame graphs were developed for this purpose [&]

https://www.percona.com/blog/2019/08/20/webinar-advanced-techniques-to-profile-and-visualize-with-flame-graphs/

Our latest white paper The Hidden Costs of Not Properly Managing Your Databases discusses the potential losses that you can incur if you do not have a properly configured database and infrastructure setup. A Google study recently found that if an application does not respond in three seconds or less, more than half of mobile [&]

https://www.percona.com/blog/2019/08/20/impact-of-downtime-on-your-business/

Percona is excited to announce the beta release of Percona Distribution for PostgreSQL 11 on August 19, 2019. This release signifies a change in Percona’s software release process. In order to provide a full-featured and holistic solution, we are introducing a product distribution: a database product and tools that enable solving essential practical tasks efficiently. [&]

https://www.percona.com/blog/2019/08/19/percona-distribution-for-postgresql-11-beta-is-now-available/

If you’ve been waiting to see the schedule before you commit to a ticket, wait no longer! With just a few spots to be confirmed before release, the bulk of the Percona Live Europe 2019 agenda can now be seen. We’ve said it before, but the quality of the submissions was high and it’s been [&]

https://www.percona.com/blog/2019/08/19/percona-live-europe-2019-schedule/

Editors Note: The first version of this post contained a section criticizing what appeared to be a major regression concerning dropDatabase and movePrimary commands. It was found out that it was merely a documentation error in the MongoDB 4.2 release notes, which is now fixed: https://jira.mongodb.org/browse/DOCS-12474. The (In)Stability section is now removed. At Percona weve [&]

https://www.percona.com/blog/2019/08/16/long-awaited-mongodb-4-2-ga-has-landed/

Percona announces the release of Percona Server for MySQL 8.0.16-7 on August 15, 2019 (downloads are available here and from the Percona Software Repositories). This release is based on MySQL 8.0.16. It includes all bug fixes in these releases. Percona Server for MySQL 8.0.16-7 is now the current GA release in the 8.0 series. All of Percona’s [&]

https://www.percona.com/blog/2019/08/15/percona-server-for-mysql-8-0-16-7-is-now-available/

We have been writing blog posts about how to write simple extensions in C language and a little more complex one by Ibrar which were well received by PostgreSQL user community. Then we observed that many PostgreSQL users create simple triggers for small auditing requirements, and then feel the pain of trigger on transactions. So [&]

https://www.percona.com/blog/2019/08/15/faster-lightweight-trigger-function-in-c-for-postgresql/

In this post, we will manage ProxySQL Cluster with core and satellite nodes. What does that mean? Well, in hundreds of nodes, only one change in one of those nodes will replicate to the entire cluster. Any mistake or changes will replicate to all nodes, and this can make it difficult to find the most [&]

https://www.percona.com/blog/2019/08/14/how-to-manage-proxysql-cluster-with-core-and-satellite-nodes/

In this post, we will manage ProxySQL Cluster with core and satellite nodes. What does that mean? Well, in hundreds of nodes, only one change in one of those nodes will replicate to the entire cluster. Any mistake or changes will replicate to all nodes, and this can make it difficult to find the most [&]

https://www.percona.com/blog/2019/08/14/how-to-manage-proxysql-cluster-with-core-and-satellite-nodes/

While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important. In comparing MySQL 8 vs MySQL 5.7, you [&]

https://www.percona.com/blog/2019/08/14/mysql-8-and-mysql-5-7-memory-consumption-on-small-devices/

While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important. In comparing MySQL 8 vs MySQL 5.7, you [&]

https://www.percona.com/blog/2019/08/14/mysql-8-and-mysql-5-7-memory-consumption-on-small-devices/

To set correct system variable values is the essential step to get the correct server behavior against the workload. In MySQL, we have many System variables that can be changed at runtime, and most of them can be set at the session or global level. To change the value of a system variable at the [&]

https://www.percona.com/blog/2019/08/13/set-persist-in-mysql/

ProxySQL 2.0.5, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includes Docker images for release 2.0.5 are available as well. You can in the wiki format. ProxySQL 2.0.5 Improvements PSQLADM-51: Update mysql-server_version [&]

https://www.percona.com/blog/2019/08/12/proxysql-2-0-5-and-proxysql-admin-tool/

ProxySQL 2.0.5, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includes Docker images for release 2.0.5 are available as well. You can in the wiki format. ProxySQL 2.0.5 Improvements PSQLADM-51: Update mysql-server_version [&]

https://www.percona.com/blog/2019/08/12/proxysql-2-0-5-and-proxysql-admin-tool/

Percona announces the release of Percona Server for MongoDB 3.4.22-2.20 on August 9, 2019. Download the latest version from the Percona website or the Percona software repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. [&]

https://www.percona.com/blog/2019/08/09/percona-server-for-mongodb-3-4-22-2-20-now-available/

Percona is glad to announce the release of Percona XtraBackup 8.0.7 on August 7, 2019. You can download it from our download site and apt and yum 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. [&]

https://www.percona.com/blog/2019/08/07/percona-xtrabackup-8-0-7-is-now-available/

We had an amazing response to our Call for Papers for Percona Live Europe, offering talks of incredible breadth and depth. Our European open source database conference rivals its North American cousin in the number and quality of submissions, which has made it an incredibly tough job for the volunteer Committee – thank you, again [&]

https://www.percona.com/blog/2019/08/07/percona-live-europe-2019-sneak-peek/

Creating an index on a MongoDB collection is simple; just run the command CreateIndex and thats all there is to it. There are several index types available, and in a previous post, you can find the more important index types: MongoDB index types and explain(). The command is quite simple, but for MongoDB, building an [&]

https://www.percona.com/blog/2019/08/05/mongodb-impact-free-index-builds-using-detached-replicaset-nodes/

Please join Percona CEO Peter Zaitsev as he presents “Performance Analyses and Troubleshooting Technologies for Databases” on Wednesday, August 7th, 2019 at 11:00 AM PDT (UTC-7). Register Now Have you heard about the USE Method (Utilization  Saturation  Errors), RED (Rate  Errors  Duration) or Golden Signals (Latency  Traffic  Errors  [&]

https://www.percona.com/blog/2019/08/05/webinar-performance-analyses-and-troubleshooting-technologies-for-databases/

In a Linux world, whenever your database server crashes or gets terminated, you need to find its cause. There can be several reasons for this. It can be SIGSEGV, which is a crash due to some bug in the backend server, but this is the least likely reason. The most common reason is running out [&]

https://www.percona.com/blog/2019/08/02/out-of-memory-killer-or-savior/