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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 105

Performance Monitoring Traffic Database 105

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB).

Servers 57

Servers Cache Retail Benchmarking 57

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. This earlier functionality has the advantage that there are no intermediate staging files required, and data is inserted into the database with multi-row inserts as soon as it is created.

Servers 62

Servers C++ Benchmarking Virtualization 62

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. Among the different components of modern software solutions, the database is one of the most critical. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. When it comes to performance, you shouldn’t be stingy. 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.

Cache 126

Cache Performance Servers Social Media 126

Percona

AUGUST 31, 2018

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. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters.

Tuning 56

Tuning Database Performance Benchmarking 56

The Morning Paper

MARCH 10, 2020

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook , Cao et al., Or in the case of key-value stores, what you benchmark. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

Dynatrace

NOVEMBER 2, 2020

IT infrastructure is the heart of your digital business and connects every area – physical and virtual servers, storage, databases, networks, cloud services. This shift requires infrastructure monitoring to ensure all your components work together across applications, operating systems, storage, servers, virtualization, and more.

Infrastructure 199

Infrastructure Monitoring Virtualization Serverless 199

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 100

Monitoring Scalability Cache Database 100

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 5.7

Cache 103

Cache Hardware Servers Benchmarking 103

Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information.

C++ 99

C++ Virtualization Benchmarking Database 99

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

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again.

Cache 87

Cache Benchmarking Servers Design 87

Brendan Gregg

MAY 22, 2021

- What observability does that database have? Wait, aren't all performance tools observability tools? For example, benchmarks. When I was a performance consultant I'd show up to random companies who wanted me to fix their computer performance issues. Means: Let me look at the system without changing it.)

Benchmarking 117

Benchmarking Metrics Speed Database 117

Rigor

JUNE 14, 2019

It’s true that what might be considered the “most important” or “best” web performance metrics can vary by industry. These six metrics were not chosen at random – they work together to give you a snapshot of your site’s performance and overall user experience so you can set a baseline and improve speed and usability.

Metrics 101

Metrics Performance Speed Ecommerce 101

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. The various types are: General purpose – Balanced CPU-to-memory ratio, small to medium databases. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers.

Azure 76

Azure Benchmarking Storage Virtualization 76

Scalegrid

OCTOBER 31, 2019

In these blogs, we dove deep into how the frameworks work, their setup requirements, pros and cons, and how they performed in standby server tests, primary server tests and network isolation tests (split brain scenario) to help you determine the best framework to improve the uptime for your PostgreSQL-powered applications.

Availability 187

Availability Azure AWS DevOps 187

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. include/server -I/opt/postgresql-14.1/include/internal

Metrics 62

Metrics Benchmarking C++ Database 62

n0derunner

OCTOBER 4, 2019

HammerDB is a great tool for running Database benchmarks. However it is very easy to create an artificial bottleneck which will give a very poor benchmark result. When setting up HammerDB to run against even a moderate modern server, it is important to avoid displaying the client transaction outputs in the HammerDB UI.

Benchmarking 75

Benchmarking Database Servers Performance Testing 75

Percona

JANUARY 19, 2023

While the technologies have evolved and matured enough, there are still some people thinking that MySQL is only for small projects or that it can’t perform well with large tables. With disks being faster nowadays and CPU and memory resources being cheaper, we could easily say MySQL can handle TBs of data with good performance.

Open Source 89

Open Source Storage Database Big Data 89

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself.

Open Source 83

Open Source Programming Database Servers 83

High Scalability

AUGUST 24, 2021

As Kinsta’s DevOps Engineer, you will be instrumental in making sure that our infrastructure is always on the bleeding edge of technology, remaining stable and high-performing at all times. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

High Scalability

OCTOBER 27, 2021

As Kinsta’s DevOps Engineer, you will be instrumental in making sure that our infrastructure is always on the bleeding edge of technology, remaining stable and high-performing at all times. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

As Kinsta’s DevOps Engineer, you will be instrumental in making sure that our infrastructure is always on the bleeding edge of technology, remaining stable and high-performing at all times. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

As Kinsta’s DevOps Engineer, you will be instrumental in making sure that our infrastructure is always on the bleeding edge of technology, remaining stable and high-performing at all times. Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. Get started for free!

Education 100

Education DevOps Infrastructure Benchmarking 100

HammerDB

APRIL 27, 2021

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. In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. Selecting a database. Select a database.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

HammerDB

DECEMBER 20, 2018

The reason for reporting both TPM and NOPM performance metrics is for both historical and performance reasons. However as other databases were added they all record TPM in a slightly different way so it wasn’t possible to compare TPM between different database for example Oracle and SQL Server. There are 2 reasons.

Metrics 40

Metrics Performance Benchmarking Database 40

HammerDB

DECEMBER 5, 2020

A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. This was both expensive and time consuming to configure.

C++ 40

C++ Benchmarking Virtualization Open Source 40

n0derunner

JUNE 14, 2022

The SQLServer database on Nutanix delivered almost 2X the transaction rate as the same workload running on Amazon RDS. It turns out that migrating an … The post Comparing RDS and Nutanix Cluster performance with HammerDB appeared first on n0derunner.

Performance 52

Performance Speed Database Benchmarking 52

MachMetrics

DECEMBER 14, 2019

With another year winding down, it’s time for us to take stock of how our site performance compares to the average page load times for 2020. 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

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs.

Database 130

Database Cloud Hardware Storage 130

n0derunner

MAY 27, 2022

The performance compares very well with hosted cloud database instances using the same class of processor (db.r5.4xlarge in the figure below). The metrics below are for SQL insert transactions not the … The post Single threaded DB performance on Nutanix HCI appeared first on n0derunner.

Performance 52

Performance Metrics Database Cloud 52

HammerDB

NOVEMBER 30, 2022

Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Why Tcl is 700% faster than Python for database benchmarking. Running this script returns output as follows using the Python loop to drive HammerDB.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Brendan Gregg

MAY 22, 2021

(Means: What tools exist that only read state?) - What observability does that database have? Wait, aren't all performance tools observability tools? For example, benchmarks. When I was a performance consultant I'd show up to random companies who wanted me to fix their computer performance issues.

Benchmarking 40

Benchmarking Metrics Speed Database 40

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98