Percona

JULY 17, 2023

5 among all database management systems and No. 1 among non-relational/document-based systems ( DB-Engines, July 2023 ). Instead of the table-based structure of relational databases, MongoDB stores data in documents and collections, a design for handling large amounts of unstructured data and for real-time web applications.

Open Source 79

Open Source Database Scalability Software 79

Percona

MAY 2, 2023

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. 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. Q: I have a MySQL server, and my application is writing at a rate of 100 MB/hour in my redo logs.

Social Media 124

Social Media Database Servers Cache 124

SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

The Netflix TechBlog

SEPTEMBER 8, 2020

For each route we migrated, we wanted to make sure we were not introducing any regressions: either in the form of missing (or worse, wrong) data, or by increasing the latency of each endpoint. You can find a lot more details about how this works in the Spinnaker canaries documentation. This meant that data that was static (e.g.

Latency 233

Latency Cache Java Traffic 233

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. Operating System (OS) settings Swappiness Swappiness is a Linux kernel setting that influences the behavior of the Virtual Memory manager when it needs to allocate a swap, ranging from 0-100.

Best Practices 52

Best Practices Design Tuning Database 52

Smashing Magazine

AUGUST 3, 2023

Time To First Byte (TTFB) This is the time it takes for the first piece of information from the server to reach the user’s browser. You need to beware that slow server response times can significantly increase TTFB, often due to server overload, network issues, or un-optimized logic on the server side.

Performance 74

Performance Cache Traffic Metrics 74

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

CSS Wizardry

MAY 19, 2020

On this site, in which performance is the only name of the game, I forgo web fonts entirely, opting instead to make use of the visitor’s system font. On a high-latency connection, this spells bad news. However, the execution of this header is bound by the response’s TTFB, which on high-latency networks can be very, very high.

Google 364

Google Media Latency Metrics 364

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks. Why are MongoDB database backups important?

Best Practices 52

Best Practices Database Storage Servers 52

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Brendan Gregg

JULY 2, 2021

This is also applicable for people adding it to their own in-house monitoring systems. You likely already have agents running on all your customer systems. There are so many options it's really your own preference based on your existing system and customer environments. biolatency Disk I/O latency histogram heat map.

Latency 145

Latency Cache Energy Systems 145

HammerDB

OCTOBER 23, 2023

Stored Procedures and Client SQL comparison To test the stored procedures and client implementations, we ran both workloads against a system equipped with Intel Xeon 8280L. the amount of data from the server to the client to achieve the same result. On MySQL, we saw a 1.5X performance advantage. On MySQL, we saw a 1.5X

Benchmarking 62

Benchmarking Database Network C++ 62

Dynatrace

JULY 10, 2019

What Dynatrace deployment is the best fit for your technology stack, and is the OneAgent compatible with your system? OneAgents are optimized to send data to the Dynatrace servers with the smallest possible impact, querying the metrics every minute, and the data is a first-class citizen for the Dynatrace AI root-cause analysis.

Java 138

Java Best Practices Metrics Azure 138

Alex Russell

MAY 9, 2022

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Only teams that master their systems can make intentional trade-offs.

Performance 86

Performance Latency Metrics Engineering 86

Particular Software

AUGUST 16, 2021

Under the hood, each “record” in Cosmos DB is a JSON document with an ID and partition key that, together, define its globally unique ID. You can use the SQL-like query language to query over multiple documents, or if you have the ID and partition key, you can look up a single document with a point read —the cheapest query possible. ??

Azure 52

Azure Serverless Storage Database 52

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. is a server-side, open-source, JavaScript runtime environment that allows developers to write JavaScript on the client and the server-side.

Open Source 52

Open Source Virtualization Programming Servers 52

Dotcom-Montior

DECEMBER 8, 2021

Systems, web applications, servers, devices, etc., SREs and DevOps teams can use these incidents to build back better and improve their systems and services. SREs must manage complex distributed systems. We talked about monitoring distributed systems in a different article and how that pertains to SRE teams.

Social Media 90

Social Media Monitoring Latency DevOps 90

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. On design systems, UX, web performance and CSS/JS. Client Side Rendering, Server Side Rendering And Jamstack. But during SSR, the client retrieves the HTML from the server.

Performance 125

Performance Cache Servers Social Media 125

Smashing Magazine

MARCH 25, 2021

With clearly documented performance goals, various teams can have meaningful conversations about the optimal delivery of content. Consider revamping your system for optimal media delivery by doing the following: Understand your current usage. Becoming familiar with those components will enable you to set performance goals.

Media 117

Media Performance Mobile Latency 117

The Morning Paper

MARCH 3, 2020

In the same spirit as Paxos Made Live , this paper describes the details, choices and tradeoffs that are required to put a consensus system into production. This work is latency critical, because volume IO is blocked until it is complete. Cells are spread across a mesh of nodes (each node running on a single server).

Database 106

Database AWS Network Design 106

All Things Distributed

JANUARY 18, 2012

Werner Vogels weblog on building scalable and robust distributed systems. The original Dynamo design was based on a core set of strong distributed systems principles resulting in an ultra-scalable and highly reliable database system. Amazon DynamoDB offers low, predictable latencies at any scale. All Things Distributed.

Scalability 167

Scalability Database Ecommerce Latency 167

SQL Performance

FEBRUARY 26, 2020

Organizations are taking advantage of having managed backups, lots of built-in security features, an uptime SLA of 99.99%, and an always up-to-date environment where they are no longer responsible for patching SQL Server or the operating system. Gen4 is still described in the documentation , but this option is mostly unavailable now.

Azure 63

Azure Performance Storage Latency 63

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. As well, very few cases are in need to have a full system/solution to provide scalability with sharding. The POC Why this POC?

Traffic 127

Traffic Scalability Database Servers 127

The Morning Paper

FEBRUARY 23, 2020

There are five different types of member in an AnyLog system, and any network node can join without restriction as any type of member. Coordinators are servers that receive queries and return results (search engines). But there’s one critical difference – AnyLog has an integral micropayments system.

Blockchain 94

Blockchain Internet Internet IoT 94

The Netflix TechBlog

JUNE 13, 2023

This is where large-scale system migrations come into play. By collecting and analyzing key performance metrics of the service over time, we can assess the impact of the new changes and determine if they meet the availability, latency, and performance requirements. But what happens when this machinery needs a transformation?

Traffic 279

Traffic Metrics Systems Strategy 279

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications. I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

Alex Russell

OCTOBER 22, 2017

Tools and CI systems help them monitor progress & prevent regressions. This isn’t true (more on that in a follow-up post), and sites which are built this way implicitly require more script in each document (e.g., Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels. It used to provide an insight into how quickly the server outputs any data. Large preview ).

Performance 145

Performance Cache Media Metrics 145

Abhishek Tiwari

JULY 12, 2018

These nodes and edges require a good amount of compute and storage which is typically distributed across a large number servers either running in the cloud or your own data center. In a nutshell, a data pipeline is a distributed system.

Latency 63

Latency Analytics Scalability Engineering 63

Brendan Gregg

JANUARY 17, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 For large processes (> 100 Gbytes) this duration of higher latency can last over 1 second, during which this tool is consuming system CPU time. I just wrote [wss.pl] as a front-end to this feature. seconds (100 milliseconds): #./wss.pl

Cache 71

Cache Latency C++ Programming 71

cdemi

DECEMBER 4, 2016

Message Brokers are servers that take care of Queue Handling , Routing Messages, High Availability and Scaling out. Apache Kafka - High-Throughput, Low-Latency, Uses Apache ZooKeeper for Distribution, Written in Scala and Java. Message Brokers.

Design 47

Design Azure Scalability Latency 47

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” latency, startup, mocking, etc.)

Serverless 88

Serverless Architecture FinTech Infrastructure 88

Brendan Gregg

JULY 2, 2021

This is also applicable for people adding it to their own in-house monitoring systems. You likely already have agents running on all your customer systems. There are so many options it's really your own preference based on your existing system and customer environments. biolatency Disk I/O latency histogram heat map 5.

Open Source 40

Open Source Latency Cache Energy 40

O'Reilly

DECEMBER 2, 2019

I don’t need more bandwidth for video conferences or movies, but I would like to be able to download operating system updates and other large items in seconds rather than minutes. There are impressive estimates for latency for 5G, but reality has a tendency to be harsh on such predictions.

Wireless 53

Wireless Serverless IoT Artificial Intelligence 53

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. Firstly for system choice a 2 socket system is optimal for PostgreSQL OLTP performance at the time of writing. maximum transition latency: Cannot determine or is not supported.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. What does it mean?

Performance 145

Performance Cache Network Metrics 145