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

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 130

Performance Hardware Tuning Storage 130

Brendan Gregg

NOVEMBER 29, 2017

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. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. The first was c3.

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. You saw the first iteration in April 2013 with the launch of Local Secondary Indexes (LSI).

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 82

Open Source Government Software Software 82

Brendan Gregg

NOVEMBER 28, 2017

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. This was initially used via the ixgbe driver for speeds up to 10 Gbps, then the ena driver for speeds up to 25 Gbps. The first was c3.

Virtualization 40

Virtualization AWS Hardware Storage 40

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. A one-socket AMD EPYC 7002 Series server can have up to 64 physical cores, 4TB of DDR4-3200 RAM, and 128 PCIe 4.0 Lower power usage.

Servers 52

Servers Benchmarking Virtualization Architecture 52