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

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So now lets see what we get in performance mode, an almost 32% improvement (and 53% higher than the published benchmarks). ./bin/pgbench

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Alex Podelko

APRIL 18, 2021

Evergreen Continuous Integration: Why We Reinvented The Wheel , blog post from July 27, 2016, explains why and how it was done. Blog post from April 30, 2019, Reducing variability in performance tests on EC2: Setup and Key Results , address that specific issue. First, to set up the scene, MongoDB has its own Continuous Integration.

Performance Testing 182

Performance Testing Testing Performance Education 182

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. In this blog post, we will explore the benefits of using pgpool-II for PostgreSQL.

Cache 114

Cache Open Source Benchmarking Database 114

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

KeyCDN

OCTOBER 2, 2018

Reading and following the right web development blogs makes it much easier to get a solid education. That’s why in this post, we’ve compiled a list of the top web development blogs that will help you find your footing and acquire essential skills in modern web dev. Visit website 3. Visit website 5. Visit website 9.

Development 75

Development Website Design Code 75

Dynatrace

FEBRUARY 10, 2022

This also means we do not rely on vulnerability databases but are able to identify and block such attacks automatically even if they are exploiting unknown weaknesses. A perfect OWASP benchmark score for injection attacks – 100% accuracy and zero false positives – impressively proves the precision of our approach.

Traffic 239

Traffic Benchmarking Innovation Java 239

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. shared_buffer.

Tuning 56

Tuning Database Performance Benchmarking 56

Percona

DECEMBER 20, 2023

Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. Unfortunately, the performance in benchmarks is almost the same as for 4KB pages. Setup I recommend starting with 2MB huge pages because it’s trivial to set up.

C++ 98

C++ Virtualization Benchmarking Database 98

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. AI-assistance: Use AI to detect anomalies and benchmark your system. appeared first on Dynatrace blog. Dynatrace news. It’s not hype, it’s the way forward.

Infrastructure 209

Infrastructure Monitoring Virtualization Serverless 209

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. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 104

Performance Monitoring Traffic Database 104

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 That’s a heritage of the LAMP model when the same server would host both the database and the web server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 136

Tuning Cache Servers Benchmarking 136

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 99

Monitoring Scalability Cache Database 99

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 125

Performance Hardware Tuning Storage 125

Dynatrace

APRIL 8, 2021

In a previous blog post , we covered how Lambda functions work under the hood. When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. See our previous blog post for more information on that.). Extending existing enterprise stacks.

Lambda 229

Lambda AWS Serverless Monitoring 229

Dynatrace

SEPTEMBER 23, 2021

Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. Use scripts to configure hosts properly based on the CIS benchmarks. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery.

Open Source 258

Open Source Benchmarking Best Practices Network 258

Speed Curve

FEBRUARY 5, 2024

Looking at the industry benchmarks for US retailers , four well-known sites have backend times that are approaching – or well beyond – that threshold. Pagespeed Benchmarks - US Retail - LCP When you examine a waterfall, it's pretty obvious that TTFB is the long pole in the tent, pushing out render times for the page.

Servers 57

Servers Cache Retail Benchmarking 57

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. While many AWS users default to their managed database solution, Amazon RDS, there are alternatives available that can improve your MySQL performance on AWS through advanced customization options and unlimited EC2 instance type support.

AWS 183

AWS Latency Performance Benchmarking 183

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 8.0

Cache 102

Cache Hardware Servers Benchmarking 102

Dynatrace

APRIL 8, 2021

In a previous blog post , we covered how Lambda functions work under the hood. When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. See our previous blog post for more information on that.). Extending existing enterprise stacks.

Lambda 191

Lambda AWS Serverless Monitoring 191

Percona

JANUARY 19, 2023

16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. 1 mysql mysql 704M Dec 30 02:28 employees.ibd -rw-r --.

Open Source 88

Open Source Storage Database Big Data 88

Percona

APRIL 12, 2023

We’re equally convinced on both counts, but in this blog article, we’re focusing on why MongoDB is not open source. This blog article traces key developments that coincided with MongoDB’s move away from open source software, and it examines how SSPL influence might have lured others in the same direction.

Open Source 82

Open Source Programming Database Servers 82

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. html [unroll the loop]: /blog/2014-04-26/the-noploop-cpu-benchmark.html A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 126

Speed Java AWS Virtualization 126

Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction.

Cache 86

Cache Benchmarking Servers Design 86

Percona

JULY 19, 2023

In this blog post, you’ll learn how to set up a build environment for compiling your own MySQL plugin to be loaded into MySQL as a function. The above ULID plugin came as an idea from a post by Shopify , specifically #6, that mentioned moving to ULID over UUID for better sequential INSERTs in their MySQL databases.

C++ 81

C++ Servers Benchmarking Best Practices 81

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 79

Availability Hardware Open Source Database 79

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

Percona

OCTOBER 12, 2023

In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments. A simple sysbench benchmark on MySQL shows an overhead between six and 10 percent on CPU-bound systems when running perf with the default sampling frequency of 4000 Hz.

Code 110

Code Tuning C++ Benchmarking 110

MachMetrics

DECEMBER 14, 2019

It is typically reduced via server-side optimizations, such as enabling caching and database indexes. However, we really want to strive to be under the benchmarks that Google sets as a best practice. Even better if you’re under Google’s best practice benchmark. appeared first on MachMetrics Speed Blog.

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. What is a Trigger in MySQL?

Cache 61

Cache Database Games Healthcare 61

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 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. Check out this blog to learn how to avoid disaster! Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

The Netflix TechBlog

OCTOBER 19, 2020

In our previous blog post we introduced Edgar, our troubleshooting tool for streaming sessions. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

HammerDB

JULY 6, 2023

In this example, we will use the CLI to run TPROC-C on a MariaDB database to illustrate the concepts. This way is typically the fastest way to determine the maximum throughput of a database with minimal configuration, and over time has been proven to show the same performance ratios between systems as a well configured fixed throughput setup.

Virtualization 57

Virtualization C++ Database Code 57

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. html [unroll the loop]: /blog/2014-04-26/the-noploop-cpu-benchmark.html [unused]: [link] [unused2]: [link] These can be invisible to top(8).

Speed 40

Speed Java AWS Virtualization 40