Remove 2003 Remove Best Practices Remove Scalability Remove Tuning
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. System setup is covered on the PostgreSQL Best Practice post so it will not be repeated here as the steps are the same. innodb_file_per_table.

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. Rich Pettit is one of the best programmers I ever met. He had it up and running on Wednesday.

Tuning 52
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ However, the ​​ algorithm ​​ has been ​​ tuned ​​ and the resulting ​​ affect ​​ is ​​ minimal. ​​ For example, ​​ the I/O speed of a snapshot database could limit certain query scalabilities.

Servers 40