HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. TB)) for storage of database tablespaces and logging. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. In this case, we had a table with a couple million rows. A simplified and sanitized version: CREATE TABLE dbo.

Cache 59

Cache Tuning Database Performance 59

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 99

Database Servers Open Source Tuning 99

CSS Wizardry

NOVEMBER 3, 2020

I can see from the screenshot above that TTFB is my most stable metrics—no one page appears to have particularly expensive database queries or API calls on the back-end. The whole point of the exercise that follows is to allow me to move quickly, spotting patterns from afar, and not having to do any slow or meticulous work yet.

Speed 292

Speed Ecommerce Metrics Analytics 292

O'Reilly

JANUARY 17, 2023

You’ll try this with a few other algorithms, and their respective tuning parameters–maybe even break out TensorFlow to build a custom neural net along the way–and the winning model will be the one that heads to production. You might say that the outcome of this exercise is a performant predictive model. That’s sort of true.

Tuning 133

Tuning Open Source AWS Software 133

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

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. Tune the random_page_cost parameter. Tune the effective_cache_size parameter. Next is the table definition.

Best Practices 87

Best Practices Tuning Database Testing 87