Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements.

Tuning 52

Tuning Efficiency Database Performance 52

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

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. tpcc | DELIVERY | PROCEDURE | @ | 2018-10-11 08:57:34 | 2018-10-11 08:57:34 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci |.

Best Practices 40

Best Practices Scalability Performance C++ 40

Tim Kadlec

JANUARY 9, 2019

I recently profiled a page on a Pixel 2 (released in 2017), and an Alcatel 1x (released in 2018). Mbps download speed Jake Archibald mentioned his relative getting or the 0.8 Mbps download speed my in-laws get at their house. Hardware gets better, sure. The two devices represent very different ends of the spectrum.

Performance 111

Performance Energy Internet Internet 111

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. hammerdbcli.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Randon ASCII

FEBRUARY 25, 2018

See the end of the post for an October 2018 bug fix update, or read the whole story: Flaky failures are the worst. In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Update, October 2018.

Programming 79

Programming Hardware Cache Code 79

Alex Russell

MARCH 6, 2021

India became a 4G-centric market sometime in 2018. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version. 5G looks set to continue a bumpy rollout for the next half-decade. Mind The Gap.

Performance 124

Performance Network Cache Metrics 124

Percona

AUGUST 29, 2018

You need to set a value of vm.dirty_background_bytes depending on your disk speed. There are no “good” values for these two parameters since both depend on the hardware. However, setting vm.dirty_background_ratio to 5 and vm.dirty_background_bytes to 25% of your disk speed improves performance by up to ~25% in most cases.

Tuning 54

Tuning Database Servers Processing 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. Start Render time, Speed Index ). Treo Sites provides competitive analysis based on real-world data.

Performance 145

Performance Cache Network Metrics 145

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. Note : If you use Page Speed Insights (no, it isn’t deprecated), you can get CrUX performance data for specific pages instead of just the aggregates.

Performance 103

Performance Cache Metrics Network 103

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

OCTOBER 22, 2017

JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Thankfully, this is somewhat easier than network speeds: more than half of American mobile users are on Android devices. Global Ground-Truth. Deciding what benchmark to use for a performance budget is crucial.

Performance 68

Performance Benchmarking Network Mobile 68

Abhishek Tiwari

DECEMBER 27, 2017

There are several emerging data trends that will define the future of ETL in 2018. In 2018, we anticipate that ETL will either lose relevance or the ETL process will disintegrate and be consumed by new data architectures. Leveraging the recent hardware advances. Common in-memory data interfaces. More details on this approach.

Big Data 49

Big Data Artificial Intelligence Storage Hardware 49

O'Reilly

NOVEMBER 28, 2023

That pricing won’t be sustainable, particularly as hardware shortages drive up the cost of building infrastructure. AI isn’t yet at the point where it can write as well as an experienced human, but if your company needs catalog descriptions for hundreds of items, speed may be more important than brilliant prose. from education.

Open Source 107

Open Source Artificial Intelligence Google Infrastructure 107

Smashing Magazine

JANUARY 21, 2021

The reasons for it are numerous, but the most important one is a huge difference in network conditions and device hardware across the world. We chose to focus specifically on slow mobile devices — with slow 3G, 400ms RTT and 400kbps transfer speed, just to be on the pessimistic side of things. KB, Brotlified).

Performance 145

Performance Cache Mobile Network 145

All Things Distributed

DECEMBER 12, 2018

In 2018, we launched the first Pop-Up Loft in Stockholm, offering a co-working space and access to technology and business experts to support the growth of Nordic organizations. If the solution works as envisioned, Telenor Connexion can easily deploy it to production and scale as needed without an investment in hardware.

AWS 124

AWS Cloud Games Serverless 124