Percona

JANUARY 3, 2024

ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers. These include runtime parameters, server grouping, and traffic-related settings. sec) File /var/lib/proxysql/proxybkp.cnf is saved.

Traffic 111

Traffic Hardware Cache Servers 111

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. We will not concern ourselves with the raw throughput of workload.

Performance 54

Performance Benchmarking Cache Storage 54

CSS Wizardry

AUGUST 7, 2019

A lot of people surmise that TTFB is merely time spent on the server, but that is only a small fraction of the true extent of things. TTFB isn’t just time spent on the server, it is also the time spent getting from our device to the sever and back again (carrying, that’s right, the first byte of data!). Expect closer to 75ms.

Latency 269

Latency Ecommerce Servers Mobile 269

ACM Sigarch

MAY 31, 2023

Heterogeneous and Composable Memory (HCM) offers a feasible solution for terabyte- or petabyte-scale systems, addressing the performance and efficiency demands of emerging big-data applications. CXL-based disaggregated memory provides a new opportunity with two orders of magnitude better performance than RDMA (as illustrated in Figure 2).

Latency 52

Latency Hardware Cache Architecture 52

Brendan Gregg

FEBRUARY 28, 2023

At USENIX SREcon22 APAC I gave the opening keynote on the future of computer performance, rounding up the latest developments and making predictions of where I see things heading. This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person!

Performance 52

Performance Latency Cache Virtualization 52

Percona

MAY 2, 2023

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. ChatGPT: The InnoDB buffer pool is used by MySQL to cache frequently accessed data in memory. Keep in mind that setting the buffer pool size too high may result in other processes on your server competing for memory, which can impact performance.

Social Media 124

Social Media Database Servers Cache 124

SQL Performance

MAY 22, 2019

