はてなブックマーク

One of our customers recently asked whether it is possible to identify, from the MySQL side, the query that is causing high CPU usage on his system. The usage of simple OS tools to find the culprit has been a widely used technique for a long time by PostgreSQL and Oracle DBAs, but it didn’t work for MySQL as historically we’ve lacked the instrumentation to match an OS thread with an internal proce

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

As hardware and software evolve, the bottlenecks in a database system also shift. Many old problems might disappear and new types of problems pop-up. Old LimitationsThere were days when CPU and Memory was a limitation. More than a decade back, servers with 4 cores were “High End” and as a DBA, my biggest worry was managing the available resources. And for an old DBA like me, Oracle’s attempt to po

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

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, and I do not expect you to chose to apply all of them to your d

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 one, is focused on MySQL Server. Docker is actually not my most preferred way

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

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. Percona Distribution for Post

PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQL’s process-based architecture was implemented prior to POSIX threads. PostgreSQL launches a process “postmaster” on startup, and after that spans new process whenever a new client connect

See part one of this series here. This post is part two of my series “Assessing MySQL Performance Amongst AWS Options”, taking a look at how current Amazon RDS services – Amazon Aurora and Amazon RDS for MySQL – compare with Percona Server with InnoDB and RocksDB engines on EC2 instances. This time around, I am reviewing the total cost of one test run for each database as well as seeing which data

The dataset could fit in memory as there were no disk reads. I have tested four cases: PK selects – without transaction (select only) PK selects – inside a transaction (begin,select,commit) PK selects – autocommit=off (select,commit) PK selects – Read-Only transaction (START TRANSACTION READ ONLY, select, commit)DisclaimerI was not trying to do a proper performance test to see the maximum performa

Docker Security Considerations – PART I Why Docker Security MattersIt is a fact that Docker has found widespread use during the past years, mostly because it is very easy to use as well as fast and easy to deploy when compared with a full-blown virtual machine. More and more servers are being operated as Docker hosts on which micro-services run in containers. From a security point of view, two asp

At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is YES. The true meaning of hypothetical is imaginary but not real. We can try creating indexes that are imaginary for the PostgreSQL optimizer which don’t exist in reality. Let’s look at

It’s not essential to understand how MySQL® and Percona Server for MySQL build indexes. However, if you have an understanding of the processing, it could help when you want to reserve an appropriate amount of space for data inserts. From MySQL 5.7, developers changed the way they built secondary indexes for InnoDB, applying a bottom-up rather than the top-down approach used in earlier releases. In

There are three different ways ProxySQL can direct traffic between your application and the backend MySQL services. Locally, on the MySQL servers. Between the MySQL servers and the application. Colocated on the application servers themselves.Without going through too much detail – each has its own limitations. In the first form, the application needs to know about all MySQL servers at any given po

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of web applications. In today’s blog, I’l

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

Percona has released Percona Server for MySQL 8.0 as Generally Available (GA). Our Percona Server for MySQL 8.0 software is the company’s free, enhanced, drop-in replacement for MySQL Community Edition. Percona Server for MySQL 8.0 includes all of the great features in MySQL Community Edition 8.0. It also includes enterprise-class features from Percona made available free and open source. Percona

In the previous blog posts in this series, we’ve covered some of the essential aspects of an Enterprise-grade solution: security, high availability, and backups. Another important aspect is the scalability of the solution: as our application grows how do we accommodate an increase in traffic while maintaining the quality of the service (response time)? The answer to this question depends on the na

This blog was originally written in September 2018 and was updated in June 2023. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster. In setting up our demonstration system, we use pg_basebackup and continuous archiving. The size of the database and your database environment—if it is on colo or cloud—matters. It is very important to und

High availability (HA) and database replication is a major topic of discussion for database technologists. There are a number of informed choices to be made to optimize PostgreSQL replication so that you achieve HA. In this post we introduce an overview of the topic, and cover some options available to achieve high availability in PostgreSQL. We’ll then focus in on just one way to implement HA for

All of Percona’s open-source software products, in one place, to download as much or as little as you need.

All of Percona’s open-source software products, in one place, to download as much or as little as you need.