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 In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. In PostgreSQL, it is called shared buffers.

Tuning 137

Tuning Cache Servers Benchmarking 137

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 127

Performance Hardware Tuning Storage 127

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. Testing and Benchmarking : Thoroughly test triggers in a staging environment to evaluate their impact on performance. Benchmark different trigger implementations to identify the most efficient option.

Cache 62

Cache Database Games Healthcare 62

Percona

JUNE 22, 2023

” Here are additional metrics used to determine the reliability of a database, make adjustments that minimize downtime, and set benchmarks for meeting business continuity requirements. The transparency of open code enhances security as potential vulnerabilities can be identified and patched more quickly by the community.

Availability 111

Availability Database Open Source Hardware 111

Alex Russell

APRIL 29, 2021

Apple Corporate is at fault, not Open Source engineers or the line managers who support them. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. So is speedy resolution and agreement.

Media 145

Media Games Education Engineering 145

CSS - Tricks

JUNE 5, 2020

In 2015, Google published a blog post announcing Brotli and released its source code on GitHub. The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. We only cache hot files in memory at edge servers. Brotli’s beginning…. This is all so good.

Cache 79

Cache Website Servers Open Source 79

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. Today, the website is much faster and ranks highly in various showcases and benchmarks. Working with jewellerybox on its online store was a welcome change of pace for us. Large preview ).

Performance 115

Performance Cache Website Mobile 115

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. There are many tools allowing you to achieve that: SiteSpeed.io Large preview ).

Performance 145

Performance Cache Media Metrics 145