Percona

APRIL 24, 2023

The urge to create more and more indexes is found to be causing severe damage in many systems. Many times, removing indexes is what we should be doing first before considering any new indexes for the benefit of the entire system. This post is about PostgreSQL, but most of the problems also apply to other database systems.

Tuning 125

Tuning Cache Storage Database 125

The Netflix TechBlog

JUNE 4, 2019

Because microprocessors are so fast, computer architecture design has evolved towards adding various levels of caching between compute units and the main memory, in order to hide the latency of bringing the bits to the brains. This avoids thrashing caches too much for B and evens out the pressure on the L3 caches of the machine.

Cache 251

Cache Latency Airlines Logistics 251

DZone

FEBRUARY 21, 2021

CPU consumption in Unix/Linux operating systems are studied using 8 different metrics: User CPU time , System CPU time , nice CPU time , Idle CPU time , Waiting CPU time , Hardware Interrupt CPU time , Software Interrupt CPU time , and Stolen CPU time. In this article, let's study ‘nice CPU time’. What Is ‘nice’ CPU Time?

Operating System 133

Operating System Hardware Metrics Systems 133

John McCalpin

APRIL 25, 2023

For most high-end processors these values have remained in the range of 75% to 85% of the peak DRAM bandwidth of the system over the past 15-20 years — an amazing accomplishment given the increase in core count (with its associated cache coherence issues), number of DRAM channels, and ever-increasing pipelining of the DRAMs themselves.

Benchmarking 97

Benchmarking Cache Latency Tuning 97

The Morning Paper

MAY 23, 2019

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. Existing cache and main memory compression techniques compress data in small fixed-size blocks, typically cache lines. ” The big idea. What about arrays? We want Zippads to compress both well.

Cache 61

Cache Benchmarking Hardware Java 61

Percona

MARCH 23, 2023

By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way. Operating system Linux is the most common operating system for high-performance MySQL servers. A recommended value is two times the number of CPUs plus the number of disks.

Performance 123

Performance Hardware Tuning Storage 123

Dynatrace

DECEMBER 15, 2020

Upcoming Operating systems support changes. The following operating systems will no longer be supported starting 01 February 2021. The following operating systems will no longer be supported starting 01 May 2021. The following operating systems will no longer be supported starting 01 June 2021.

Operating System 109

Operating System Java Mobile Cache 109

ScaleOut Software

MAY 15, 2014

Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers. One or more specified cache servers are unavailable, which could be caused by busy network or servers. …). Please retry later.

Cache 40

Cache Servers Network Design 40

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. This allows us to know our operating environment and its capability. Operating System: Ubuntu 22.04 Operating System: Ubuntu 22.04 Database: MySQL 8.0.31 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

Official Blog - World Web Technology

AUGUST 27, 2023

Regarding CMS, PHP can be integrated with other content management systems, such as WordPress, to build robust ecommerce websites. Various techniques, such as caching and optimization, improve the website’s performance and speed. Furthermore, opcode caching allows developers to speed up PHP code execution.

Development 98

Development Ecommerce Open Source Website 98

Percona

MAY 1, 2023

It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies.

Tuning 52

Tuning Efficiency Database Performance 52

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., Systems built with lots of microservices have different operational characteristics to those built from a small number of monoliths, we’d like to study and better understand those differences.

Open Source 61

Open Source Hardware Benchmarking Systems 61

All Things Distributed

DECEMBER 18, 2012

Werner Vogels weblog on building scalable and robust distributed systems. I am pretty sure some if not all of these papers deserved to be elected to the hall of fame of best papers in distributed systems. Feb 11 - A Survey of Rollback-Recovery Protocols in Message-Passing Systems , E. All Things Distributed. Comments ().

Operating System 144

Operating System Cache AWS Scalability 144

Percona

NOVEMBER 7, 2023

This book has five major sections on MVCC and Isolation (108 pages), Buffer Cache and WAL (53 pages), Locks (42 pages), Query Execution (154 pages), and the types of indexes (127 pages). Now, this operation blocks all reads and writes during the operation.

Cache 87

Cache Servers Operating System Database 87

HammerDB

JUNE 27, 2022

HammerDB has graphical and command line interfaces for the Windows and Linux operating systems. An important concept was to simulate database users called Virtual Users in parallel (rather than concurrently) to accurately simulate a real database workload with multiple users running from separate systems. HammerDB Licensing.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Morning Paper

DECEMBER 10, 2019

. …software operating on persistent data structures requires "global" pointers that remain valid after a process terminates, while hardware requires that a diverse set of devices all have the same mappings they need for bulk transfers to and from memory, and that they be able to do so for a potentially heterogeneous memory system.

Hardware 52

Hardware Virtualization Operating System Programming 52

SQL Server According to Bob

NOVEMBER 8, 2016

Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Tail Of Log Caching.

Cache 40

Cache Servers Media Storage 40

Smashing Magazine

MAY 25, 2021

If you want to use web fonts your choices are basically Flash of Invisible Text (aka FOIT) where the text is hidden until the font downloads or Flash of Unstyled Text (FOUT) where you use the fallback system font initially and then upgrade it to the web font when it downloads. Making Your Fallback Font More Closely Match Your Font.

