Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Various partition types, like RANGE, LIST, HASH, and KEY, are used for specific needs, from range-based data to custom criteria, to ensure efficient data handling and the optimization of queries.

Strategy 40

Strategy Storage Database Best Practices 40

The Netflix TechBlog

FEBRUARY 13, 2020

By Aditya Mavlankar, Jan De C**k¹, Cyril Concolato, Kyle Swanson, Anush Moorthy and Anne Aaron TL; DR We need an alternative to JPEG that a) is widely supported, b) has better compression efficiency and c) has a wider feature set. High-Efficiency Video Coding ( HEVC ) is the successor of H.264, 264, a.k.a.

Code 212

Code Metrics Efficiency Open Source 212

Percona

JANUARY 19, 2023

In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. You can refer to the documentation for further details. Redundant indexes: It is known that accessing rows by fetching an index is more efficient than through a table scan in most cases.

Open Source 87

Open Source Storage Database Big Data 87

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. If a primary server fails, a backup server can take over and continue to serve requests.

Availability 107

Availability Database Open Source Hardware 107

Percona

APRIL 17, 2023

Since MongoDB usually works with a replica set, it is possible to increase this parameter to get better performance: # edit /etc/mongod.conf storage: journal: enabled: true commitIntervalMs: 300 WiredTiger cache For dedicated servers, it is possible to increase the WiredTiger(WT) cache. By default, it uses 50% of the memory + 1 GB.

Best Practices 52

Best Practices Design Tuning Database 52

Percona

DECEMBER 14, 2022

But while eminently capable of performing OLAP, it’s not quite as efficient. The CITUS columnar extension feature set includes: Highly compressed tables: Reduces storage requirements. The complete CITUS feature set which, except for the Columnar storage component, is not covered in this blog, includes: Distributed tables.

Database 92

Database Analytics Storage Processing 92

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Tim Kadlec

JANUARY 9, 2019

This point is extremely well documented by now, but warrants repeating. The YouTube feather story —where they improved performance and saw an influx of new users from areas with poor connectivity who could, for the first time, actually use the site—is well documented by now. Hardware gets better, sure. Performance as exclusion.

Performance 111

Performance Energy Internet Internet 111

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document.

Servers 40

Servers Cache Media Hardware 40

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. Efficiently enables new styles of drawing content on the web , removing many hard tradeoffs between visual richness , accessibility, and performance. These TransformStream types help applications efficiently deal with large amounts of binary data. CSS Custom Paint.

Media 145

Media Games Education Engineering 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

All Things Distributed

JANUARY 18, 2012

In response, we began to develop a collection of storage and database technologies to address the demanding scalability and reliability requirements of the Amazon.com ecommerce platform. After the successful launch of the first Dynamo system, we documented our experiences in a paper so others could benefit from them. Amazon DynamoDBâ??s

Scalability 167

Scalability Database Ecommerce Latency 167

Brendan Gregg

SEPTEMBER 5, 2017

I wrote a page on it: [perf]. - **eBPF**: tracing features completed in 2016, this provides efficient programmatic tracing to existing kernel frameworks. There's a lot about Linux containers that isn't well documented yet, especially since it's a moving target. It's the official profiler.

Virtualization 76

Virtualization AWS Engineering Hardware 76

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. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable.

Latency 63

Latency Analytics Scalability Engineering 63

Alex Russell

OCTOBER 22, 2017

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., The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. for router components). Parsing CSS.

Performance 68

Performance Benchmarking Network Mobile 68

Dynatrace

AUGUST 5, 2019

Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. Optimize Query Performance and Data Storage Cost. Extract less critical data into a cheaper database storage option. Optimize the performance of key queries.

Cloud 31

Cloud Traffic Database Network 31

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. After reading ​​ this document you will better understand SQL Server I/O needs and capabilities.

Servers 40

Servers Cache Database Media 40

Percona

AUGUST 27, 2018

MySQL 8 introduced a feature that is explained only in a single documentation page. assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Currently, CPU affinity (i.e., Another cool useless feature???

Tuning 44

Tuning Virtualization Testing Servers 44

O'Reilly

SEPTEMBER 19, 2023

It progressed from “raw compute and storage” to “reimplementing key services in push-button fashion” to “becoming the backbone of AI work”—all under the umbrella of “renting time and storage on someone else’s computers.” A single document may represent thousands of features.

Hardware 99

Hardware Storage Big Data Blockchain 99

Alex Russell

JULY 14, 2021

To quote the Android documentation , a WebView is.: Here, native apps are doing work related to their core function; storage and tracking of user data are squarely within the four corners of the app's natural responsibilities. Hardware access APIs, notably: Geolocation. But neither has to be. What is a WebView? Web Bluetooth.

Google 121

Google Mobile Engineering Internet 121

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). In exchange, your team gains maintainability and developer efficiency, of course. Getting started with Webpack can be tough though. But this consideration needs to be deliberate. Unless they don't.

Performance 104

Performance Cache Network Metrics 104

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing and execution times (we’ll talk about them in detail later). Site speed topography , with key metrics represented for key pages on the site. Large preview ).

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 6, 2020

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). In exchange, your team gains maintainability and developer efficiency, of course. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Network Metrics 145