HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02 order by c. 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 40

The Netflix TechBlog

DECEMBER 11, 2020

We had our first Studio applications consuming the federated graph, without any performance degradation, by the end of the 2019. For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. The schema registry is developed in-house, also in Kotlin.

Architecture 249

Architecture Best Practices Engineering Open Source 249

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

Percona

SEPTEMBER 1, 2023

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. This affects the type and range of characters that can be inserted into the column.

Performance 52

Performance Storage Social Media Database 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 126

Speed Java AWS Virtualization 126

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 81

Availability Open Source Architecture Database 81

Smashing Magazine

MAY 5, 2021

However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. In 2019, we sold 500k tickets a year, so our operations are complex and we need to showcase it with our landing pages in an appealing and fast manner. server only; Graphql Server layer added.

Google 111

Google Architecture Servers Speed 111

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official recommendation (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 40

Speed Java AWS Virtualization 40

O'Reilly

JULY 25, 2023

For instance, if I’m reading a paper from 2019, a popular song from that year could start playing. Similarly, it taught me that “Background scripts are ideal for handling long-term or ongoing tasks, managing state, maintaining databases, and communicating with remote servers.

Programming 98

Programming Code Design Benchmarking 98

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. rc3-custom #1 SMP Mon Aug 12 14:07:33 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux Welcome to Ubuntu 19.04 (GNU/Linux 5.3.0-rc3-custom uname -a Linux ubuntu19 5.3.0-rc3-custom rc3-custom x86_64).

Benchmarking 63

Benchmarking Performance Hardware C++ 63

SQL Performance

NOVEMBER 13, 2019

As I explain in T-SQL bugs, pitfalls, and best practices – determinism , most functions in T-SQL are evaluated only once per reference in the query—not once per row. T1 ; Prior to SQL Server 2019 (or parallel compatibility level < 150), user defined functions get evaluated per row. YouWillRegretThis ( ) ) AS n.

Servers 104

Servers C++ Storage Performance 104

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). Vitaly Friedman.

Performance 104

Performance Cache Metrics Network 104

Smashing Magazine

JANUARY 6, 2020

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). You can use Heroku’s primer on HTTP caching headers , Jake Archibald’s " Caching Best Practices " and Ilya Grigorik’s HTTP caching primer as guides.

Performance 145

Performance Cache Network Metrics 145