DZone

JANUARY 23, 2021

According to a performance test conducted by Arnaldo Carvalho de Melo, a senior software engineer at Red Hat, the process traced using strace ran 173 times slower, which is disastrous for a production environment. If you need to dynamically trace Linux process system calls, you might first consider strace.

Systems 166

Systems Performance Software Engineering Performance Testing 166

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Developers are often strongly discouraged from holding a database connection while other operations take place.

Architecture 200

Architecture Database Latency Servers 200

HammerDB

OCTOBER 18, 2018

An essential part of database performance testing is viewing the statistics generated by the database during the test and in 2009 HammerDB introduced automatic AWR snapshot generation for Oracle for the TPC-C test. However what if you want to review performance data in real time as the test is running?

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc. that a lot of people used.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Brendan Gregg

FEBRUARY 9, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 75

Performance Benchmarking Cache Tuning 75

Apica

MAY 10, 2019

The spread of where consumers want to consume content, at home, at the office, at the gym, on a plane, at any time where there is connectivity, puts significant pressure on the network and performance monitoring teams for streaming brands. Consumers will leave you for slow or intermittent performance because there are other content options.

Testing 40

Testing Performance Social Media Wireless 40

Brendan Gregg

FEBRUARY 8, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 40

Performance Benchmarking Cache Tuning 40

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02 order by c. 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 40

n0derunner

JULY 23, 2019

The Postgres DB is totally un-tuned and contains purely default settings. The aim of the experiment was to see how data-locality might affect a running database workload, not to generate the maximum TPS. Many different queries are executing in parallel, some hitting RAM cache, some hitting storage. appeared first on n0derunner.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

SQL Performance

DECEMBER 9, 2020

Testing different base table cardinalities is just one dimension to try. I’ll present the performance tests that I’ve done with my solution. What’s the best performing solution that you can conjure? You can create supporting tables in the user database if needed. Let’s proceed to performance testing.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

DECEMBER 9, 2020

Testing different base table cardinalities is just one dimension to try. I’ll present the performance tests that I’ve done with my solution. What’s the best performing solution that you can conjure? You can create supporting tables in the user database if needed. Let’s proceed to performance testing.

C++ 61

C++ Servers Testing Processing 61

High Scalability

NOVEMBER 25, 2019

Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Automate schema management for some remaining databases. Who performs what roles? Which database do you use? Cloud Platform. Google cloud. Hosted Data Centers. Object Stores.

Architecture 52

Architecture Cache Azure Storage 52

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40