Percona

MAY 1, 2023

Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. Indexing is another powerful technique for query optimization.

Tuning 52

Tuning Database Performance Hardware 52

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. and the overall size will determine the amount of temporary storage available. Benchmark Test.

Azure 76

Azure Benchmarking Storage Virtualization 76

Dotcom-Montior

AUGUST 5, 2020

There are tools available such as Dotcom-Monitor’s free speed test that you can utilize to gauge performance. If you are running on a CMS platform like WordPress, there are a number of minification plugins available. Browser Caching: Although it may seem commonplace, caching is sometimes overlooked.

Website 92

Website Speed Cache Traffic 92

Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I wanted most of the memory to be available for the file cache, where the compressed SST files will be cached.

Storage 55

Storage Cache C++ Virtualization 55

KeyCDN

DECEMBER 8, 2022

A WordPress website comprises many parts, including web servers and their settings, different plugins, and themes. Many factors affect the speed of your WordPress website; some of them are: Your web host Server-side optimizations (PHP version, compression, caching, etc.) Traditionally, most WordPress hosts manage the caching.

Cache 52

Cache Website Speed Website Performance 52

Scalegrid

MARCH 28, 2024

Key Takeaways Redis offers complex data structures and additional features for versatile data handling, while Memcached excels in simplicity with a fast, multi-threaded architecture for basic caching needs. Redis is better suited for complex data models, and Memcached is better suited for high-throughput, string-based caching scenarios.

Cache 130

Cache Storage Scalability Architecture 130

Percona

AUGUST 31, 2018

Bear in mind that while optimizing PostgreSQL server configuration improves performance, a database developer must also be diligent when writing queries for the application. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. It is just a guideline, not the exact allocated memory or cache size.

Tuning 55

Tuning Database Performance Benchmarking 55

The Morning Paper

MAY 14, 2019

Last time around we looked at the DeathStarBench suite of microservices-based benchmark applications and learned that microservices systems can be especially latency sensitive, and that hotspots can propagate through a microservices architecture in interesting ways. When available, it can use hardware level performance counters.

Big Data 45

Big Data Cloud Performance Hardware 45

Scalegrid

JULY 29, 2020

This is shared between all clients, so a pooled connection is available to all clients. High availability. PostgreSQL high availability is supported through Pgpool-II in-built watcher processes. Not supported – PgBouncer recommends use of HAProxy for high availability and load balancing. When are connections reused?

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it.

Availability 107

Availability Database Open Source Hardware 107

Percona

APRIL 6, 2023

Load balancing One of the primary benefits of using pgpool-II is its ability to distribute incoming client connections across multiple PostgreSQL servers, allowing you to balance the load and increase the capacity of your database cluster. This can significantly improve query response times and reduce the load on your database servers.

Cache 113

Cache Open Source Benchmarking Database 113

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway.

Java 145

Java Cache Google Hardware 145

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 135

Tuning Cache Servers Benchmarking 135

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 124

Performance Hardware Tuning Storage 124

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

CSS - Tricks

APRIL 1, 2021

Google’s industry benchmarks from 2018 also provide a striking breakdown of how each second of loading affects bounce rates. The code for the site is available on GitHub for reference. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). Text-based assets.

Cache 92

Cache Social Media Media Network 92

Percona

SEPTEMBER 1, 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. Testing and Benchmarking : Thoroughly test triggers in a staging environment to evaluate their impact on performance.

Cache 60

Cache Database Games Healthcare 60

ACM Sigarch

OCTOBER 12, 2020

Par t of the appeal of Python is that there is a vast array of libraries available for it; when these are written in C, they can go a long way to alleviating Python’s performance problems. I suggest it’s long past time to move beyond C and SPEC benchmarks and our exclusive focus on “metal” languages.

C++ 108

C++ Benchmarking Hardware Architecture 108

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers.

Cache 40

Cache Servers Network Design 40

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., It’s a pretty impressive effort to pull together and make available in open source (not yet available as I write this) such a suite, and I’m sure explains much of the long list of 24 authors on this paper.

Open Source 61

Open Source Hardware Benchmarking Systems 61

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Brendan Gregg

FEBRUARY 9, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. This can turn a 1% overhead (syscall cycles alone) into a 7% overhead.

Performance 75

Performance Benchmarking Cache Tuning 75

CSS - Tricks

JUNE 5, 2020

It took a few months for major CDN players to support Brotli, but meanwhile it was seeing widespread adoption in tools, services, browsers and servers. The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. This was really disappointing for me.

Cache 79

Cache Website Servers Open Source 79

Percona

MARCH 20, 2023

When deciding what to pick, there are many things to consider, like where the proxy needs to be, if it “just” needs to redirect the connections, or if more features need to be in, like caching and filtering, or if it needs to be integrated with some MySQL embedded automation. Given that, there never was a single straight answer.

Games 120

Games Latency Traffic Cache 120

Brendan Gregg

FEBRUARY 8, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. This can turn a 1% overhead (syscall cycles alone) into a 7% overhead.

Performance 40

Performance Benchmarking Cache Tuning 40

SQL Performance

APRIL 8, 2019

These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. The L3 cache size is 64MB. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Modern network performance and availability. Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate.

Performance 124

Performance Network Cache Metrics 124

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. Global Ground-Truth.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JUNE 1, 2022

These services use requests to external hosts (not servers you control) to deliver JavaScript framework libraries, custom fonts, advertising content, marketing analytics trackers, and more. The most popular, by far, is the Google Lighthouse report (available in Chrome Developer Tools) and Google’s Page Speed Insights.

Website 131

Website Design Network Best Practices 131

Smashing Magazine

JUNE 26, 2019

Let the web developer handle all of the necessary speed optimizations like caching and file minification while you take on the following design tips and strategies: 1. You can see in his example that he suggests a number of optimizations, like limiting which styles and character sets are available for use on the website. Minification.

Website 110

Website Speed Mobile Design 110

Smashing Magazine

JUNE 2, 2021

Today, the website is much faster and ranks highly in various showcases and benchmarks. And while you can usually cache the full page of an article, the same is not true of many shop pages and elements. This way, the file can be cached on the server and in the browser, and no superfluous SVGs will need to be interpreted.

Performance 116

Performance Cache Website Mobile 116

Smashing Magazine

AUGUST 9, 2022

PageSpeed Compare is a page speed evaluation and benchmarking tool. It also lists cached resources and identifies unused Javascript. It graphs server, network, CSS, Javascript, critical content, and image optimizations to show the potential savings you could gain by incorporating fixes into your site. PageSpeed Compare.

Performance 130

Performance Benchmarking Website Metrics 130

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. It used to provide an insight into how quickly the server outputs any data.

Performance 145

Performance Cache Media Metrics 145