Remove Benchmarking Remove Best Practices Remove Cache Remove Virtualization
article thumbnail

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

The VictoriaMetrics team has also published some best practices , which can also be referred to while planning for resources for setting up PMM2. Virtual Memory utilization was averaging 48 GB of RAM. Virtual Memory utilization was averaging 48 GB of RAM. We have tested PMM version 2.33.0

article thumbnail

Understanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation

Percona

By understanding these challenges and following best practices, you can make the most of triggers while minimizing potential drawbacks. Testing and Benchmarking : Thoroughly test triggers in a staging environment to evaluate their impact on performance. Carefully design transactions to avoid unnecessary locking and contention.

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

The Ultimate Guide to Database High Availability

Percona

High availability works through a combination of the following: No single point of failure (SPOF) : You must eliminate any single point of failure in the database environment, including physical or virtual hardware the database system relies on that would cause it to fail. Please note that these are presented as general best practices.

article thumbnail

Front-End Performance Checklist 2021

Smashing Magazine

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Time of Last Access The time of last access is a caching ​​ algorithm ​​ that enables ​​ cache ​​ entries to be ordered by their ​​ access times.

Servers 40