Remove c
article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

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. SELECT DISTINCT c from sbtest where id between ? order by c. SELECT c from sbtest where id=? 10 rows in set (0.02

article thumbnail

HammerDB Best Practice for PostgreSQL Performance and Scalability

HammerDB

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. Initially it is best leave all of these states enabled. D isabling all C-states or Idle states is likely to reduce overall performance by reducing the available turbo frequency. hammerdbcli.

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

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

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. He had it up and running on Wednesday. that a lot of people used.

Tuning 52
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Note: ​​ Pages that are nev er modified ( never​​ dirtied) remain in the clean state until they are dis c arded at which time the checksum is validated for the constant page. Then ​​ write C ​​ obtains ​​ 01 ​​ and so on.

Servers 40