Brendan Gregg

APRIL 30, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 43

DevOps Network Best Practices Programming 43

Brendan Gregg

APRIL 29, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 40

DevOps Network Best Practices Programming 40

High Scalability

JUNE 22, 2018

using them to respond to storage events on s3 or database events or auth events is super easy and powerful. Three major roadmap updates in 29 days with serious spec changes, and it got worse from there. Xtracerx : for me the biggest value to serverless functions is how nicely they tie in to the ecosystem of a cloud provider.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

Percona

JULY 2, 2023

This blog was originally written in September 2018 and was updated in June 2023. The size of the database and your database environment—if it is on colo or cloud—matters. In this post, we cover the methods used to achieve an enterprise-grade backup strategy for the PostgreSQL cluster.

Strategy 52

Strategy Database Storage Open Source 52

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. 2018-05-31

Database 40

Database Analytics Blockchain Healthcare 40

n0derunner

DECEMBER 17, 2018

How to reduce database restore time by 50%. During.Next 2018 in London, Nutanix announced performance improvements in the core-datapath said to give up to 2X performance improvements. I am using X-Ray to simulate a 1TB data restore into an existing database. Here’s a real-world example of that improvement in practice.

Performance 64

Performance Benchmarking Storage Network 64

Percona Community

JUNE 28, 2018

was released GA on 2018-05-25). temporal data processing, Oracle compatibility features, and purpose-built storage engines. Even if I am excited about MyRocks and curious on Spider, I am also very interested in less flashy but still very important changes that make running the database in production easier. MariaDB 10.3

Storage 52

Storage Database Servers Engineering 52

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. General Purpose provides up to 8 TB of high-performance Azure Blob storage, while Business Critical provides up to 4 TB of super-fast local SSD storage. Memory is allocated at approximately 5.1 GB per vCore. With only having 5.1

Azure 63

Azure Performance Storage Latency 63

Dynatrace

OCTOBER 15, 2021

The data is incredibly plentiful and difficult to store over long periods due to capacity limitations — a reason why private and public cloud storage services have been a boon to DevOps teams. Cloud databases excel at storing large volumes of information for later reference, and this data often has business value or privacy restrictions.

Open Source 224

Open Source Metrics Cloud Transportation 224

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 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. .

Best Practices 40

Best Practices Scalability Performance C++ 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. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. in the directory storage/innobase/ut the following section has UT_RELAX_CPU defined to call the PAUSE instruction on x86.

Testing 48

Testing Tuning Latency Storage 48

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Oracle Log File Sync.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Abhishek Tiwari

JANUARY 6, 2018

Telepresence is an open source tool that lets you debug a service locally while keeping the connection with its dependency services hosted in a remote Kubernetes cluster and remote cloud resources like a database. The backup files are stored in an object storage service (e.g. Personally, I think Telepresence has a lot potential.

Open Source 111

Open Source DevOps Storage Engineering 111

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications. Is this a problem ?

Tuning 44

Tuning Cache Database Storage 44

The Morning Paper

OCTOBER 22, 2019

This 2018 paper reports on the findings from interviews with 30 professional data analysts to see what they get up to in practice. Only 18 of the 30 participants mentioned using databases and related tools (that statement caused a significant recalibration in my mind, I would have guessed much closer to 100%!). VAST’18.

Programming 40

Programming Software Engineering Database Analytics 40

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. After years of standards discussion and the first delivered to other platforms in 2018, iOS 14.5 April 2018 , but not usable until several releases later). Where Chrome Has Lagged. finally shipped Audio Worklets this week. Pointer Lock. Media Recorder.

Media 145

Media Games Education Engineering 145

Smashing Magazine

JANUARY 15, 2019

The Mozilla Internet Health Report 2018 states that — especially as the Internet expands into new territory — “sustainability should be a bigger priority.” The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral.

Website Performance 73

Website Performance Website Energy Performance 73

Percona

JANUARY 17, 2019

now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). SSD) we can’t utilize the full potential of IOPS with just one thread.

Cache 46

Cache C++ AWS Airlines 46

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. India became a 4G-centric market sometime in 2018. The Moto G4 , for example. 2] Getting accurate global information that isn't artificially reduced to averages remains an ongoing challenge.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

JANUARY 7, 2019

Depending on how much dynamic data you have, you might be able to "outsource" some part of the content to a static site generator , pushing it to a CDN and serving a static version from it, thus avoiding database requests. In 2018, the Alliance of Open Media has released a new promising video format called AV1. Same with Etag.

Performance 104

Performance Cache Network Metrics 104

Smashing Magazine

JANUARY 6, 2020

Globally in 2018–2019, according to the IDC, 87% of all shipped mobile phones are Android devices. Depending on how much dynamic data you have, you might be able to "outsource" some part of the content to a static site generator , pushing it to a CDN and serving a static version from it, thus avoiding database requests.

Performance 145

Performance Cache Network Metrics 145