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 145

Tuning Cache Servers Benchmarking 145

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.

Tuning 67

Tuning Servers Database Best Practices 67

The Netflix TechBlog

SEPTEMBER 10, 2024

By Karthik Yagna , Baskar Odayarkoil , and Alex Ellis Pushy is Netflix’s WebSocket server that maintains persistent WebSocket connections with devices running the Netflix application. After tuning our store for Pushy’s needs, it has been on autopilot since, appropriately scaling and serving our requests with very low latency.

Latency 234

Latency Cache Tuning Efficiency 234

Alex Russell

MARCH 31, 2022

Browsers will cache tools popular among vocal, leading-edge developers. There's plenty of space for caching most popular frameworks. The best available proxy data also suggests that shared caches would have a minimal positive effect on performance. Browsers now understand the classic shared HTTP cache behaviour as a privacy bug.

Cache 89

Cache Government Traffic Network 89

Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. wal_buffers.

Tuning 79

Tuning Database Performance Benchmarking 79

The Netflix TechBlog

OCTOBER 8, 2024

Flexible : This metadata can be adjusted per time slice, allowing us to tune the partition settings of future time slices based on observed data patterns in the current time slice. Here’s how we manage this: Horizontal scaling : TimeSeries server instances can auto-scale up and down as per attached scaling policies to meet the traffic demand.

Latency 239

Latency Storage Traffic Tuning 239

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Evaluating factors like hit rate, which assesses cache efficiency level, or tracking key evictions from the cache are also essential elements during the Redis monitoring process.

Metrics 130

Metrics Monitoring Latency Cache 130

Smashing Magazine

NOVEMBER 8, 2021

From connecting back-office operations to front-of-the-house A/B testing and dynamic personalization for each customer, the shared foundation is fast server-side rendering powered by fast storefront data access. On top of this foundation, we add layers of caching, prerendering and edge delivery optimizations — not the other way around.

Cache 139

Cache Best Practices Strategy Servers 139

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 144

Performance Hardware Tuning Storage 144

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 124

Cache Hardware Servers Benchmarking 124

The Netflix TechBlog

JULY 21, 2022

