Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. The concept of HugePages in Linux has existed for many years, first introduced in 2007.

Database 85

Database Servers Open Source C++ 85

Percona

DECEMBER 19, 2023

The simplest way to run it for testing is to use the docker container: docker run --name pg-tde -e POSTGRES_PASSWORD=mysecretpassword -d perconalab/postgres-tde-ext This command starts a container with the extension loaded and already enabled for the Postgres database. tde 00000000 6d 61 73 74 65 72 2d 6b 65 79 00 00 00 00 00 00 |master-key.|

Open Source 80

Open Source Storage Database C++ 80

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent.

Database 40

Database Analytics Blockchain Healthcare 40

High Scalability

NOVEMBER 25, 2019

Egnyte is a secure Content Collaboration and Data Governance platform, founded in 2007 when Google drive wasn't born and AWS S3 was cost-prohibitive. In 2007, businesses had started to become more distributed; customers were using multiple devices to access their files and there was a need to make this experience as smooth as possible.

Architecture 52

Architecture Cache Azure Storage 52

Brendan Gregg

JANUARY 17, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. wss.pl -C `pgrep -n mysqld` 1. I just wrote [wss.pl] as a front-end to this feature. seconds (100 milliseconds): #./wss.pl

Cache 71

Cache Latency C++ Programming 71

Brendan Gregg

JANUARY 16, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. wss.pl -C `pgrep -n mysqld` 1. I just wrote [wss.pl] as a front-end to this feature. seconds (100 milliseconds): #./wss.pl

Cache 40

Cache Latency C++ Programming 40

Highly Scalable

MARCH 10, 2015

Recall the basic equation for enterprise profit: where Q is quantity sold, P is price, V denotes variable costs, and C denotes fixed costs. Heckerman, and C. DG12] How Companies Learn Your Secrets, C. Kleinberg, C. Fisher, 2007. MA08] Introduction to Information Retrieval, C. Billsus, 2007.

Retail 152

Retail C++ Analytics Metrics 152