article thumbnail

Best Practices for a Seamless MongoDB Upgrade

Percona

Powerful change streams and support for data definition language operations. Improved performance : MongoDB continually fine-tunes its database engine, resulting in faster query execution and reduced latency. You should also review your hardware resources, how you use MongoDB, and any custom configurations. In MongoDB 6.x:

article thumbnail

Impact of Querying Table Information From information_schema

Percona

The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 98
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

Reinventing Performance Testing: New Architectures

Alex Podelko

System’s configuration is not given anymore and often can’t be easily mapped to hardware. As already mentioned, performance testing is rather a performance engineering process (with tuning, optimization, troubleshooting and fixing multi-user issues) eventually bringing the system to the proper state rather than just testing.

article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

There is a cool blog post from Vadim covering big data sets in MyRocks: MyRocks Use Case: Big Dataset Query tuning: It is common to find applications that at the beginning perform very well, but as data grows the performance starts to decrease. It was developed for optimizing data storage and access for big data sets.

article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. Be aware of differing definitions. The definition of the SHMMAX/SHMALL parameters is slightly different between Linux and MacOS X. SHMMAX / SHMALL. Until version 9.2, Summing up.

Tuning 54
article thumbnail

Generative AI in the Enterprise

O'Reilly

Even with cloud-based foundation models like GPT-4, which eliminate the need to develop your own model or provide your own infrastructure, fine-tuning a model for any particular use case is still a major undertaking. That pricing won’t be sustainable, particularly as hardware shortages drive up the cost of building infrastructure.

article thumbnail

MySQL 8: Load Fine Tuning With Resource Groups

Percona

assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth. Then we need to see IF implementing the tuning will work or not. It is possible to do more tuning in the case that ETL is too compromised.

Tuning 44