Remove Benchmarking Remove Hardware Remove Servers Remove Webinar
article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. Indexing is another powerful technique for query optimization.

Tuning 52
article thumbnail

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements. This not only results in cost savings by minimizing hardware requirements but also has the potential to decrease cloud expenses.

Tuning 52
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

10 tips for migrating from monolith to microservices

Dynatrace

Because monolithic applications combine database, client-side interfaces, and server-side application elements in a single executable, they’re difficult to understand, even for their own administrators. Use SLAs, SLOs, and SLIs as performance benchmarks for newly migrated microservices.

article thumbnail

The Ultimate Guide to MySQL Partitions

Percona

Watch this on-demand webinar from Percona to learn how! KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. Want to ensure a successful MySQL 5.7 What are the Different Types of MySQL Partitions?

article thumbnail

Is It a Read Intensive or a Write Intensive Workload?

Percona

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench.