Re: MySQL optimization for testing purpose

[Sebastien FLAESCH]

FYI, I have tried following settings:

innodb_doublewrite=0
innodb_log_file_size=100663296
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=268435456

ODI test 337 is now faster, but still something strange occurs:

Each time I restart the server, the test runs fast for a few times, and then it becomes slower and slower:

(times in seconds)

1 6.83
2 7.43
3 18.52
4 38.46
5 50.78
6 40.61
7 18.27
8 43.77
9 84.34
10 72.45
11 71.54
12 73.34

The fact that the test run fast after a restart of the server may help to understand what's going on?

Seb