2020

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Scalegrid

In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer. In this post, we will discuss its most popular alternative – Pgpool-II. Pgpool-II is the swiss army knife of PostgreSQL middleware.

Cache 164

Performance Budgets, Pragmatically

CSS Wizardry

One of the key tools that performance engineers have at their disposal is the Performance Budget: it helps us—or, more importantly, our clients—ensure that any performance-focused work is monitored and maintained after we’ve gone.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Beam-Up Load Balancing: The Portable Next Generation App Experience

DZone

We’ve seen many of the technological advances described in the Star Trek milieu become reality over the last 50 years, from personal communication devices and instant translators to GMOs, medical robots, 3D printing and weapons that stun. But, ah yes, the matter transporter.

How to Estimate Web Performance Impact Before Making Fixes

José M. Pérez

Web Performance is important for user experience and business metrics. Estimating its impact is key to be able to prioritize it, yet it’s difficult to quantify its benefits until the work has been done. We need to break this chicken-and-egg loop.

Stuff The Internet Says On Scalability For February 28th, 2020

High Scalability

Wake up! It's HighScalability time: The Smithsonian has million of pieces of delicious open access content. I ate up this 3D representation of the 1903 Wright Flyer. Do you like this sort of Stuff? Without your support on Patreon this kind of Stuff won't happen.

Infrastructure monitoring for enterprise cloud – 4 key requirements

Dynatrace

Dynatrace news. Anyone moving to the cloud knows that it isn’t just a change from running servers in your data center to running them in someone else’s data center.

How Netflix uses Druid for Real-time Insights to Ensure a High-Quality Experience

The Netflix TechBlog

By Ben Sykes Continue reading on Netflix TechBlog ». apache realtime druid metrics-and-analytics kafka

More Trending

Narrowing the gap between serverless and its state with storage functions

The Morning Paper

Narrowing the gap between serverless and its state with storage functions , Zhang et al., SoCC’19. "Narrowing "Narrowing the gap" was runner-up in the SoCC’19 best paper awards.

Building with Friction

Tim Kadlec

I recently wrote about how important it is to make the right thing easy. The opposite is also true: it’s important to make the wrong things difficult. I did allude to it in that post a little bit, but I thought it was worth calling out explicitly.

Helping Browsers Optimize With The CSS Contain Property

CSS - Tricks

There is a growing number of things that we have to do to help the browser achieve for peak performance. Responsive image syntax has several. For example, needing to tell the browser how large the image will be in our layout with the sizes attribute and how big the images are with w descriptors.

Important Health Checks for your MySQL Master-Slave Servers

Scalegrid

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

How to detect and prevent unexpected growth of the TempDB database

SQL Shack

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred.

Upcoming Software Testing Trends in 2020

DZone

The projections are in! Check out these testing trends! The software development landscape continues to evolve with DevOps and Agile development methods taking over traditional approaches. The advent of these methods has led to the innovation and use of new testing techniques.

Introducing Page Speed Benchmarks – a new resource for the performance community

Speed Curve

Here are some common questions I’m asked when I talk with people about performance: Which metrics should I care about? What types of devices and connections should I test on? Which third parties should I be most concerned about? How fast should I be?

Stuff The Internet Says On Scalability For March 27th, 2020

High Scalability

Hey, it's HighScalability time! Awesome explanation of how to build a PID controller to fly a rocket! BPS.space via Orbital Index ). Do you like this sort of Stuff? Without your support on Patreon this kind of Stuff can't happen. You are that important to the fate of the intelligent world.

Improve user experience with more visibility into CDN-related HTTP errors (Part 1) 

Dynatrace

Dynatrace news. Modern web applications rely heavily on Content Delivery Networks (CDNs) and 3rd-party integrations (for example, web analytics, tag managers, chat bots, A/B testing tools, ad providers, and more).

Tuning 187

Netflix Now Streaming AV1 on Android

The Netflix TechBlog

By Liwei Guo , Vivian Li , Julie Beckley , Venkatesh Selvaraj , and Jeff Watts Today we are excited to announce that Netflix has started streaming AV1 to our Android mobile app. AV1 is a high performance, royalty-free video codec that provides 20% improved compression efficiency over our VP9† encodes. AV1 is made possible by the wide-ranging industry commitment of expertise and intellectual property within the Alliance for Open Media (AOMedia), of which Netflix is a founding member.

Media 159

