Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Pagination is beneficial in splitting such collections of information, including products, users, articles, etc., The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Dynatrace

FEBRUARY 28, 2024

Challenges to exploratory data analytics Among the challenges analysts face are multiple heterogeneous data sources, noisy or incomplete data, insufficient causal reasoning (faulty connections between event cause and effect), and untrustworthy AI , according to an article from the Columbia University Data Science Institute.

Analytics 210

Analytics Metrics Media Monitoring 210

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. This article cuts through the complexity to showcase the tangible benefits of DBMS, equipping you with the knowledge to make informed decisions about your data management strategies.

Efficiency 147

Efficiency Storage Database Scalability 147

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. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 52

Speed Java AWS Virtualization 52

Dynatrace

APRIL 11, 2023

Context is king: Converging security and observability to protect a digital-first world – Forbes.com article Many tools also don’t see deep enough inside cloud-native architectures to quickly pinpoint newly discovered zero-days for patching. If something doesn’t change, organizations will be unprepared when the next Log4Shell emerges.

Cloud 186

Cloud DevOps Open Source Retail 186

SQL Shack

DECEMBER 12, 2023

This article explains some of the popular SQL Server monitoring tools and techniques. Database monitoring: a quick reminder Database monitoring is a set of tools and techniques used to create and maintain an application infrastructure that is highly available and performs at high speed.

Monitoring 52

Monitoring Servers Speed Database 52

CSS Wizardry

JULY 23, 2023

Google do strongly encourage you to focus on site speed for better performance in Search, but, if you don’t pass all relevant Core Web Vitals (and the applicable factors from the Page Experience report) they will not push you down the rankings. While Core Web Vitals can help with SEO, there’s so much more to site-speed than that.

Engineering 246

Engineering Google Speed Mobile 246

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. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 40

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Dynatrace

JULY 11, 2023

When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. Spans reveal more about MOVEit vulnerability exploit activity Using spans, for example, we can find evidence of MOVEit vulnerability exploit activity in database queries.

Database 158

Database Government Games Servers 158

Scalegrid

JANUARY 19, 2024

This article dives straight into what triggers a rollback in MongoDB, the risks it carries, and concrete steps you can take to both prevent and recover from one. For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines.

Database 130

Database Network Servers Monitoring 130

Scalegrid

AUGUST 30, 2019

Depending on how it is configured, Redis can act like a database, a cache or a message broker. It’s important to note that Redis is a NoSQL database system. In Redis, we have strings, lists, sets, sorted sets, and hashes, which we are going to cover in this article. 8 ranked database on DB-Engines with a score of 144.08.

Cache 232

Cache Ecommerce Social Media Database 232

MachMetrics

DECEMBER 14, 2019

Similar to our article Average Page Load Times for 2018 , we’ll go over the averages for metrics and help you determine if your site is faster or slower than average. As you know, there are many metrics that determine a website’s page speed, and we can’t look at just one of them to determine how performant our site is.

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

APRIL 24, 2023

I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them. This post is about PostgreSQL, but most of the problems also apply to other database systems. The total database size grows to a multiple of the actual data.

Tuning 127

Tuning Cache Storage Database 127

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. In this article, I will first explain an overview of indexes in MySQL and cover the MySQL CREATE INDEX before diving into showing what functional indexes are and how they work. Need help managing complex database environments?

Virtualization 78

Virtualization Speed Database Efficiency 78

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Highly Scalable

AUGUST 14, 2012

In this article I describe a technique we used to speed up a Pig build from 9 hours to 1 hour 30 minutes using 6 Jenkins nodes. This technique is generic and can be considered as a general way to speed up maven or ant builds on Jenkins CI server or other CI systems. Solution Overview. " db = MySQLdb.connect(.)

Speed 100

Speed Testing Java Lambda 100

Scalegrid

MARCH 14, 2024

This article will explore hybrid cloud benefits and steps to craft a plan that aligns with your unique business challenges. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions? A hybrid cloud strategy could be your answer. Elevate your cloud strategy today with ScaleGrid!

