article thumbnail

InnoDB Performance Optimization Basics

Percona

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Benchmark before you decide.

article thumbnail

How Parallel Plans Start Up – Part 1

SQL Performance

I used the public Stack Overflow 2013 database ( download details ). 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. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details.

Cache 98
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

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.

article thumbnail

Expanding the Cloud – An AWS Region is coming to Hong Kong

All Things Distributed

In 2013, AWS opened an office in Hong Kong. Beyond running their web properties and applications, Next Digital also uses Amazon RDS (database), Amazon ElastiCache (caching), and Amazon Redshift (data warehousing). Since then, AWS has added two more PoPs in Hong Kong, the latest in 2016.

AWS 146
article thumbnail

Progress Delayed Is Progress Denied

Alex Russell

Browser release notes and caniuse tables since Blink forked from WebKit in 2013 [7]. have been available in iOS since 2013 with iOS 7.0. An extension to Service Workers that enables browsers to present users with cached content when offline. What follows is an attempt at a full an accounting of features launched in this era.

Media 145
article thumbnail

The Performance Inequality Gap, 2021

Alex Russell

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 cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively. The Moto G4 , for example. twitter.com/slightlylate/status/1139684093602349056 455 06:18 AM · Feb 28, 2020.

article thumbnail

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]

Smashing Magazine

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. An application shell is the minimal HTML, CSS, and JavaScript powering a user interface.