article thumbnail

Poor Disk Performance

Brendan Gregg

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Linux 4.15.0-66-generic

article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

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

C++ 105
Insiders

Sign Up for our Newsletter

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

article thumbnail

How to analyze PostgreSQL benchmark performance with HammerDB

HammerDB

We will provide a brief summary of the article and its conclusions, and demonstrate a better way to analyze PostgreSQL performance with HammerDB itself. To investigate further, we will analyze PostgreSQL performance using HammerDB built-in tools for a deeper insight into the workload. and start the build running.

article thumbnail

3 Modern Tools For Automated Testing Of Your Web Applications

Testsigma

Owing to how we consume content and perform our day-to-day functions now, businesses are optimizing web apps and how! To ensure our web app performs as intended across various devices and browsers — we have to test our web app. Data-driven testing: We can perform data-driven testing by separating data from the test commands.

Testing 102
article thumbnail

Comparisons of Proxies for MySQL

Percona

MySQL router, after the 2048 connection, could not serve anything more. HAProxy performs better with a low number of connections, while ProxySQL performs better when a high number of connections is in place. That allows it to go a bit further. MySQL Router is the one that has the higher latency no matter what.

Games 126
article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

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. This results in improved performance. SHMMAX / SHMALL. Until version 9.2, PostgreSQL switched to POSIX shared memory.

Tuning 59
article thumbnail

Poor Disk Performance

Brendan Gregg

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Hit Ctrl-C to end.