Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It has default settings for all of the database parameters. What is PostgreSQL performance tuning? What is PostgreSQL performance tuning?

Tuning 52

Tuning Database Efficiency Performance 52

The Netflix TechBlog

JANUARY 10, 2024

Cosmos As a response, in 2018 the CIS and ET teams started developing the next-generation platform, Cosmos. The results are saved to a database so they can be reused. The service also provides options that allow fine-tuning latency, throughput, etc., 264, AV1, etc.). depending on the use case.

Processing 238

Processing Media Latency Innovation 238

Brendan Gregg

APRIL 30, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 41

DevOps Network Best Practices Programming 41

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog.

Architecture 59

Architecture Database Open Source Internet 59

Brendan Gregg

APRIL 29, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 40

DevOps Network Best Practices Programming 40

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. Is MongoDB an open source NoSQL database?

Open Source 98

Open Source Programming Database Servers 98

Percona

SEPTEMBER 13, 2018

2018-09-03.09 > mysql-slowquery.log.2018-09-03.09 2018-09-03.09 2018-09-03.09 system time, 43.80M rss, 141.48M vsz # Current date: Tue Sep 4 15:54:21 2018 # Hostname: aahmed-GL503VD # Files: mysql-slowquery.log.2018-09-03.09 2018-09-03.09 Run pt-query-digest on the log file. . $ user time, 2.5s user time, 2.5s

C++ 62

C++ AWS Open Source Testing 62

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more. We’ll say more about this later.)

Open Source 135

Open Source Google Artificial Intelligence Infrastructure 135

Percona

AUGUST 27, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Forking or Branching – Lessons from the MySQL Community on Tuesday, August 28th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog.

Open Source 64

Open Source Internet Internet Strategy 64

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. In the recent MySQL 8.0.16 So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. linux-glibc2.12-x86_64/data

Testing 49

Testing Tuning Storage Latency 49

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Many thanks to the engineers working hard to develop workarounds to these processor bugs.

Performance 72

Performance Benchmarking Cache Tuning 72

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. The size of the database and your database environment—if it is on colo or cloud—matters. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster.

Strategy 52

Strategy Database Storage Open Source 52

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Oracle Log File Sync.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

SQL Server According to Bob

FEBRUARY 15, 2018

Well, for SQLBits 2018, it is not just me. Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Which database, when ?

Engineering 40

Engineering Azure Best Practices Servers 40

Apica

MAY 10, 2019

million Netflix users as of Q3 2018. These companies should involve multiple organizations during Apica’s load testing to observe and pinpoint opportunities for performance tuning. 2019 will go down as the year when giants collided over who is streaming the right content to win the growing market demand and dollars.

Testing 40

Testing Performance Social Media Wireless 40

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Many thanks to the engineers working hard to develop workarounds to these processor bugs.

Performance 40

Performance Benchmarking Cache Tuning 40

Percona

JANUARY 17, 2019

I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). MySQL on ec2. mysql> show global variables like '%version%'; + -+ + | Variable_name | Value | + -+ + | innodb_version | 5.6.41-84.1 sec) The table is very wide, 84 columns.

Cache 72

Cache C++ AWS Airlines 72

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. 2018-05-31

Database 48

Database Analytics Blockchain Healthcare 48