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

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. These include popular technologies such as web servers and web applications, along with advanced solutions like distributed data stores and containerized microservices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 102

Performance Monitoring Traffic Database 102

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 123

Performance Hardware Tuning Storage 123

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. This server is spending about a third of its CPU cycles just checking the time! What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 52

Speed Java AWS Virtualization 52

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Why HammerDB was developed. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Brendan Gregg

MAY 22, 2021

- What observability does that database have? For example, benchmarks. As an analogy, a car's dashboard is a collection of observability tools that let you understand how the car is operating (speed, rpm, temperature). If they trusted me with a login to their production servers, I could help them a lot quicker.

Benchmarking 117

Benchmarking Metrics Speed Database 117

Particular Software

SEPTEMBER 20, 2021

Sometimes developers only care about speed. Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. But that’s just a micro-benchmark and doesn’t tell you the whole story.

Benchmarking 97

Benchmarking Latency Servers Systems 97

MachMetrics

DECEMBER 14, 2019

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. By analyzing the data from Backlinko.com and their Page Speed Stats article, we’ll look to answer these questions: What size should be a website be?

Best Practices 105

Best Practices Speed Mobile Google 105

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

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. This server is spending about a third of its CPU cycles just checking the time! What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 40

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52

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

Percona

JANUARY 24, 2023

There will be a considerable gain if we combine this with other sets of great improvements in WAL archiving in PostgreSQL 15, as discussed in previous posts New WAL Archive Module/Library in PostgreSQL 15 and Speed Up of the WAL Archiving in PostgreSQL 15. Such “torn pages” are corruptions from the database point of view.

Database 114

Database Benchmarking Open Source Latency 114

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. On your first try, you can use it as a benchmark for optimizations later. Client Side Rendering, Server Side Rendering And Jamstack. On design systems, UX, web performance and CSS/JS.

Cache 125

Cache Performance Servers Social Media 125

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. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

HammerDB

APRIL 27, 2021

As the workflow in the CLI and GUI are the same we will show equivalent commands side by side to help you quickly get up to speed on using the CLI in both interactive and scripted scenarios. One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Speed Curve

SEPTEMBER 4, 2013

Why speed matters, examples of the impact saving a few seconds of load time has had on revenue and engagement. Bandwidth, latency and it's fundamental impact on the speed of the web. An overview of tools for measuring performance, uptime monitoring, real user monitoring and performance benchmarking. Muti-device challenges.

Speed 40

Speed Benchmarking Latency Mobile 40

KeyCDN

AUGUST 29, 2019

Running speed tests with tools like Google PageSpeed Insights , WebPageTest , or KeyCDN’s Website Speed Test are always a good way to help gauge your website’s performance. Why Care About Page Speed? There are a multitude of reasons why you should care about page speed.

Google 103

Google Cache Speed Analytics 103

Rigor

JUNE 14, 2019

Whether you’re new to web performance or you’re an expert working with the business side of your organization to gain buy-in on performance culture, we suggest starting with six specific metrics: Time to Interactive , First Contentful Paint , Visually Complete , Speed Index , Time to First Byte , and Total Content Size. Speed Index.

Metrics 101

Metrics Performance Speed Ecommerce 101

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Percona

AUGUST 5, 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. Each partition holds data that falls within a specific range, optimizing data handling and query speed. So, What is MySQL Partitioning? Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. Both of these Intel processors are special bespoke models that are not in the Intel ARK database.

Azure 42

Azure Virtualization Storage Benchmarking 42

Brendan Gregg

MAY 22, 2021

Means: What tools exist that only read state?) - What observability does that database have? For example, benchmarks. As an analogy, a car's dashboard is a collection of observability tools that let you understand how the car is operating (speed, rpm, temperature). Wait, aren't all performance tools observability tools?

Benchmarking 40

Benchmarking Metrics Speed Database 40

n0derunner

JUNE 14, 2022

tl;dr In a recent experiment using Amazon RDS instance and a VM running in an on-prem Nutanix cluster, both using Skylake class processors with similar clock speeds and vCPU count. The SQLServer database on Nutanix delivered almost 2X the transaction rate as the same workload running on Amazon RDS.

Performance 52

Performance Speed Database Benchmarking 52

Alex Russell

MARCH 6, 2021

Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. Recall that single-core performance most directly translates into speed on the web. Today, either method returns a similar answer. Tap for a larger version. How bad is it?

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Is it expensive JavaScript, slow web font delivery, heavy images, or sluggish rendering? Large preview ).

Performance 145

Performance Cache Network Metrics 145

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. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

Alex Russell

MAY 9, 2022

Teams achieving this level of discipline about performance begin to eliminate variance from their lab data by running tests in "less noisy" environments than somewhere like a developer's laptop, a shared server, or a VM with underlying system variance. When the speed of a device dominates, wealth correlates heavily with performance.

Performance 86

Performance Latency Metrics Engineering 86

High Scalability

NOVEMBER 25, 2019

To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. Application Servers. Apache FTP server. Native desktop and server hosted clients that allow both interactive as well as hybrid sync access to the entire namespace.

Architecture 52

Architecture Cache Azure Storage 52