Remove 2003 Remove Best Practices Remove Hardware
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. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. H ammerDB CLI v3.1.

article thumbnail

HammerDB Best Practice for PostgreSQL Performance and Scalability

HammerDB

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. hammerdbcli.

Insiders

Sign Up for our Newsletter

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

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. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

ReadFile WriteFile ReadFileScatter WriteFileGather GetOverlappedResult ​​ For extended details on the 823 error, see ​​ Error message 823 may indicate hardware problems or system problems ​​ ( [link] i crosoft.com/default.aspx?scid=kb ​​ Contact your hardware manufacture for assistance.

Servers 40