Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This not only enhances performance but also enables you to make more efficient use of your hardware resources, potentially resulting in cost savings on infrastructure.

Tuning 52

Tuning Database Performance Hardware 52

Dynatrace

AUGUST 30, 2019

Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. We have several YouTube Tutorials and blog posts available that show how you can use Dynatrace RUM data for Web Performance & User Experience Optimization. Impressive results I have to say! Improve Above-the-fold User Experience with Dynatrace.

Cache 190

Cache Architecture Database Government 190

Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness. Nobody has time for that!

Tuning 52

Tuning Efficiency Database Performance 52

Percona

JUNE 22, 2023

Database uptime and availability Monitoring database uptime and availability is crucial as it directly impacts the availability of critical data and the performance of applications or websites that rely on the MySQL database. Disk space usage Monitor the disk space usage of MySQL data files, log files, and temporary files.

Performance 102

Performance Monitoring Traffic Database 102

Brendan Gregg

FEBRUARY 28, 2023

## References I've reproduced the references from my SREcon22 keynote below, so you can click on links: - [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] Jul 2008 - [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] 2010 - [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 110

Performance Latency Cache Virtualization 110

CSS Wizardry

AUGUST 7, 2019

TTFB isn’t just time spent on the server, it is also the time spent getting from our device to the sever and back again (carrying, that’s right, the first byte of data!). A trip from a device in London to a server in New York has a theoretical best-case speed of 28ms over fibre, but this makes lots of very optimistic assumptions.

Latency 269

Latency Ecommerce Servers Mobile 269

KeyCDN

JULY 11, 2019

This is crucial due to mobile devices requiring additional optimizations because they typically have less powerful hardware and a slower network connection when compared to desktop devices. For example, while the average mobile download speed on 4G in Switzerland is fast at 35.2 Mbps ( Opensignal ). For example, the query string ?width=600&quality=70

Speed 52

Speed Website Mobile Latency 52

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. It enables the user to measure database performance and make comparative judgements about database hardware and software.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Abhishek Tiwari

DECEMBER 27, 2017

ETL refers to extract, transform, load and it is generally used for data warehousing and data integration. There are several emerging data trends that will define the future of ETL in 2018. A common theme across all these trends is to remove the complexity by simplifying data management as a whole.

Big Data 49

Big Data Artificial Intelligence Storage Hardware 49

The Morning Paper

APRIL 14, 2019

The paper sets out what we can do in software given today’s hardware, and along the way also highlights areas where cooperation from hardware will be needed in the future. Microarchitectural channels. There are also stateless interconnects including buses and on-chip networks. Threat scenarios. The five requirements of Time Protection.

Hardware 44

Hardware Cache Latency Speed 44

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. It will help you build up a company-tailored case study with real data.

Performance 145

Performance Cache Media Metrics 145

Abhishek Tiwari

DECEMBER 13, 2017

Can machine learning-based data structures i.e. learned data structures replace traditional data structures? The initial results show that learned data structures can outperform existing data structures. This has far-reaching implications how future data systems and algorithms will be designed. p = F(Key) ?

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

SQL Performance

APRIL 27, 2020

Many of the newer features we have in SQL Server were initially launched in Azure SQL Database, including (but not limited to) Always Encrypted, Dynamic Data Masking, Row Level Security, and Query Store. Gen 5 is the primary hardware option now for most regions since Gen 4 is aging out. DTU Pricing Tier. GB per vCore.

Azure 55

Azure Database Serverless Hardware 55

CSS - Tricks

JULY 25, 2019

In this article, we uncover how PageSpeed calculates it’s critical speed score. It’s no secret that speed has become a crucial factor in increasing revenue and lowering abandonment rates. Now that Google uses page speed as a ranking factor, many organizations have become laser-focused on performance. Cache-Headers missing?

Google 71

Google Engineering Speed Mobile 71

ACM Sigarch

OCTOBER 12, 2020

An inte ger in Python consumes 24 bytes instead of 4 bytes (because every object carries around type information, reference counts, and more), while the overhead for data structures like lists or dictionaries can be 4x that of their C++ counterparts. Are caches large enough for this code? Consider Python. . As Leiserson et al.

C++ 108

C++ Benchmarking Hardware Architecture 108

HammerDB

APRIL 19, 2023

GHz 4th Generation Intel Xeon Scalable processors (code-named Sapphire Rapids) Up to 20% higher compute performance than z1d instances Up to 50 Gbps of networking speed Up to 40 Gbps of bandwidth to the Amazon Elastic Block Store (EBS) We can also verify these capabilities by running some simple benchmarks on the different subsystems.

Performance 54

Performance Benchmarking Cache Storage 54

Smashing Magazine

JANUARY 6, 2020

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. It will help you build up a company-tailored case study with real data. Large preview ).

Performance 145

Performance Cache Network Metrics 145

n0derunner

DECEMBER 18, 2018

AES effectively provides Metadata Locality to complement the existing data locality that has always existed. a 10TB database with 20% hot data) we observe a 2X improvement in throughput for random access across the 2TB hot dataset. In our experiment we deliberately size the active working-set to NOT fit into the metadata cache.

Performance 40

Performance Cache Hardware Storage 40

SQL Server According to Bob