Please help with STRING_SPLIT improvements

SQL Performance

We're mid-cycle between releases, where we're not yet hearing about any of the features planned for SQL Server vNext. This is probably the best time to press Microsoft for improvements, as long as we can back our requests with legitimate business cases.

Millions of tiny databases

The Morning Paper

Millions of tiny databases , Brooker et al., NSDI’20. This paper is a real joy to read.

In-Browser Performance Linting With Feature Policies

Tim Kadlec

One of the absolute best things you can do to help keep performance in check is to provide a series of visible, well-placed checks and balances in your development workflow to always keep performance front-of-mind. One thing I’m very excited about in this context is feature policies.

Media 83

Get Static

CSS - Tricks

In this piece, Eric Meyer argues that performance is more important than ever right now — especially for websites that contain critical information for the public: If you are in charge of a web site that provides even slightly important information, or important services, it’s time to get static.

COVID-19 Preparedness at ScaleGrid

Scalegrid

Customers & Friends, With the impact of COVID-19 growing around the world, we are taking proactive steps to prepare our infrastructure to continue seamlessly as we navigate this critical time. In an abundance of caution to the rapidly growing climate of the pandemic, we are taking extreme measures to ensure the safety of our employees, customers and partners.

Monitoring activities using sp_WhoIsActive in SQL Server

SQL Shack

In this article, we will talk about sp_WhoIsActive stored procedure and how we can use it to monitor currently running activities in SQL Server.

Principles to Handle Thousands of Connections in Java Using Netty

DZone

C10K problem is a term that stands for ten thousand concurrently handling connections.

Java 207

How to identify NVME drive types and test throughput

n0derunner

Socratic vs. Euclidean Forms of API Documentation

High Scalability

I was emailing a service about their documentation and while their doc was good, about one particularly tricky concept they told me that once you use it for a while, that’s when you’ll understand it. In other words: you’ll only understand it after you understand it.

60 seconds to self-upgrading observability on Google Kubernetes Engine

Dynatrace

Dynatrace news. A decade ago, while working for a large hosting provider, I led a team that was thrown into turmoil over the purchasing of server and storage hardware in preparation for a multi-million dollar super-bowl ad campaign.

Google 174

Ready for changes with Hexagonal Architecture

The Netflix TechBlog

by Damir Svrtan and Sergii Makagon As the production of Netflix Originals grows each year, so does our need to build apps that enable efficiency throughout the entire creative process.

Fun with (columnstore) compression on a very large table – part 3

SQL Performance

In part 1 of this series, I tried out a few ways to compress a 1TB table. While I got decent results in my first attempt, I wanted to see if I could improve the performance in part 2.

Speed 82

Cloudburst: stateful functions-as-a-service

The Morning Paper

Cloudburst: stateful functions-as-a-service , Sreekanti et al., arXiv 2020. Today’s paper choice is a fresh-from-the-arXivs take on serverless computing from the RISELab at Berkeley, addressing some of the limitations outlined in last year’s ‘ Berkeley view on serverless computing.’

Cache 91

When CSS Blocks

Tim Kadlec

The other day I was auditing a site and ran into a pattern that I’ve seen with a few different clients now.

C++ 83

Do This to Improve Image Loading on Your Website

CSS - Tricks

Jen Simmons explains how to improve image loading by simply using width and height attributes. The issue is that there’s a lot of jank when an image is first loaded because an img will naturally have a height of 0 before the image asset has been successfully downloaded by the browser.

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

Scalegrid

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.

Overview of Non-Clustered indexes in SQL Server

SQL Shack

This article gives an introduction of the non-clustered index in SQL Server using examples. Introduction In a previous article Overview of SQL Server Clustered indexes, we explored the requirement of an index and clustered indexes in SQL Server.

Introduction to Benchmarking in Julia

DZone

For the number of years I’ve been programming using Julia, I’ve never really been concerned with performance. Which is to say, I’ve appreciated that other people are interested in performance and have proven that Julia can be as fast as any other performance language out there.

Measuring database scaling & density on Nutanix HCI platform.

n0derunner

What Density can we achieve Vs The theoretical max How does database performance behave as more DBs are consolidated? What impact does running the CVM have on available host resources? tl;dr The cluster was able to achieve ~90% of the theoretical maximum. CVM overhead was 5% for this workload.

Important Health Checks for your MySQL Master-Slave Servers

High Scalability

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.