Percona

APRIL 24, 2023

Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them.

Tuning 128

Tuning Cache Storage Database 128

Dynatrace

JANUARY 14, 2022

Tuning thousands of parameters has become an impossible task to achieve via a manual and time-consuming approach. JVM, databases, middleware, operating system, cloud instances, etc) by also taking advantage of Dynatrace full-stack observability. SREcon21 – Automating Performance Tuning with Machine Learning.

Latency 204

Latency Tuning Efficiency AWS 204

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic. Modifying this setting does affect performance.

Java 130

Java Network Servers Database 130

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

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 57

Tuning Database Servers Processing 57

Dynatrace

FEBRUARY 16, 2023

As teams try to gain insight into this data deluge, they have to balance the need for speed, data fidelity, and scale with capacity constraints and cost. This unified approach enables Grail to vault past the limitations of traditional databases. And without the encumbrances of traditional databases, Grail performs fast. “In

Analytics 186

Analytics Innovation Metrics Database 186

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. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

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

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

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. This fully automated scaling and tuning will enable a serverless-like experience in our Operators and Everest.

Cloud 83

Cloud Open Source Strategy Best Practices 83

Dynatrace

FEBRUARY 10, 2022

In today’s world, the speed of innovation is key to business success. 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. Dynatrace news. Unfortunately, they also introduce risk. How to get started.

Traffic 234

Traffic Benchmarking Innovation Java 234

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

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Database monitoring Once more, under Applications & Microservices, we’ll also find Databases.

Metrics 171

Metrics Monitoring Database Network 171

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. Flexible location : Data files can reside within the MySQL data directory or an independent location, enabling finer control over storage management and performance tuning.

Storage 91

Storage Engineering Database Hardware 91

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

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

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

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. The good news is that there are hacks that can speed up the entire recovery process, although they all have their own quirky limitations. So there you have it.

Games 92

Games Open Source Tuning Speed 92

Dynatrace

DECEMBER 8, 2020

In our increasingly digital world, the speed of innovation is key to business success. As a result, e xisting application security approaches can’t keep up with this speed and vari ability of modern development processes. . Stay tuned – this is only the start. Dynatrace news.

Cloud 290

Cloud Open Source Internet Internet 290

Percona

OCTOBER 12, 2023

The idea behind this is to speed up cluster resources such as garbage collection, reduce image transfer over the network, and accelerate the application launch. Manual flame graphs collection Although the tool is excellent and automatically provides flame graphs, we don’t have much control over tuning the selected profiler.

Code 114

Code Tuning C++ Benchmarking 114

Scalegrid

JANUARY 8, 2019

Managing The Execution Speed of The Slaves. With these settings, we will be able to get better parallelization and speed on the slave, but if there are too many parallel threads, the overhead involved in coordinating between the threads will also increase and can unfortunately offset the benefits. Stay tuned!!

Availability 113

Availability Tuning Speed Network 113

Dynatrace

NOVEMBER 10, 2022

Containers are portable, self-contained operating environments that include applications and the dependencies they need to run, such as databases, middleware, and frameworks. Software-defined environments minimize the need for manual controls and lend themselves well to the speed, precision, and observability benefits cloud platforms enable.

Cloud 162

Cloud Architecture Serverless Infrastructure 162

Dynatrace

NOVEMBER 13, 2020

With Dynatrace, you get end-to-end visibility into each user action, from the user interaction triggered on the mobile device, through the maze of cloud and on-premises services, down to the database statement. To get you up to speed quickly and to test Dynatrace easily, we provide a small Flutter demo app.

Code 173

Code Mobile Monitoring Infrastructure 173

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

Software Architecture

AUGUST 24, 2017

Consistency The topic and concept of consistency is very important when you work with a distributed database like Cassandra. When you’re working with a database which runs on only one server, consistency is a non-issue. Read CL controls how many replica nodes must send their most recent copy of partition to the coordinator.

Software Architecture 100

Software Architecture Database Tuning Servers 100

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

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. In the recent MySQL 8.0.16 So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. linux-glibc2.12-x86_64/data

Testing 48

Testing Tuning Latency Storage 48

Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. citus_columnar | 11.1-1

C++ 81

C++ Database Storage Testing 81

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. The governor "powersave" may decide which speed to use within this range. The governor "performance" may decide which speed to use within this range. hardware limits: 1000 MHz - 4.00

Benchmarking 63

Benchmarking Performance Hardware C++ 63

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

VoltDB

JUNE 19, 2017

While current network speeds may be enough to meet the latency requirements of 4G applications, 5G will necessitate a change, if only because the continental US is ~60ms wide, meaning that a datacenter on one coast communicating with another datacenter on the opposite coast will be too slow for 5G. These have to communicate with each other.

Latency 40

Latency Retail Virtualization Hardware 40

VoltDB

JUNE 19, 2017

While current network speeds may be enough to meet the latency requirements of 4G applications, 5G will necessitate a change, if only because the continental US is ~60ms wide, meaning that a datacenter on one coast communicating with another datacenter on the opposite coast will be too slow for 5G. These have to communicate with each other.

Latency 40

Latency Retail Virtualization Hardware 40

MachMetrics

SEPTEMBER 5, 2019

Are you building an e-commerce store with thousands of products and a huge database? . When a user comes to a website that has been fine tuned, they aren’t having their time wasted with long load times, and their devices aren’t having their batteries and resources drained. Look for situations that are mutually beneficial.

Website 48

Website Performance Speed Design 48

Official Blog - World Web Technology

FEBRUARY 23, 2023

Stay tuned! It is to find and add websites to their databases. Go for lazy loading for images to improve the page speed. Ensure that you monitor core web vitals and page speed insights to evaluate your website performance and speed. Now it is time to add one more E to it.

Google 52

Google Traffic Social Media Website 52

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

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This next example query uses the same database and index as before. A final example.

Servers 95

Servers Tuning Architecture Processing 95

Particular Software

APRIL 9, 2018

Going at this speed, the Message Processor could handle 3 passengers per minute. First, we could bring in a mechanic to try and tune the attraction back to its original speed. But that may not be enough if, for example, the constraint is an external resource like a database or third-party web service. That's a problem.

Systems 40

Systems Infrastructure Monitoring Tuning 40