database performance: test setup: Data Collected
Each test sample contains the following data (shown here with examples):
Obviously each test may use a different combination of any of the above.
This means that as long as there is some varying data for any of those parameters, it is possible to compare the impact that it has on any subset of the other unchanged attributes.
Data | Example |
---|---|
A generated unique key to uniquely identify the sample | 12345678-12345 |
The version of the code | 11003 |
Operating System and kernel version | GNU/Linux - 2.6.19.1 |
Architecture, CPUs and memory | x86_64 - 2xOpteron 246 - 1GB |
Java Version and Vendor | 1.6.0 - Sun Microsystems |
Database product name and version | MySQL - 5.1 |
JDBC driver version | 3.0 |
Test Name | Multi Threaded Updates |
Thread pause (in milliseconds) | 5 |
Volume and Scale | 10 - 10000 |
Use of indexes and Prepared Statements | false - true |
Size of the initial data | 100000 |
Data Type tested | VARCHAR |
Group Size | 10 |
This means that as long as there is some varying data for any of those parameters, it is possible to compare the impact that it has on any subset of the other unchanged attributes.