All Things Distributed

JUNE 20, 2017

The new AWS Asia Pacific (Hong Kong) Region will have three Availability Zones and be ready for customers for use in 2018. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing).

AWS 125

AWS Logistics Cloud Social Media 125

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 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. What is PostgreSQL performance tuning?

Tuning 52

Tuning Database Efficiency Performance 52

Smashing Magazine

NOVEMBER 22, 2021

Back in 2018 Google announced that sites with especially slow pages on mobile would be penalized. Another advantage of field measurements is that they match the approach taken by Google in order to collect performance data into the CrUX database. The results of some of these APIs are also cached in a CDN as appropriate.

Website 141

Website Performance Google Website Performance 141

Jos

JUNE 2, 2018

presented in Google IO 2018 ( source ) These tools make it easier to determine where we need to put emphasis to improve our sites. How would you architecture a non-trivial size web project (client, server, databases, caching layer)? They can be run as a one-off or integrated in our development and deployment pipelines.

Performance 237

Performance Speed Google Media 237

MachMetrics

DECEMBER 14, 2019

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. Source: ThinkWithGoogle. seconds on desktop and 2.59

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. Is this a problem ?

Tuning 69

Tuning Cache Database Storage 69

The Morning Paper

JUNE 20, 2019

In total, there were 112 such incidents over the period March – September 2018 (not all of them affecting external customers). In 40% of cases different parties assume different formats for shared files or database tables. It looks like data validation isn’t only useful in a machine learning context !

Cloud 81

Cloud Azure Cache C++ 81

Speed Curve

FEBRUARY 5, 2024

Charlie Vazac introduced server timing in a Performance Calendar post circa 2018. Caching the base page/HTML is common, and it should have a positive impact on backend times. Key things to understand from your CDN Cache Hit/Cache Miss – Was the resource served from the edge, or did the request have to go to origin?

Servers 64

Servers Cache Benchmarking Retail 64

Alex Russell

APRIL 29, 2021

After years of standards discussion and the first delivered to other platforms in 2018, iOS 14.5 April 2018 , but not usable until several releases later). An extension to Service Workers that enables browsers to present users with cached content when offline. finally shipped Audio Worklets this week. Pointer Lock.

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. India became a 4G-centric market sometime in 2018. The Moto G4 , for example. 2] Getting accurate global information that isn't artificially reduced to averages remains an ongoing challenge.

Performance 127

Performance Network Mobile Metrics 127

Brendan Gregg

FEBRUARY 9, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s.

Performance 72

Performance Benchmarking Cache Tuning 72

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. Explanation.

Servers 60

Servers Cache C++ Metrics 60

Percona

JANUARY 17, 2019

Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). The second and third run used the cached data. MySQL on ec2.

Cache 72

Cache C++ AWS Airlines 72

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Oracle Log File Sync.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Smashing Magazine

JANUARY 15, 2019

The Mozilla Internet Health Report 2018 states that — especially as the Internet expands into new territory — “sustainability should be a bigger priority.” 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.

Website Performance 78

Website Performance Website Energy Performance 78

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. I wrote a number of blog posts about this back in January 2018, including these: Checking Your SQL Server Instance for Spectre/Meltdown Patches. They will also have up to 256MB of L3 cache per processor.

Servers 46

Servers Hardware Architecture Retail 46

Jos

JUNE 2, 2018

presented in Google IO 2018 ( source ). How would you architecture a non-trivial size web project (client, server, databases, caching layer)? They can be run as a one-off or integrated in our development and deployment pipelines. Google’s Lighthouse is one of them, which shows information about PWA, SEO and more.

Performance 100

Performance Speed Google Media 100

Brendan Gregg

FEBRUARY 8, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s.

Performance 40

Performance Benchmarking Cache Tuning 40

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

Smashing Magazine

OCTOBER 26, 2018

2018-10-26T13:45:46+02:00. It’s an all-in-one system that is equipped with a working admin interface; it manages database connection, and has a bunch of useful APIs exposed that handle user authentication, routing, and more. Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress. Denis Žoljom. post_slug || !

Cache 88

Cache Website Speed Testing 88

Smashing Magazine

NOVEMBER 12, 2021

They were introduced at the React Conf 2018 to address three major problems of class components: wrapper hell, huge components, and confusing classes. Memoization simply means caching. To simplify things here, we’ll be using the Redux Toolkit library with our fake database from JSONPlaceholder. Ifeanyi Dike. The useMemo Hook.

Code 122

Code Availability Performance Efficiency 122

Smashing Magazine

JANUARY 6, 2020

Globally in 2018–2019, according to the IDC, 87% of all shipped mobile phones are Android devices. PRPL stands for Pushing critical resource, Rendering initial route, Pre-caching remaining routes and Lazy-loading remaining routes on demand. An application shell is the minimal HTML, CSS, and JavaScript powering a user interface.

Performance 112

Performance Cache Servers Network 112

Smashing Magazine

JANUARY 7, 2019

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. In 2018, the Alliance of Open Media has released a new promising video format called AV1.

Performance 111

Performance Cache Network Metrics 111