Percona

MAY 1, 2023

In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

ACM Sigarch

OCTOBER 12, 2020

The focus of most published research in architecture is on applications implemented in high-performance, “ close-to-the-metal” languages essentially developed before computers got fast. These, let’s call them metal languages , include FORTRAN (introduced in 1957), C (1972), and C++ (1985). As Leiserson et al.

C++ 108

C++ Benchmarking Hardware Architecture 108

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. Derived Workloads.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

The Morning Paper

MAY 27, 2019

CheriABI: enforcing valid pointer provenance and minimizing pointer privilege in the POSIX C run-time environment Davis et al., Last week we saw the benefits of rethinking memory and pointer models at the hardware level when it came to object storage and compression ( Zippads ). That ‘reasonable’ performance cost is a 6.8%

C++ 61

C++ Hardware Virtualization Benchmarking 61

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. This enables the user to compare and contrast performance across different benchmark scenarios. usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql.

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

The Morning Paper

MAY 23, 2019

Today’s paper introduces Zippads , which compared to a state of the art compressed memory hierarchy is able to achieve a 1.63x higher compression ratio and improve performance by 17%. Consider a B-Tree node from the B-tree Java benchmark: Uncompressed, it’s memory layout looks like (a) below. ” The big idea. Implications.

Cache 61

Cache Benchmarking Hardware Java 61

Scalegrid

JULY 13, 2020

There are a wide range of tools and extensions for every conceivable scenario, like performance profiling, auditing, etc. Objective C. Oracle support for hardware and software packages is typically available at 22% of their licensing fees. Oracle Ease of Use. SolarisUnix. Supported Languages. JavaScript. Visual Basic.Net.

Open Source 244

Open Source Tuning C++ Database 244

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A quick check of basic performance statistics showed over 30% higher CPU consumption. How would you _time_ time?

Speed 126

Speed Java AWS Virtualization 126

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Smashing Magazine

JANUARY 11, 2021

Front-End Performance Checklist 2021. Front-End Performance Checklist 2021. This guide has been kindly supported by our friends at LogRocket , a service that combines frontend performance monitoring , session replay, and product analytics to help you build better customer experiences. Web performance is a tricky beast, isn’t it?

Performance 145

Performance Cache Media Metrics 145

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. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. order by c.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench.

Benchmarking 48

Benchmarking Database Operating System Architecture 48

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A quick check of basic performance statistics showed over 30% higher CPU consumption. How would you time time?

Speed 52

Speed Java AWS Virtualization 52

Smashing Magazine

JANUARY 6, 2020

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 145

Performance Cache Network Metrics 145

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A quick check of basic performance statistics showed over 30% higher CPU consumption. How would you _time_ time?

Speed 40

Speed Java AWS Virtualization 40

John McCalpin

JANUARY 22, 2018

For 64-bit floating-point data, the 512-bit Fused Multiply-Add (FMA) instructions performs 16 floating-point operations (8 adds and 8 multiplies). Published DGEMM benchmark results for the Xeon Phi 7250 processor ( [link] ) show maximum values of about 2100 GFLOPS when using all 68 cores (a very approximate estimate from a bar chart).

Latency 40

Latency Hardware Code Testing 40

SQL Server According to Bob

JANUARY 11, 2020

Character POS ASCII Value Formula Value A 1 65 67 C 2 67 69 Checksum 136 Comparing ​​ the checksum values indicates ​​ that the values do not match and ​​ damage ​​ has occurred to the data.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

For e.g., if accessing file system over WebDAV or FTP has performance issues, and it will take 4 hours to fix, then for those 4 hours, you can just kill FTP/WebDAV at kong/firewall and ask customers to use web UI or other mechanisms to work. Who performs what roles? Java/Python mostly and some small services in Go/C.

Architecture 52

Architecture Cache Azure Storage 52