Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Benchmark before you decide.

Performance 123

Performance Hardware Tuning Storage 123

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. I'd expect between 0.1%

Virtualization 111

Virtualization AWS Hardware Storage 111

All Things Distributed

DECEMBER 12, 2013

We launched DynamoDB last year to address the need for a cloud database that provides seamless scalability, irrespective of whether you are doing ten transactions or ten million transactions, while providing rock solid durability and availability. Since then, we have been working on adding flexible querying. DynamoDB Refresher.

Games 130

Games Scalability Database Retail 130

Percona

AUGUST 15, 2023

These companies include Couchbase, Cockroach Labs, Sentry, and MariaDB, which developed this license in 2013. In the early days, many commercial open source companies liked to play the “open source game” because it helps adoption, speeds up community formation, attracts contributions, etc.

Open Source 75

Open Source Government Software Software 75

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. This is the first time any server vendor has even bothered to submit a TPC-E result for an AMD-based system since 2013. Higher memory speed and bandwidth. Among the 19 public processor SKUs, there are preferred choices for SQL Server at each available core count. Lower power usage.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Brendan Gregg

NOVEMBER 28, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. I'd expect between 0.1%

Virtualization 40

Virtualization AWS Hardware Storage 40