HammerDB

JUNE 22, 2023

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/DATA/hammer.db Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/TMP/hammer.DB So for example to change this to hammer.db DATA/hammer.db

Benchmarking 57

Benchmarking C++ Virtualization Database 57

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 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.

Tuning 52

Tuning Efficiency Database Performance 52

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. But I'd rather the cost be zero, of course!

Java 145

Java Cache Google Hardware 145

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning?

Tuning 52

Tuning Database Performance Hardware 52

Speed Curve

OCTOBER 25, 2023

The best way to fight regressions is to create performance budgets on key metrics, and get alerted when they go out of bounds. You can even go one step further and integrate your performance budgets with your CI/CD process, so that you not only get alerts but even break the build if a new deploy would violate any of your budgets.

Benchmarking 62

Benchmarking Metrics Website Monitoring 62

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 on CentOS 7, both of them spec’d with four vCPUs but with the second one (server B) having a tad over twice as much memory than the reference one (server A).

Tuning 134

Tuning Cache Servers Benchmarking 134

Speed Curve

JULY 3, 2023

HTML – Typically the smallest resource on the page, HTML's performance risk is usually negligible. JavaScript – A page can have a relatively low JS weight but still suffer from JS-inflicted performance problems. This is to try to understand how a "typical" page might perform, as well as pages in the "longtail".

Mobile 52

Mobile Google Metrics Retail 52

Percona

APRIL 12, 2023

Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.) We are really pleased with our Q1 performance and see it as continued validation of the massive market we are pursuing, our strong product market fit, and our ability to execute.”

Open Source 80

Open Source Programming Database Servers 80

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc. It automatically takes regular backups, capturing incremental changes since the last backup without affecting performance.

AWS 52

AWS Database Serverless Storage 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Horizontal and vertical MySQL partitions are techniques used to divide tables into smaller sections for improved performance and management. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. What is a Trigger in MySQL?

Cache 59

Cache Database Games Healthcare 59

O'Reilly

JULY 25, 2023

Here’s how I worked on it: I subscribed to ChatGPT Plus and used the GPT-4 model in ChatGPT (first the May 12, 2023 version, then the May 24 version) to help me with design and implementation. Right now, widely-used benchmarks for AI code generation (e.g., Right now, widely-used benchmarks for AI code generation (e.g.,

Programming 98

Programming Code Design Benchmarking 98