by Ibrar Ahmed | Oct 1, 2020 | Insight for DBAs, Open Source, PostgreSQL
There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb...
by David Quilty | Oct 1, 2020 | Insight for DBAs, MongoDB, Percona Software, Webinars
This webinar will be delivered in Italian. MongoDB is the most used document-oriented database but some of the more requested features are available only in the Enterprise version. Percona Server for MongoDB (PSMDB) is an alternative to MongoDB with its open source,...
by Francisco Bordenave | Sep 30, 2020 | Insight for DBAs, MySQL, Storage Engine
In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources. First, Some Context Scaling resources is just adding more resources to your environment, and...
by Robert Bernier | Sep 29, 2020 | Insight for DBAs, Open Source, PostgreSQL
So you’ve installed postgres onto your machine, and you want to start working with it. How? The key to understanding the post-installation procedure is to realize that it “depends”. It “depends” on the OS i.e. MSWindows vs Linux. It...
by Taras Onishchuk | Sep 25, 2020 | Insight for DBAs, MySQL, Percona Software
We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the...
by David Quilty | Sep 24, 2020 | Cloud, Insight for DBAs, Open Source, Webinars
Database-as-a-service (DBaaS) can be thought of as a platform that can be used to manage an organization’s database environment(s). One of the most well known DBaaS platforms is Aurora powered by AWS. In this webinar, Ananias Tsalouchidis, Senior MySQL DBA at...
by Mike Grayson | Sep 21, 2020 | Insight for DBAs, Insight for Developers, MongoDB, Security
As with any database platform, MongoDB security is of paramount importance to keeping your data safe. MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database. So how do...
by Vadim Tkachenko | Sep 16, 2020 | Benchmarks, Insight for DBAs, MongoDB
There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples of such bugs for MySQL I have: Bug #15815 – This is where InnoDB on an 8-CPU system performed worse than on a 4-CPU system with increased...
by Vadim Tkachenko | Sep 15, 2020 | Benchmarks, Insight for DBAs, MongoDB
Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W Workload, and the recent release of Percona Server for MongoDB 4.4, I wanted to evaluate 4.2 vs 4.4 in similar...
by Jake Davis | Sep 15, 2020 | Insight for DBAs, MySQL
If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. Shell...
by Peter Zaitsev | Sep 11, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer...
by Ibrar Ahmed | Sep 10, 2020 | Insight for DBAs, PostgreSQL
Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash, GIN, GIST, and BRIN indexes. And because the development...
by Jobin Augustine | Sep 9, 2020 | Cloud, Insight for DBAs, PostgreSQL
It is very common to see many customer cases where a sudden increase in disk space usage is caused by a lot of WAL segments filling up the WAL directory (pg_wal). Panicking customers generally ask “Why isn’t PostgreSQL deleting them?”. The most...
by Daniel Guzmán Burgos | Sep 8, 2020 | Cloud, Insight for DBAs, MySQL
MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of...
by Lalit Choudhary | Aug 31, 2020 | Insight for DBAs, Insight for Developers, Percona Software
At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form,...
by Jobin Augustine | Aug 21, 2020 | Insight for DBAs, PostgreSQL
I find myself discussing and explaining sychronous_commit with many PostgreSQL users, especially with novice users. So, I thought of noting down all the key points as a blog post which will be useful for more users. Recently I got an opportunity to talk about some...
by Diana Muina | Aug 17, 2020 | Insight for DBAs, Monitoring, Percona Software
Every software story starts with a simple idea of how to serve a specific user need. However, with the growing number of applications and ways to deploy those applications (on-premise or in the cloud or both) our environments are becoming more and more complex. But...
by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8? Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I...
by Vadim Tkachenko | Aug 13, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I wanted to dig a little deeper and understand how different MySQL parameters affect performance. One of the...
by Carlos Tutte | Aug 12, 2020 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of...
