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 133

Tuning Cache Servers Benchmarking 133

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache 264

Cache Servers Architecture Processing 264

The Netflix TechBlog

MAY 4, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. This technique facilitates validation on multiple fronts.

Traffic 339

Traffic Latency Tuning Systems 339

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Database Architecture Servers 246

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 54

Tuning Database Performance Benchmarking 54

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 99

Cache Hardware Servers Benchmarking 99

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 123

Performance Hardware Tuning Storage 123

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 89

Monitoring Tuning Metrics Servers 89

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 135

Cache Best Practices Strategy Servers 135

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 Latency 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

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

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 81

Servers Open Source Tuning Cache 81

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

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 54

Performance Benchmarking Cache Storage 54

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

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 40

Traffic Cache Network Servers 40

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

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 69

Tuning Cache Network Servers 69

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 Tuning 110

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

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

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

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

Enprowess

MARCH 4, 2018

And whenever one server isn’t sufficient to serve the high traffic needs of your portal, you can scale your Liferay portal by adding additional servers. Basically when group of servers and other resources act like a single system and enable high availability is termed as “Clustering”. Enable cluster link for cache replication.

Cache 52

Cache Transportation Media Traffic 52

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. There is a lot of awesome technology involved with Hyperscale in how it is architected to use SSD-based caches and page servers.

Azure 55

Azure Database Serverless Hardware 55

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 75

Performance Benchmarking Cache Tuning 75

KeyCDN

JANUARY 31, 2019

With Bucharest being the capital and largest city of Romania, it makes for a great edge server location. However, now with the Bucharest edge server in production, it helps further close the gap between visitors who live in Romania and the nearest KeyCDN POP they have access to. Happy content delivery!

Internet 48

Internet Internet Ecommerce Speed 48

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 Ecommerce Traffic 74

Brendan Gregg

JUNE 30, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. In some cases, a benchmark may appear to exceed network bandwidth because it returns from a local memory cache instead of the remote target. They are: **Performance mantras**.

Benchmarking 54

Benchmarking Latency Cache Network 54

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 Processing 95

KeyCDN

OCTOBER 24, 2018

With Helsinki being the capital and most populous municipality of Finland, it makes for a great edge server location. However, now with the Helsinki edge server in production, this helps further close the gap between visitors who live in Finland and the nearest KeyCDN POP they have access to. Happy content delivery!

Internet 48

Internet Internet Speed Network 48

The Netflix TechBlog

JUNE 14, 2023

Before GraphQL: Monolithic Falcor API implemented and maintained by the API Team Before moving to GraphQL, our API layer consisted of a monolithic server built with Falcor. A single API team maintained both the Java implementation of the Falcor framework and the API Server. To launch Phase 1 safely, we used AB Testing.

Traffic 353

Traffic Latency Cache Metrics 353

Brendan Gregg

JUNE 29, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. In some cases, a benchmark may appear to exceed network bandwidth because it returns from a local memory cache instead of the remote target. They are: **Performance mantras**.

Benchmarking 40

Benchmarking Latency Cache Network 40

Brendan Gregg

FEBRUARY 8, 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 40

Performance Benchmarking Cache Tuning 40

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. 84.1 | | version_comment | Percona Server (GPL), Release 84.1, MySQL on ec2.

Cache 46

Cache C++ AWS Airlines 46