It’s one of the things we look at during a health audit, and Kimberly has a great query from her Plan cache and optimizing for adhoc workloads post that’s part of our toolkit. About 1GB of the plan cache is for prepared and procedure plans, and they only take up about 300MB worth of space. DBCC FREEPROCCACHE ; GO. EXEC dbo. [

Cache 54

Cache Performance Hardware Servers 54

The Morning Paper

OCTOBER 4, 2020

Understanding operational 5G: a first measurement study on its coverage, performance and energy consumption , Xu et al., Here the first finding was that the current strategy for determining when to hand-off has a 25% probability of worsening your link performance after handover. Application performance. SIGCOMM’20.

Energy 130

Energy Latency Performance Network 130

Dotcom-Montior

JUNE 15, 2020

The limited number access points, compounded with the fact that traffic is controlled by the Ministry of Industry and Information Technology, creates performance bottlenecks for all users in China when trying to access websites from inside and outside of the country. Final Thoughts: Monitoring Performance from the Great Firewall of China.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

The Morning Paper

MAY 14, 2019

Seer: leveraging big data to navigate the complexity of performance debugging in cloud microservices Gan et al., Finally, we show that Seer can identify application level design bugs, and provide insights on how to better architect microservices to achieve predictable performance. ASPLOS’19.

Big Data 45

Big Data Cloud Performance Hardware 45

Scalegrid

APRIL 16, 2020

This is why our BYOC pricing is less than our Dedicated Hosting pricing, as the costs listed for BYOC are only what you pay for ScaleGrid and don’t include your hardware costs. While this is a good way to get a rough estimate, your monthly cloud costs will indeed vary based on the amount of backups performed and your data transfer activity.

Cloud 242

Cloud Azure AWS Database 242

Smashing Magazine

JANUARY 15, 2019

How Improving Website Performance Can Help Save The Planet. How Improving Website Performance Can Help Save The Planet. So, apart from powering servers with renewable energy, what else can web developers do about climate change? Generally speaking, we can also run the top command on any server to which we have shell access.

Website Performance 73

Website Performance Website Energy Performance 73

KeyCDN

JANUARY 23, 2020

These acronyms, which stand for real user monitoring and application performance monitoring, are software monitoring processes essential to measuring and evaluating applications in many different areas. RUM gathers data from real life users to analyze application performance. What is application performance monitoring (APM)?

Strategy 72

Strategy Metrics Monitoring Servers 72

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 129

Performance Hardware Tuning Storage 129

Percona

MAY 6, 2024

Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some of the configuration parts, mainly discussing how to dynamically change certain settings and persist those inside the configuration file.Disk persistenceLet me start with a very important setting, which is “SAVE,” that helps in performing (..)

Performance 94

Performance Cache Hardware Storage 94

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

ACM Sigarch

FEBRUARY 23, 2018

Hardware engineers design and implement solutions in RTL, while software engineers attempt to solve the problem either at the OS or application level. Architects were always aware of the impact speculative execution has on the performance of microarchitectural structures from branch predictors to caches.

Architecture 47

Architecture Cache Hardware Virtualization 47

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 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. The actual overhead depends on your workload.

Java 145

Java Cache Google Hardware 145

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. Ryan Stonecipher – Principle SQL Server Software Engineer. SQL Server. set nocount on.

Hardware 40

Hardware Cache Servers Software Engineering 40

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. These storage nodes collaborate to manage and disseminate the data across numerous servers spanning multiple data centers.

Storage 130

Storage Systems Big Data Azure 130

Scalegrid

DECEMBER 21, 2023

Buckle up as we delve into the world of Redis® monitoring, exploring the most important Redis® metrics, discussing essential tools, and even peering into the future of Redis® performance management. Key Takeaways Redis® monitoring is essential for safeguarding performance, reliability, and security.

Strategy 130

Strategy Monitoring Latency DevOps 130

Smashing Magazine

JUNE 18, 2020

Those aren’t accessible by JS and are sent only to your server. The issue with that is that they’re always sent to your server, even if one of your users clicks on a GET request URL on someone else’s website and that GET request has side effects you or your user won’t like. Does that mean your JWT has to be out in the open?

Storage 93

Storage Mobile Website Java 93

ScaleOut Software

APRIL 22, 2020

The Solution: Distributed Caching. A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. This speeds up accesses and updates while offloading back-end database servers.

Cache 52

Cache Storage Servers Database 52

ScaleOut Software

APRIL 22, 2020

The Solution: Distributed Caching. A widely used technology called distributed caching meets this need by storing frequently accessed data in memory on a server farm instead of within a database. This speeds up accesses and updates while offloading back-end database servers.

Cache 52

Cache Storage Servers Database 52

Dynatrace

AUGUST 30, 2019

Digital Performance: 99% reduction in Response Time, from 18.2s Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. Dynatrace Real User Monitoring (RUM) captures very detailed user behavior, as well as experience and performance information, about every user on your applications.

Cache 197

Cache Architecture Database Government 197

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Let’s get started. Serverless architecture: A primer. Simplicity. Data Store.

Serverless 279

Serverless AWS Lambda Storage 279

Percona

AUGUST 8, 2023

Or worse yet, sometimes I get questions about regaining normal operations after a traffic increase caused performance destabilization. Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance.

Traffic 92

Traffic Cache Monitoring Database 92

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

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

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

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here. Cached vs Scaled Workloads. What is HammerDB?

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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

Smashing Magazine

AUGUST 22, 2021

HTTP/3: Performance Improvements (Part 2). HTTP/3: Performance Improvements (Part 2). In this second part, we will zoom in on the performance improvements that QUIC and HTTP/3 bring to the table for web-page loading. HTTP/3 performance features ( current article ). Robin Marx. 2021-08-23T06:20:00+00:00.

Performance 106

Performance Network Latency Servers 106

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124

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., The paper examines the implications of microservices at the hardware, OS and networking stack, cluster management, and application framework levels, as well as the impact of tail latency. ASPLOS’19.

Open Source 61

Open Source Hardware Benchmarking Systems 61

Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. How does high availability work?

Availability 111

Availability Database Open Source Hardware 111

ACM Sigarch

OCTOBER 12, 2020

The focus of most published research in architecture is on applications implemented in high-performance, “ close-to-the-metal” languages essentially developed before computers got fast. The current state-of-the-art Python compiler, pypy , often yields around a 2x improvement in performance (and sometimes less).

C++ 108

C++ Benchmarking Hardware Architecture 108