JANUARY 11, 2020

To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropriate functionality. Atomicity A transaction must be an atomic unit of work; either all of its data modifications are performed or none of them are performed.

Servers 40

Servers Cache Media Hardware 40

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 52

Performance Latency Cache Virtualization 52

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. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain. Hardware Past As Performance Prologue. The Moto G4 , for example.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

JANUARY 7, 2019

You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. It will help you build up a company-tailored case study with real data. Start Render time, Speed Index ).

Performance 104

Performance Cache Metrics Network 104

The Morning Paper

FEBRUARY 20, 2020

Given the desire to keep enterprise data within the database, and to treat models as data also, the question is can we do inference in the database with acceptable performance? A cross-optimiser then looks for opportunities to optimise the data operator parts of the query given the ML model, and vice-versa (e.g., pruning).

Processing 72

Processing Hardware Database Azure 72

The Morning Paper

SEPTEMBER 19, 2019

Their dataset has about 7B edges… Meanwhile, AnalyticDB is Alibaba’s real-time OLAP RDBMS handling 10PB of data (in excess of 100 trillion rows!). Could it be Analyzing efficient stream processing on modern hardware ? Some cool algorithms: Pigeonring speeds up thresholded similarity searches. Do we want that? Yes please!

Blockchain 46

Blockchain Hardware Google Analytics 46

The Morning Paper

OCTOBER 4, 2020

We are standing on the eve of the 5G era… 5G, as a monumental shift in cellular communication technology, holds tremendous potential for spurring innovations across many vertical industries, with its promised multi-Gbps speed, sub-10 ms low latency, and massive connectivity. Throughput and latency. Application performance.

Energy 130

Energy Latency Performance Network 130

Sutter's Mill

FEBRUARY 13, 2017

” This contains updated and new material that reflects the latest C++ standards and compilers, with a focus to using modern C++11/14/17 effectively on modern hardware and memory architectures. On April 25-27, I’ll be in Stockholm (Kista) giving a three-day seminar on “High-Performance and Low-Latency C++.”

Latency 48

Latency C++ Hardware Performance 48

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

Dotcom-Montior

JUNE 15, 2020

The censorship and monitoring of internet have evolved from anti-virus-like and firewall software to hardware security patches for all devices that uses internet. Data gathered overtime makes the Great Firewall more “intelligent” in replacing websites. All information typed by users are collected for future analysis.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

High Scalability

NOVEMBER 25, 2019

There are a couple of downsides though in case you are looking to use it to support tens of thousands of users working on hundreds of millions of files simultaneously containing petabytes of data. To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. Edge caching.

Architecture 52

Architecture Cache Azure Storage 52

SQL Performance

JUNE 21, 2019

Data loss can be detrimental to an organization. Working with and having to tell customers that they've lost data is never fun or easy. Without regularly checking for corruption, customers can find themselves in a bad place by not having backups in order to recover when that corruption affects the physical data.

Servers 49

Servers Azure Hardware Database 49

John McCalpin

NOVEMBER 5, 2016

Optimization requires vectorization and data re-use. The number of times that a data item loaded into a register can be re-used also depends on the unrolling factors. The core does not have enough load bandwidth to perform all of these extra load operations at full speed. Shouldn’t this fix the problem?

Cache 40

Cache C++ Latency Hardware 40

Smashing Magazine

JANUARY 21, 2021

Plus a service worker that caches all static assets and serves them for repeat views, along with cached versions of articles that a reader has already visited. The reasons for it are numerous, but the most important one is a huge difference in network conditions and device hardware across the world. Data from CrUX.

Performance 145

Performance Cache Mobile Network 145

SQL Server According to Bob

JANUARY 11, 2020

If ​​ it is ​​ not, ​​ the ​​ data ​​ is considered ​​ to be ​​ changed ​​ or ​​ damaged. In ​​ other words, ​​ a formula is applied ​​ to a given set of bytes.

Servers 40

Servers Cache Database Media 40

The Morning Paper

SEPTEMBER 12, 2019

To make that vision of a one-stop shop for all of an organisation’s data needs come true, we need to be able to handle the most demanding large scale machine learning tasks – those requiring distributed learning. Except there’s one glaring omission from that list: handling all of the machine learning use cases.

Network 44

Network Database Programming Hardware 44

Alex Russell

OCTOBER 22, 2017

This rework delays launch which, in turn, delays gathering data about the viability of a PWA strategy. JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Given the conflicted data we see across our other systems, this seems about right as a baseline.

Performance 68

Performance Benchmarking Network Mobile 68

ACM Sigarch

NOVEMBER 1, 2019

This blog post gives a glimpse of the computer systems research papers presented at the USENIX Annual Technical Conference (ATC) 2019, with an emphasis on systems that use new hardware architectures. GAIA proposed to expand the OS page cache into accelerator memory. ATC ’19 was refreshingly different. Heterogeneous ISA.

Architecture 12

Architecture Hardware Cache Storage 12

Smashing Magazine

APRIL 29, 2021

While great for looking at opportunities to improve your user experience, always try to consult real-world data for a complete picture of what actual users are seeing. From Speed at Scale with Katie Hempenius and I at Google I/O. Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen.

Media 145

Media Network Metrics Mobile 145