Percona

JULY 15, 2023

Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. They are a roadmap that speeds up the process of finding specific rows in a large table. As such, index design must strike a balance between improved query speed and efficient data modification.

Virtualization 78

Virtualization Speed Database Efficiency 78

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 52

Performance Latency Hardware Storage 52

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Smashing Magazine

OCTOBER 22, 2019

2019-10-22T12:30:59+02:00. 2019-10-22T13:06:35+00:00. At the intersection of the two is website speed. It should come as no surprise that images cause a lot of the problems websites have with speed. According to HTTP Archive : The median size of a desktop website in 2019 is 1939.5 Suzanne Scacca.

Mobile 62

Mobile Media Website Storage 62

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 52

Performance Latency Cache Virtualization 52

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. The basic tier provides up to 5 DTUs with standard storage. vCore Pricing Tier. GB per vCore. HyperScale Database.

Azure 55

Azure Database Serverless Hardware 55

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Percona

DECEMBER 20, 2018

We look forward to providing you with even better articles, news and information in 2019. As 2018 moves into 2019, let’s take a quick look back at some of the most popular posts on the blog this year. How to Restore MySQL Logical Backup at Maximum Speed. How to Speed Up Pattern Matching Queries. Top 10 Most Read.

Database 40

Database Tuning Performance AWS 40

CSS - Tricks

JULY 18, 2019

That could potentially save a ton of server requests and precious bytes when waiting for a page to load. No more wondering how much storage is left on your server! Hey it doesn't hurt there is a 20% discount right now with DISCOUNT20 until July 31st, 2019. You get an unlimited amount of space to store anything you need.

Performance 41

Performance Storage Speed Servers 41

SQL Performance

FEBRUARY 3, 2020

Applying page or row compression (both online/offline) to the source before the affinitized copy (offline), to see if compressing the data first could speed up the destination. The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019. tblOriginal.

Speed 113

Speed Processing Servers Storage 113

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. km university campus. The 5G network is operating at 3.5GHz).

Energy 130

Energy Latency Performance Network 130

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. What is HammerDB? HammerDB is a software application for database benchmarking. Adoption by the TPC. Usage and industry adoption.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Enprowess

JANUARY 12, 2022

Web development is evolving at a rapid speed with each passing year. And so, it optimizes the page loading speed and reduces the bounce rate. So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Blockchain technology is an encrypted database storage system.

Blockchain 59

Blockchain IoT Development Serverless 59

Smashing Magazine

JANUARY 11, 2021

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. Note : If you use Page Speed Insights or Page Speed Insights API (no, it isn’t deprecated!),

Performance 145

Performance Cache Media Metrics 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. The worldwide ASP 18 months ago was ~$300USD , so the average performance in the deployed fleet can be represented by a $300 device from mid-2019. So what did $150USD fetch in 2019?

Performance 124

Performance Network Cache Metrics 124

The Morning Paper

DECEMBER 3, 2019

My fear is that all too often it’s like jumping on a motorbike and tearing off at great speed (rapid initial progress), only to ride around a bend and find a brick wall across the road in front of you. It’s going to pick up speed. Declarative assembly of web applications from predefined concepts De Rosso et al., – Heather Miller.

Open Source 52

Open Source Programming Speed Software 52

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Is it expensive JavaScript, slow web font delivery, heavy images, or sluggish rendering? Large preview ).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

MARCH 28, 2019

2019-03-28T10:30:39+01:00. 2019-04-29T18:34:58+00:00. Because server technology is rarely understood by the people who own websites, it’s easy for them to mistakenly think they can save money there. You build an amazing website that aims to do exactly what your client wanted, but the server technology is holding it back.

Website 48

Website Servers Design Traffic 48

O'Reilly

DECEMBER 2, 2019

High-speed networks through 5G may represent the next generation of cord cutting. Rural connectivity is a persistent problem; many rural users (and some urban users) are still limited to dial-up speeds. We’ve seen the reaction to news that Amazon’s Echo and Google Home send recordings of conversations back to the server.

Wireless 53

Wireless Serverless IoT Artificial Intelligence 53

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . HammerDB difference from Sysbench. hardware limits: 1000 MHz - 3.80 current CPU frequency: 1.99

Best Practices 40

Best Practices Scalability Performance C++ 40

Testsigma

NOVEMBER 16, 2021

In the summer of 2019, British Airways faced a technical issue on its website. Considering this requirement and the website load, enterprises generally set up multiple servers and machines that can talk to each other through a network. This includes the design principles, server communications or data transfers and storage.

Testing 52

Testing Website Small Business Internet 52

Smashing Magazine

SEPTEMBER 26, 2019

2019-09-26T12:30:59+02:00. 2019-09-26T11:02:12+00:00. This flexible approach is well-established and widely-adopted by back-end and server architects. There are several ways you can organize Host and Alien: Different domains or IP addresses; Different folders on your server; git submodules ; And so on. Denys Mishunov.

Architecture 73

Architecture Virtualization Servers Technology 73