- 79. By Mark Callaghan on 2012-03-12
add --oltp-inlist-sum that adds the query:
select sum(k) from TABLE where id in (....)
and there are 80 non-consecutive id values in the inlist.
- 76. By Mark Callaghan on 2010-11-05
Fix race conditions in sysbench fileio. There were a few global variables updated without
mutex protection. Remove fsync_mutex as the global sysbench mutex is sufficient. I don't
think fine-grained locking is needed in this code. I was getting errors and early
test failures when running this with multiple threads and fsync enabled.
- 75. By Mark Callaghan on 2010-10-19
Use somewhat random data for the 'k' and 'c' and 'pad' columns to make it harder to compress.
- 73. By Mark Callaghan on 2010-07-30
simple- update to get read-write workload with updates on non-indexed column for simple test mode.
point-select- mysql-handler- read-open- close to use HANDLER_ OPEN_READ_ CLOSE for tests that use HANDLER
- 72. By Mark Callaghan on 2010-05-13
test-mode= incupdate and --oltp- test-mode= incinsert for new tests.
With 'incupdate' each thread does nothing but updates to increment the integer
stored in column 'c'. With 'incinsert' the same is done using
INSERT ... ON DUPLICATE KEY UPDATE c = c + 1. The table of 'c' in the sbtest
table is not changed from char. I have a use case for which the performance
of these statements matter.
- 71. By Mark Callaghan on 2010-05-13
test-mode= simplejoin that uses a self-join query for the test table:
SELECT t1.c, t2.c
from %s t1, %s t2
where t1.id between ? and ? and t2.id = @num_rows_in_table - t1.id
This shows significant performance differences between MyISAM and InnoDB.
- Branch format:
- Branch format 7
- Repository format:
- Bazaar repository format 2a (needs bzr 1.16 or later)