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. The second and third run used the cached data. It does not use any cache (ie: innodb buffer pool) either. This query is 100% cached. Test data and versions.

Cache 46

Cache C++ AWS Airlines 46

SQL Performance

APRIL 20, 2021

A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml. Additional parallel workers will be started to run the additional parallel tasks contained in branches B, C, and D. Starting Sequence.

C++ 98

C++ Processing Servers Cache 98

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). > system.time(wait1 <- normalmixEM(waiting, mu=c(50,80), lambda=.5, Changes in behavior of the system from minute to minute is going to change the height of each peak, as the workload mix and cache hit rates change.

Lambda 98

Lambda Latency Cache C++ 98

SQL Performance

SEPTEMBER 25, 2019

The general idea is to cache and replay results, saving repeated executions of inner-side operators wherever possible. When a spool is able to replay cached results, this is known as a rewind. You may find it helpful to think of a spool rebind as a cache miss, and a rewind as a cache hit. Lazy Table Spool.

Performance 104

Performance Cache Servers Education 104

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. Notes on notation: C[i][j] is invariant in the innermost loop, so I refer to the values in the accumulator as elements of the C array.

Cache 40

Cache C++ Latency Hardware 40

Smashing Magazine

OCTOBER 26, 2018

When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. on December 6th, 2016. Improving performance with the decoupled JSON approach. Security concerns. So, What Exactly Is A Decoupled WordPress?

Cache 78

Cache Website Speed Database 78

Percona

JUNE 4, 2023

GA 23 February 2016 5.7.10-3 MyISAM is modified with segmented key caches, the default temporary table storage engine is Aria (which is a crash-safe MyISAM), the FederatedX engine is a modified FEDERATED engine, and there are more: CONNECT, Mroonga, OQGRAPH, Sequence, SphinxSE, SPIDER, TokuDB and of course MyRocks.

Open Source 52

Open Source Servers Storage Scalability 52