ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss where this overhead comes from and measure such overhead.  Types of [&]

https://www.percona.com/blog/2020/08/28/proxysql-overhead-explained-and-measured/

There is a less-talked-about improvement in PostgreSQL 12 which can greatly reduce the benign log entries. postgresql.org. Background In PostgreSQL, for each client connection request to Postmaster (listens on port 5432 by default), a backend process will be created. It then processes the startup packet from the client. Refer to [crayon-5de7290104d00116988722-i/] for the source code. [&]

https://www.percona.com/blog/2019/12/03/postgresql-12-improvement-benign-log-entries-incomplete-startup-packet/

The AT&T Hotel and Conference Center. The CFP is open for submissions from November 27, 2019, through January 13, 2020. We invite abstracts covering any and all aspects of open source databases, including on-premise, in the cloud, and across the multi-verse! Hot Open Source Topics for 2020 All Open Source database themes are welcome, but [&]

https://www.percona.com/blog/2019/12/03/percona-live-2020-call-for-papers/

MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and Optimizer statistics, not limited to the Histograms only, help increase the speed of the [&]

https://www.percona.com/blog/2019/12/03/webinar-introduction-to-mysql-query-tuning-for-devops/

Its release roundup time here at Percona! Todays release post encompasses Percona releases from November 19, 2019  December 2, 2019. Every few weeks, each roundup showcases the latest in software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full [&]

https://www.percona.com/blog/2019/12/02/percona-xtrabackup-8-0-8-percona-server-for-mongodb-3-6-15-3-5-release-roundup-12-2-2019/

Want to try out Percona Monitoring and Management 2 (PMM 2) but youre not ready to turn off your PMM 1 environment?  This blog is for you! Keep in mind that the methods described are not intended to be a long-term migration strategy, but rather, simply a way to deploy a few clients in order [&]

https://www.percona.com/blog/2019/11/27/running-pmm1-and-pmm2-clients-on-the-same-host/

Making backups over the network can be done in two ways: either save on disk and transfer or just transfer without saving. Both ways have their strong and weak points. The second way, particularly, is highly dependent on the upload speed, which would either reduce or increase the backup time. Other factors that influence it [&]

https://www.percona.com/blog/2019/11/26/comparing-s3-streaming-tools-with-percona-xtrabackup/

If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples: Storing UUID and Generated Columns Storing UUID Values in MySQL Illustrating Primary Key models in InnoDB and their impact on disk usage GUID/UUID Performance Breakthrough To UUID or not to UUID? [&]

https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/

As Grafana powers our star product  Percona Monitoring and Management (PMM)  we have developed a lot of experience creating Grafana Dashboards over the last few years.   In this article, I will share some of the considerations for designing Grafana Dashboards. As usual, when it comes to questions of design they are quite subjective, [&]

https://www.percona.com/blog/2019/11/22/designing-grafana-dashboards/

In this blog post, we will see how to use perf (a.k.a.: perf_events) together with Flame Graphs. They are used to generate a graphical representation of what functions are being called within our software of choice. Percona Server for MySQL is used here, but it can be extended to any software you can take a [&]

https://www.percona.com/blog/2019/11/20/profiling-software-using-perf-and-flame-graphs/

A global index, by very definition, is a single index on the parent table that maps to many underlying table partitions. The parent table itself does not have a single, unified underlying store so it must, therefore, retrieve the data satisfying index constraints from physically distributed tables. In very crude terms, the global index accumulates [&]

https://www.percona.com/blog/2019/11/20/proposal-for-global-indexes-in-postgresql/

I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions. In this blog series, I will look into how you can install MySQL, MariaDB, or Percona Server for MySQL with Docker.  This post, part [&]

https://www.percona.com/blog/2019/11/19/installing-mysql-with-docker/

Its release roundup time here at Percona! As mentioned a few weeks ago, we are now publishing release roundups comprising all the details and information you need on the previous week (or two)s releases from Percona. This post will encompass releases from November 4, 2019  November 18, 2019. Each roundup will showcase the latest [&]

https://www.percona.com/blog/2019/11/18/pmm-2-1-mongodb-hot-backups-percona-server-updates-release-roundup-11-18-2019/

TLDR: It is not profile level 1 that is the problem; its a gotcha with the optional slowms argument that causes users to accidentally set verbose logging and fill their disk with log files. In MongoDB, there are two ways to see, with individual detail, which operations were executed and how long they took. Profiling. [&]

https://www.percona.com/blog/2019/11/15/dont-use-mongodb-profiling-level-1/

Its that time again  a new blog poll! This time around, were interested in hearing who chooses your database technology. Is it DBAs? Management?  Heres the question: Who Chooses the Database Technology for a New Application in Your Organization? Last year, we asked you a few questions in a blog poll and we received [&]

https://www.percona.com/blog/2019/11/14/who-chooses-your-database-technology/

Data drives every aspect of your business so your databases need to deliver optimum performance and availability to keep you competitive. A business requires 24x7x365 database coverage. Keeping your databases stable, performant, and optimized is crucial to your business success. We understand that finding and retaining qualified DBAs to manage mission-critical database environments can be [&]

https://www.percona.com/blog/2019/11/13/percona-actively-manage-your-databases-achieve-peak-performance/

Recently, at Percona Live Europe 2019, Dimitri Kravchuk from Oracle mentioned that he observed some unclear drop in performance for MySQL on an ext4 filesystem with the latest Linux kernels. I decided to check this case out on my side and found out that indeed, starting from linux kernel 4.9, there are some cases with [&]

https://www.percona.com/blog/2019/11/12/watch-out-for-disk-i-o-performance-issues-when-running-ext4/

It’s November, so we all know what that means; it’s peak shopping season, and no date is bigger than Black Friday. But how will your database handle all that new, relentless traffic? Not only does your database have to handle traffic without slowing down, but web servers can sometimes see such sudden traffic as an [&]

https://www.percona.com/blog/2019/11/11/prepare-your-databases-for-high-traffic-on-black-friday/

We discussed one of the traditional ways to configure HAProxy with PostgreSQL in our previous blog about HAProxy using Xinetd. There we briefly mentioned the limitation of the HAProxys built-in improvements to HAProxy like this commit which improves the disconnection of pgsql-check. So messages like [crayon-5dc9d43083589337470863-i/] may not appear in the logs. This is tested [&]

https://www.percona.com/blog/2019/11/08/configure-haproxy-with-postgresql-using-built-in-pgsql-check/

Recently I was doing some small testing by using EC2 instances on AWS and I noticed the execution time and performance highly depend on which time of the day I am running my scripts. I was using t3.xlarge instance type as I didnt need many CPUs and memory for my tests, but from time to [&]

https://www.percona.com/blog/2019/11/04/choose-your-ec2-instance-type-wisely-on-aws/