device characteristics come from our on-field knowledge and runtime memory data comes from real-time user data pushed to our servers. Some features (as an example) include Device Type ID, SDK Version, Buffer Sizes, Cache Capacities, UI resolution, Chipset Manufacturer and Brand. This is because since the kill happens rarely (0.9%

Big Data 188

Big Data Cache Engineering Data Engineering 188

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. You can search the blog for more information on this if needed.

Monitoring 125

Monitoring Tuning Metrics Servers 125

Scalegrid

JANUARY 10, 2025

By spreading data across several servers, they support growing applications without sacrificing speed or functionality. Microsoft SQL Server is a go-to choice in the enterprise sphere, offering high performance and integration with other Microsoft products. Horizontal scaling, or scaling out, is the essence of distributed databases.

Database 130

Database Scalability Best Practices Blockchain 130

Percona

SEPTEMBER 1, 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? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Database Efficiency Performance 52

KeyCDN

NOVEMBER 4, 2021

For more POPs planned, check our current network for a list of both active and planned edge server locations. Alternatively, If you would like to request a POP in a certain location or a new feature please let us know and stay tuned for more exciting announcements.

Latency 111

Latency Tuning Cache Traffic 111

KeyCDN

MARCH 10, 2021

With Tel Aviv being the technology capital of Israel, it's the ideal edge server location. How to check a POP location Each edge server adds the HTTP response header X-Edge-Location delivered by KeyCDN. If you'd like to request a POP in another location or a new feature please let us know and stay tuned for more exciting announcements.

Latency 110

Latency Internet Internet Speed 110

Smashing Magazine

SEPTEMBER 6, 2021

Next, we’ll look at how to set up servers and clients (that’s the hard part unless you’re using a content delivery network (CDN)). This difference by itself doesn’t do all that much (it mainly reduces the overhead on the server-side), but it leads to most of the following points. Server Sharding and Connection Coalescing.

Network 120

Network Servers Cache Traffic 120

Percona

JULY 27, 2023

is an evolution of the MySQL server and related software. This could be handy for tracking query tuning and performance auditing. Seems like a lot of work to do while servers are failing, but it should save the data in a better state. Do you have suspicious group replication servers showing up? Suspicious servers?

Servers 98

Servers Open Source Tuning Cache 98

All Things Distributed

OCTOBER 2, 2017

percent availability in the event of a server, a rack of servers, or an Availability Zone failure. DynamoDB automatically re-distributes your data to healthy servers to ensure there are always multiple replicas of your data without you needing to intervene.

Internet 111

Internet Internet AWS Performance 111

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Tim Kadlec

APRIL 12, 2020

The cache hit was very low (a topic for another day), and whenever the server had to provide a fresh version of the page, it was taking an unacceptably long time more often than not. Synthetic tests, even properly tuned to match device and network characteristics, only occasionally surfaced the issue.

Tuning 70

Tuning Cache Network Servers 70

The Netflix TechBlog

DECEMBER 17, 2019

This way, log event processing can resume event-by-event afterwards, eventually discovering the watermarks, without ever needing to cache log event entries. Stay Tuned DBLog has additional capabilities which are not covered by this blog post, such as: Ability to capture table schemas without using locks. Figure 4— Delta Connector.

Database 221

Database Traffic Transportation Open Source 221

The Netflix TechBlog

DECEMBER 17, 2019

This way, log event processing can resume event-by-event afterwards, eventually discovering the watermarks, without ever needing to cache log event entries. Stay Tuned DBLog has additional capabilities which are not covered by this blog post, such as: Ability to capture table schemas without using locks. Figure 4— Delta Connector.

Database 206

Database Traffic Transportation Open Source 206

Smashing Magazine

AUGUST 9, 2021

It was heralded as an amazing performance revolution, with exciting new features such as server push, parallel streams, and prioritization. We would have been able to stop bundling resources, stop sharding our resources across multiple servers, and heavily streamline the page-loading process. In older versions of TLS (say, version 1.2

Transportation 145

Transportation Internet Internet Network 145

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

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Cache Access Pattern Depending on the memory access pattern and working set size, an additional 1% to 10% overhead can occur at a certain syscall rate. and 4.14.12

Performance 72

Performance Benchmarking Cache Tuning 72

KeyCDN

JANUARY 25, 2023

This makes Dublin the ideal location for an edge server. How to check a POP location Each edge server adds the HTTP response header X-Edge-Location delivered by KeyCDN. If you want to see a POP in another location or a new feature, please let us know and stay tuned for more exciting announcements.

Latency 60

Latency Tuning Cache Speed 60

HammerDB

APRIL 19, 2023

For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement. Please refer to this tuning guide to tune the system for HammerDB: Open Source Database Tuning Guide on 3rd Generation Intel® Xeon® Scalable Processors Based Platform.

Performance 55

Performance Benchmarking Cache Storage 55

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. Servers down or server health issues [APM]. STEP 7: Tune Your CDN Performance. A key to surviving a peak event is to have very good #CDN cache designs.

Website 74

Website Cache Traffic Ecommerce 74

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented. TheYear , CA.

Servers 95

Servers Tuning Architecture Performance 95

MachMetrics

JULY 31, 2020

Simply put, compression allows the web server to send smaller files to your web site viewers. When someone enters your URL and requests your site, their browser will indicate to the web server that it understands compression (and which type it understands). What is HTTP Compression? Gzip Compression. How Do I Enable Gzip?

Speed 67

Speed Servers Google Tuning 67

The Morning Paper

MARCH 10, 2020

All cache read misses and all writes go through UDB servers, with SQL queries being converted into RocksDB queries. For one representative UDB server, about 10.2 Per server, per day, an average of just over 700M queries for UDB, 420 million for ZippyDB, and 111 million for UP2X. Gets and Puts dominate the workload.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

IO River

NOVEMBER 2, 2023

While it can occasionally be a specific server or even an application within a data center, it's predominantly the data center itself. If the content is readily available, the CDN delivers it straight away, negating the need to retrieve it from the origin server. Do you just give up the traffic trying to access it while you work on it?

Traffic 52

Traffic Cache Servers Network 52

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. systemctl stop tuned $ systemctl disable tuned Dirty ratio The dirty_ratio is the percentage of total system memory that can hold dirty pages.

Best Practices 52

Best Practices Design Tuning Database 52

KeyCDN

JUNE 16, 2021

If you'd like to know more about where we plan on adding a POP next, check our current network for a list of both active and planned edge server locations. Alternatively, If you would like to request a POP in a certain location or a new feature please let us know and stay tuned for more exciting announcements.

Tuning 52

Tuning Cache Network Speed 52

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. You won't be able to check the plan cache for these results, because of the recompile.

Cache 59

Cache Tuning Database Performance 59