MySQL Forums
Forum List  »  Performance

Re: MySQL optimization for testing purpose
Posted by: Sebastien FLAESCH
Date: April 09, 2018 07:18AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.