PostgreSQL locking visibility for application developers and DBAs is in most cases related to heavyweight locks. Complex database locking operations require full instrumentation using views from the system catalog. It should be clear which object is locked by a specific database backend process. An alternative name for any lock is bottleneck. In order to make [&]

https://www.percona.com/blog/2018/10/24/postgresql-locking-part-2-heavyweight-locks/

Recently we had a customer that had issues with a filled disk on the server hosting their Docker pmm-server environment. They were not able to access the web UI, or even stop the pmm-server container because they had filled the /var/ mount point. Setting correct expectations The best way to avoid these kinds of issues [&]

https://www.percona.com/blog/2018/10/23/reclaiming-space-on-your-docker-pmm-server-deployment/

Please join Percona’s Sr. Technical Operations Architect Tim Vaillancourt as he presents Why Do Developers Prefer MongoDB? on Thursday, October 25th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now As the fastest growing database technology today, MongoDB® helps organizations and businesses across industries create scalable applications that would have been [&]

https://www.percona.com/blog/2018/10/22/percona-webinar-developers-prefer-mongodb/

The short version I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof: [crayon-5bd396a576ec3147620296/] Yes, it took 6 hours and 57 minutes to count them all! Why does anyone need one billion tables? In my previous blog post, I created and tested MySQL 8.0 with 40 [&]

https://www.percona.com/blog/2018/10/22/one-billion-tables-in-mysql-8-0-with-zfs/

For those who are looking forward to Percona Live Europe in just two weeks time—and for those yet to make up their minds—some of our presenters have shared some insight into their talks and what theyre most looking forward to themselves. Make no mistake, this is one of the most exciting events in the conference [&]

https://www.percona.com/blog/2018/10/22/percona-live-europe-their-own-words/

Hello everyone, and thank you to those that attended our webinar on Building an Enterprise-grade PostgreSQL setup using open source tools last Wednesday. Youll find the recordings of such as well as the slides we have used during our presentation here. We had over forty questions during the webinar but were only able to tackle [&]

https://www.percona.com/blog/2018/10/19/postgresql-building-enterprise-grade-setup-with-open-source/

ProxySQL 1.4.11, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created [&]

https://www.percona.com/blog/2018/10/18/proxysql-1-4-11-and-updated-proxysql-admin-tool-now-in-the-percona-repository/

MongoDB, Inc. announced it has elected to change its license for MongoDB Community Server from AGPLv3 to a new license type they have created called a Server Side Public License (SSPL) citing the need to have a license better suited for the age of Software-as-a-Service. First, it is important to state that MongoDB, Inc. is [&]

https://www.percona.com/blog/2018/10/18/percona-statement-on-mongodb-community-server-license-change/

You may be aware that the new major version of PostgreSQL has been released today. PostgreSQL 11 is going to be one of the most vibrant releases in recent times. It incorporates many features found in proprietary, industry-leading database systems, further qualifying PostgreSQL as a strong open source alternative. Without further ado, lets have a [&]

https://www.percona.com/blog/2018/10/18/postgresql-11-our-first-take-on-the-new-release/

Please join Percona’s Principal Consultant, Alex Rubin, as he presents MongoDB 4.0 Features  Transactions & More on Thursday, October 18th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   MongoDB 4.0 adds support for multi-document ACID transactions, combining the document model with ACID guarantees. Through snapshot isolation, transactions provide a [&]

https://www.percona.com/blog/2018/10/17/mongodb-4-0-features-transactions/

Parallel replication has been around for a few years now but is still not that commonly used. I had a customer where the master had a very large write workload. The slave could not keep up so I recommended to use parallel slave threads. But how can I measure if it really helps and is [&]

https://www.percona.com/blog/2018/10/17/can-mysql-parallel-replication-help-my-slave/

An understanding of PostgreSQL locking is important to build scalable applications and avoid downtime. Modern computers and servers have many CPU cores and it’s possible to execute multiple queries in parallel. Databases containing many consistent structures with changes made by queries or background processes running in parallel could crash a database or even corrupt data. [&]

https://www.percona.com/blog/2018/10/16/postgresql-locking-part-1-row-locks/

pt-query-digest is one of the most commonly used tool when it comes to query auditing in MySQL®. By default, pt-query-digest reports the top ten queries consuming the most amount of time inside MySQL. A query that takes more time than the set threshold for completion is considered slow but its not always true that tuning such [&]

https://www.percona.com/blog/2018/10/15/identifying-high-load-mysql-slow-query-log-pt-query-digest/

Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control what a user can and cannot do on the database server for one or more databases. So consider this to be [&]

https://www.percona.com/blog/2018/10/12/track-postgresql-row-changes-using-public-private-key-signing/

Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control what a user can and cannot do on the database server for one or more databases. So consider this to be [&]

https://www.percona.com/blog/2018/10/12/track-postgresql-row-changes-using-public-private-key-signing/

Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control what a user can and cannot do on the database server for one or more databases. So consider this to be [&]

https://www.percona.com/blog/2018/10/12/track-postgresql-row-changes-using-public-private-key-signing/

With the exception of the three configuration variables described here, ProxySQL will only parse the configuration files the first time it is started, or if the proxysql.db file is missing for some other reason. If we want to change any of this data we need to do so via ProxySQLs admin interface and then save them [&]

https://www.percona.com/blog/2018/10/11/how-to-fix-proxysql-configuration-when-it-wont-start/

After much speculation following the announcement in Santa Clara earlier this year, we are delighted to announce Percona Live 2019 will be taking place in Austin, Texas. Save the dates in your diary for May, 28-30 2019! The conference will take place just after Memorial Day at The Hyatt Regency, Austin on the shores of Lady [&]

https://www.percona.com/blog/2018/10/11/percona-live-2019-save-the-date/

After much speculation following the announcement in Santa Clara earlier this year, we are delighted to announce Percona Live 2019 will be taking place in Austin, Texas. Save the dates in your diary for May, 28-30 2019! The conference will take place just after Memorial Day at The Hyatt Regency, Austin on the shores of Lady [&]

The post Percona Live 2019  Save the Date! appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/11/percona-live-2019-save-the-date/

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. This release offers two new features for both the MySQL Community and Percona Customers: [&]

The post Percona Monitoring and Management (PMM) 1.15.0 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/10/percona-monitoring-and-management-pmm-1-15-0-is-now-available/