Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 103

Speed Java AWS Virtualization 103

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). With faster disks (i.e. AWS Aurora (based on MySQL 5.6) MySQL on ec2.

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

MARCH 17, 2020

I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

O'Reilly Software

APRIL 4, 2018

Google was among the pioneers that created “web scale” architectures to analyze the massive data sets that resulted from “crawling” the web that gave birth to Apache Hadoop, MapReduce, and NoSQL databases. We usually relate SQL to querying tables in relational databases. Leverage your SQL knowledge. But what is a table?

Architecture 80

Architecture Scalability Google Operating System 80

Alex Russell

APRIL 29, 2021

WebGL 2 launched for other platforms on Chrome and Firefox in 2017. is access to hardware devices. This allows customisation and use of specialised features without custom, proprietary software for niche hardware. Some commenters appear to confuse unlike hardware for differences in software. Shape Detection.

Media 145

Media Games Education Engineering 145

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. I/O lanes.

Servers 52

Servers Benchmarking Virtualization Architecture 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

Rigor

MARCH 20, 2018

I recently was asked the following question by an online retailer: “Why should I invest in monitoring the user experience when I already have monitoring for our database, infrastructure, app server, and network?”. 38% of all sites measured in Sept 2017 (~500K) are more than 75% 3rd party content.

Monitoring 40

Monitoring Retail Ecommerce Infrastructure 40

Percona

AUGUST 15, 2023

This blog was originally published in February 2017 and was updated in August 2023. MySQL replication is a process in which data from a primary MySQL database is copied and sent to one or more secondary databases, known as replicas. It also enables geographically distributed databases for disaster recovery.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. These benefits collectively contribute to a more efficient database environment.

Strategy 40

Strategy Storage Database Best Practices 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. Microsoft SQL Server Database Engine Input/Output Requirements. Device Flush.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). Gatsby.js (React), Preact CLI , and PWA Starter Kit provide reasonable defaults for fast loading out of the box on average mobile hardware. Image credit: Addy Osmani ) ( Large preview ).

Performance 111

Performance Cache Network Metrics 111