…. I took DBT2, an OSDL’s implementation of TPC-C. Hardware used The benchmark was run on a DELL server running CentOS release…=1 innodb_file_per_table table_cache=2000 Depending on workload different InnoDB buffer was used. In CPU-bound case innodb… impact in case of CPU-bound workload. The performance impact is negligibly small in IO-bound workload even if all queries are…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
… goes in details about schedulers and explains in which of workloads which of schedulers is best. The interesting thing this article… deadline for MySQL workloads such as SysBench or DBT2 when it went down to 30% difference and in the last runs we’ve… it shared ? We should look into this when we’ll run more benchmarks for IO Schedulers.
Comment: Are larger buffers always better ?
June 17, 2006 By 9 Comments
… some bechmarks with 4.1 looking at performance of DBT2 benchmark under certain workloads. You can find it on our presentations page… the box. Most other settings are rather adjusted looking on workload and most typically only give marginal improvement. Do not forget… of your queries – you can set it before query is run. You values I guess are close to what I typically…