Strategy 130

Strategy Cloud Artificial Intelligence Infrastructure 130

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Smashing Magazine

MAY 5, 2021

Here’s another article about reducing JavaScript dependencies and the bundle size sent to the client. This article is about a couple of things that Bookaway faced and we (as a company in the traveling industry) managed to optimize our pages, so that the HTML we send is smaller. Why Is Speed Improvement Necessary To Our SEO Efforts?

Google 111

Google Architecture Servers Speed 111

Percona

MARCH 24, 2023

This article discusses the need for using binlog compression and the potential issues it may cause. To start replication on the replica node, simply execute START SLAVE; Of course, this method is not for everyone, as a primary restart is not the recommended approach since it causes downtime for the entire database cluster. Sure thing!

Open Source 86

Open Source Database C++ Servers 86

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. First, some stage-setting for this blog article. The popularity of MongoDB MongoDB has emerged as a popular database platform. It ranks No.

Open Source 76

Open Source Database Scalability Software 76

Dynatrace

NOVEMBER 23, 2020

While speeding up development processes and reducing complexity does make the lives of Kubernetes operators easier, the inherent abstraction and automation can lead to new types of errors that are difficult to find, troubleshoot, and prevent. Logs are easy to produce and provide data in plain-text, structured (JSON, XML), or binary format.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

CSS Wizardry

JANUARY 31, 2019

Where bandwidth deals with capacity, latency is more about speed of transfer 2. This is the column we want to focus on for this article. If I wanted to speed up the delivery of these images, I am unlikely to get any real gains through optimising them further. Latency is defined as…. This lower number is effectively your latency.

Latency 133

Latency Network Speed Servers 133

Smashing Magazine

SEPTEMBER 28, 2022

Server caches help lower the latency between a Frontend and Backend; since key-value databases are faster than traditional relational SQL databases, it will significantly increase an API’s response time. In a common WebSocket architecture, the Front-end application will connect to a WebSocket API, an event bus, or a database.

Cache 127

Cache Performance Servers Social Media 127

Jos

JUNE 2, 2018

At the same time, they open a door to lots of concepts that might be overwhelming: PRPL, RAIL, Paint Timing API, TTI, HTTP/2, Speed Index, Priority Hints and more … Why Performance doesn’t get Prioritized Web performance at organizations is a real challenge. Ideally, shoot for 30% speed improvements. A screenshot of Lighthouse 3.0,

Performance 237

Performance Speed Google Media 237

MachMetrics

OCTOBER 12, 2020

Netlify has a great article going over a few of their favorites. Everyone should just use a static site generator and experience incredible speed increases? Dynamic sites, on the other hand, are constantly making round trips to a database to update the content that a visitor is served. However, the results speak for themselves.

Website 52

Website Speed Traffic Database 52

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. 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. Test Environment. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. I went through the case details for one of our clients last week, leading me to pen down this article. A Query Execution Plan is the way a database chooses to run a specific query.

Efficiency 105

Efficiency Database Open Source Performance 105

MachMetrics

DECEMBER 27, 2019

While it’s important to check various speed metrics , the Web Almanac uses data from the Chome UX Report which focuses on how Chrome users actually experience the web. As we mentioned in our article Average Page Load Times for 2020 , mobile page speed is a huge deal going forward. First Contentful Paint. Page Weight.

Performance 52

Performance Speed Website Mobile 52

Speed Curve

FEBRUARY 5, 2024

Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. db = Duration of the request processing spent querying the database. db = Duration of the request processing spent querying the database. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

Smashing Magazine

DECEMBER 23, 2020

It doesn’t come as a surprise, considering the benefits of higher conversion rates, customer engagement, decreased page loading speed, and lower costs on development and overhead. Otherwise, the user experience could be as frustrating as Ankita Masand’s ordeal with ordering a cake as she describes in her article about the pain points of PWAs.

Cache 125

Cache Internet Internet Google 125