Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index.

Performance 136

Performance Monitoring Traffic Database 136

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. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

The Netflix TechBlog

MARCH 5, 2019

the order of the rows on your Netflix home page, issuing content licenses when you click play, finding the Open Connect cache closest to you with the content you requested, and many more). A majority of the Netflix product features are either partially or completely dependent on one of our many micro-services (e.g.,

Infrastructure 185

Infrastructure Cloud Scalability AWS 185

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 117

Monitoring Scalability Database Cache 117

High Scalability

DECEMBER 18, 2018

Senior DevOps Engineer : Your engineering work will focus on using your deep knowledge of the web stack including firewalls, web applications, caches and data stores ­ to create innovative infrastructure architectures that are resilient, scalable, and blazingly fast. Need excellent people? Advertise your job here!

Healthcare 122

Healthcare Best Practices DevOps Cache 122

All Things Distributed

JUNE 21, 2017

Today, I'm excited to announce the general availability of Amazon DynamoDB Accelerator (DAX) , a fully managed, highly available, in-memory cache that can speed up DynamoDB response times from milliseconds to microseconds, even at millions of requests per second. Adding caching when your app is already experiencing load is not easy.

Speed 95

Speed Cache Latency AWS 95

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 128

Servers Best Practices Database Open Source 128

MachMetrics

DECEMBER 14, 2019

Google’s best practice is to have a speed index under 3 seconds. Google’s best practice is to be below 0.5 However, Google’s best practice is to keep the number of requests below 50, so there is still work to be done. Google’s best practice is to achieve a time under 1.3

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Understanding the PostgreSQL Hostname Hostname is a key factor for the effective management of PostgreSQL databases and providing secure access.

Database 130

Database Servers Network Storage 130

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Database Efficiency Performance 52

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 75

Cache Database Games Healthcare 75

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. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 144

Traffic Scalability Database Servers 144

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. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it.

Best Practices 111

Best Practices Tuning Testing Database 111

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app. We used TanStack Query (formerly known as react-query ) for both fetching data and query caching.

Cache 84

Cache Strategy Best Practices Design 84

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. In the example below, I will show how to set the WiredTiger cache.

Scalability 75

Scalability Best Practices Servers Database 75

Smashing Magazine

AUGUST 3, 2023

Layout Shifts From Dynamic And Static Content We have been using dynamic content serving, where each request reaches our back-end server and triggers processes like database retrievals and page renderings. It also opens up the possibility for more effective use of caching strategies, potentially enhancing load times further.

Performance 78

Performance Cache Traffic Metrics 78

Official Blog - World Web Technology

NOVEMBER 9, 2023

Easy to Integrate with Databases PHP has built-in solid support for working with databases, making it perfect for making websites driven by databases. It works with many databases, including well-known ones like Oracle, MySQL, and PostgreSQL. It’s compatible with numerous databases and frameworks.

Website 59

Website Development Open Source Database 59

SQL Performance

JUNE 21, 2019

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. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

HammerDB

OCTOBER 17, 2018

However most people use HammerDB with keying and thinking time disabled and therefore each virtual user can approximately drive the CPU resources of one CPU core on the database server. Note that if using CPUs with Hyper-Threading allow for additional CPU capacity, so size as if there were 35% more physical cores.

C++ 40

C++ Testing Virtualization Cache 40

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. I predominantly use Nginx, and I have a particular fondness for FastCGI cache and have found it to be especially efficient. We should use HTTP2 over HTTPS.

Website Performance 78

Website Performance Website Energy Performance 78

Particular Software

MAY 8, 2023

However, distributed systems are inherently complex and consist of many components: message brokers, databases, distributed caches, integration points, REST APIs, front-ends, and more. The flow in this article is just a simple example to illustrate the point…and an opportunity to remind you of this best practice at the same time.

Systems 52

Systems C++ Azure Metrics 52

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. ‍This workflow not only streamlines processes but also ensures that any changes are in line with the organization's best practices and compliance standards.‍Advantages

Open Source 52

Open Source DevOps AWS Infrastructure 52

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. AutomationCode-based systems also shine in automation. If attempted through a UI, this same automation will be much harder and error-prone.

Open Source 40

Open Source DevOps AWS Infrastructure 40

KeyCDN

AUGUST 29, 2019

According to Google, the best practice for a website’s speed is to keep it under 3 seconds load time. As we can see from the graph below, this best practice is far from being met for sites based in the United States. Static sites don’t require a backend or database and are much more simple to manage. location ~*.(js|css|png|jpg|svg|jpeg|gif|ico)$

Google 103

Google Cache Speed Analytics 103

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40

Servers Cache Database Media 40

Smashing Magazine

NOVEMBER 30, 2021

We last talked to him in July 2020 , where we asked if modern best practices about for the web. Last time we talked, we posed this question of if modern best practices, the use of reactive frameworks and these sorts of things were actually bad for the progress of the web. Drew: You want it to remain unspoiled.

Technology 114

Technology Technology Servers Code 114

Abhishek Tiwari

SEPTEMBER 15, 2024

ADR 1: Choice of Database Technology ## Context Our application needs to handle large volumes of unstructured data with high write throughput. ## Decision We will use MongoDB as our primary database. ## Rationale - MongoDB's document model suits our unstructured data better than a relational model. -

Engineering 59

Engineering Best Practices Code Software Engineering 59

Smashing Magazine

NOVEMBER 12, 2021

The plugin provides useful warnings and hints on the best practices. Memoization simply means caching. It caches the computation result with respect to the dependency values so that when the same values are passed, useMemo will just spit out the already computed value without recomputing it again. The useMemo Hook.

Code 122

Code Availability Performance Efficiency 122

Smashing Magazine

JANUARY 6, 2020

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). The idea is quite straightforward: Push the minimal code needed to get interactive for the initial route to render quickly, then use service worker for caching and pre-caching resources and then lazy-load routes that you need, asynchronously.

Performance 112

Performance Cache Servers Network 112

Smashing Magazine

JANUARY 7, 2019

From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19). From Fast By Default: Modern Loading Best Practices by Addy Osmani (Slides 18, 19). PRPL stands for Pushing critical resource, Rendering initial route, Pre-caching remaining routes and Lazy-loading remaining routes on demand.

Performance 111

Performance Cache Network Metrics 111