Benchmarking
Sysbench Under the Covers
Sysbench is a popular open-source benchmarking tool designed to evaluate the performance of system components such as CPU, memory, disk I/O, and databases. It is commonly used for testing MySQL, PostgreSQL, and other databases under different load conditions.
Read more
Creating a More Realistic Benchmark
Common benchmark approaches fall into two general categories, synthetic testing and realistic testing. You have the most generic operations from a synthetic test, starting with the most simple example using a single table, a single column, and for a single DML operation.
Read more
Testing, Benchmarking, Evaluating
Testing and benchmarking are widely used terms in software technology, each serving a distinct purpose and goal. With the increasing adoption of AI in software development, the term evaluating has become significant and with this the re-emergence of what is quality assurance.
Read moreSeeking public data for benchmarks
I have several side projects when time permits and one is that of benchmarking various MySQL technologies (e.g. MySQL 5.0,5.1,5.4), variants (e.g. MariaDB, Drizzle) and storage engines (e.g. Tokutek, Innodb plugin) and even other products like Tokyo Cabinet which is gaining large implementations.
Read moreUnderstanding your RAID Configuration
For any production MySQL Database system, running RAID is a given these days. Do you know what RAID your database is? Are you sure? . Ask for quantifiable reproducible output from your systems provider or your System Administrator.
Read moreLeveraging the power of Twitter
Last week I posted the following twitter request — “Can somebody loan me (or buy me) a Dell 2950 decked out so I can run and publish some benchmarks. Please!”
Read more