Operating System 143

Operating System Google Website Cache 143

Smashing Magazine

JUNE 20, 2019

Without Google Fonts you would be limited to the handful of “ system fonts ” installed on your user’s device. System fonts or ‘Web Safe Fonts’ are the fonts most commonly pre-installed across operating systems. Browser Caching. Another built-in optimization of Google Fonts is browser caching.

Google 111

Google Performance Cache Website 111

SQL Performance

MARCH 30, 2021

A parallel query might start out requesting DOP 8, but be progressively downgraded to DOP 4, DOP 2, and finally DOP 1 due to a lack of system resources at that moment. Running a parallel plan on a single thread can also happen when a cached parallel plan is reused by a session that is limited to DOP 1 by an environmental setting (e.g.

Cache 98

Cache Servers Operating System Processing 98

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

Official Blog - World Web Technology

NOVEMBER 9, 2023

On top of that, PHP is used to run famous content management systems like Joomla, WordPress, and Drupal. Creating tools and systems and offering online resources help the language keep growing and improving. Windows, macOS, Linux, and other running systems can use it and provide easy PHP development in India.

Website 59

Website Development Open Source Database 59

The Morning Paper

DECEMBER 8, 2019

At the start of November I was privileged to attend HPTS (the High Performance Transaction Systems) conference in Asilomar. Byte-addressable non-volatile memory,) NVM will fundamentally change the way hardware interacts, the way operating systems are designed, and the way applications operate on data. PLOS’19.

Hardware 56

Hardware Programming Media Storage 56

Randon ASCII

SEPTEMBER 8, 2019

The fact that this shows up as CPU time suggests that the reads were all hitting in the system cache and the CPU time was the kernel overhead (note ntoskrnl.exe on the first sampled call stack) of grabbing data from the cache. Remember that these are calls to the operating system – kernel calls.

Latency 79

Latency Cache Programming Operating System 79

SQL Server According to Bob

MAY 19, 2019

Partitioning allows SQL Server to scale to the largest systems with record-setting performance. When promoted to a super-latch on a 64 CPU system the memory requirement becomes 32 + (32 *64) = 2080 bytes. However, on smaller systems and VMs the partitioning may not be required to maintain performance. IO Request Caches.

IoT 61

IoT Servers Development Cache 61

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. And while you can usually cache the full page of an article, the same is not true of many shop pages and elements. On design systems, CSS/JS and smart interface design patterns.

Performance 115

Performance Cache Website Mobile 115

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

Percona

AUGUST 31, 2018

If queries perform full table scans where an index could be used or perform heavy joins or expensive aggregate operations, then the system can still perform poorly even if the database parameters are tuned. The PostgreSQL buffer is called shared_buffer which is the most effective tunable parameter for most operating systems.

Tuning 55

Tuning Database Performance Benchmarking 55

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. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. The Back Story.

Servers 90

Servers Media Cache Storage 90

Adrian Cockcroft

JANUARY 20, 2023

on Myths and Legends of High Performance Computing  — it’s a somewhat light-hearted look at some of the same issues by the leader of the team that built the Fugaku system I mention below. HPCG is led by Japan’s RIKEN Fugaku system at 16 petaflops, which is 3% of it’s peak capacity. Next generation architectures will use CXL3.0

Architecture 52

Architecture Latency Benchmarking AWS 52

The Morning Paper

APRIL 14, 2019

Just as today’s systems offer memory protection, they call this time protection. Microarchitectural state of interest includes data and instruction caches, TLBs, branch predictors, instruction- and data-prefetcher state machines, and DRAM row buffers. set out a principled basis for protecting against this class of attacks.

Hardware 44

Hardware Cache Latency Speed 44

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Dotcom-Montior

JUNE 15, 2020

Operating System Updates and Security Patches. Since the majority of gadgets are produced in China, the government of China has collaborated with the manufacturers of mobile phones, tablets, and laptops to customize operating systems, such as Windows, Android, and IOS, based on the Great Firewall’s internet security guidelines.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

The Morning Paper

NOVEMBER 19, 2019

On the other hand we have good old-fashioned native apps that you install on your operating system (a dying breed? With a traditional OS app 2 you have much more control over the data (the files on your file system at least, which if you’re lucky might even be in an open format). Google Docs, Trello, …). It should be fast.

Cloud 83

Cloud Software Software Internet 83

SQL Server According to Bob

AUGUST 23, 2021

For example: A memory node with 64 CPUs is a complete, O perating System, ​​ scheduler group. The job object can be configured to limit the resource usage on the system, including which nodes and CPUs the processes started under its control​​ may ​​ utilize.

Servers 40

Servers Azure Operating System Database 40

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

MachMetrics

DECEMBER 14, 2019

It is typically reduced via server-side optimizations, such as enabling caching and database indexes. TTFB measures the time that elapses between when a user requests a site, and when that user’s browser receives the first bit of information. In the analysis, the average TTFB speed was found to be 1.28 seconds on desktop and 2.59

Best Practices 105

Best Practices Speed Mobile Google 105