Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. AWS offers four serverless offerings for storage.

Serverless 279

Serverless AWS Lambda Storage 279

Percona

APRIL 24, 2023

This post is about PostgreSQL, but most of the problems also apply to other database systems. The more indexes, the more the requirement of memory for effective caching. Indexes need more cache than tables Due to random writes and reads, indexes need more pages to be in the cache.

Tuning 128

Tuning Cache Storage Database 128

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability.

Storage 92

Storage Scalability Strategy Performance 92

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++ 103

C++ Database Cache Storage 103

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. At every checkpoint interval (Default 60 seconds), MongoDB flushes the modified pages that are marked as dirty in the cache to their respective data files (both collection-*.wt

Hardware 89

Hardware C++ Storage Cache 89

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. how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server.

Tuning 137

Tuning Cache Servers Benchmarking 137

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

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. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

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

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. Enable developers to compress data efficiently without downloading large amounts of code to the browser. An extension to Service Workers that enables browsers to present users with cached content when offline. Where Chrome Has Lagged. requestVideoFrameCallback().

Media 145

Media Games Education Engineering 145

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. The fastest Androids predictably remain 18-24 months behind, owing to cheapskate choices about cache sizing by Qualcomm, Samsung Semi, and all the rest. The Moto G4 , for example.

Performance 124

Performance Network Cache Metrics 124

The Netflix TechBlog

MARCH 6, 2019

Mounting object storage in Netflix’s media processing platform By Barak Alon (on behalf of Netflix’s Media Cloud Engineering team) MezzFS (short for “Mezzanine File System”) is a tool we’ve developed at Netflix that mounts cloud objects as local files via FUSE. Our object storage service splits objects into many parts and stores them in S3.

Media 214

Media Storage Processing Cache 214

Smashing Magazine

JANUARY 6, 2020

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). PRPL stands for Pushing critical resource, Rendering initial route, Pre-caching remaining routes and Lazy-loading remaining routes on demand.

Performance 145

Performance Cache Network Metrics 145

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 7, 2019

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). While download times are critical for low-end networks, parse times are critical for phones with slow CPUs. Assets Optimizations. Quick Wins.

Performance 104

Performance Cache Network Metrics 104