Re: MySQL optimization for testing purpose
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
Subject
Views
Written By
Posted
1161
April 04, 2018 10:05AM
451
April 04, 2018 10:56AM
512
April 06, 2018 02:00AM
575
April 06, 2018 12:10PM
500
April 09, 2018 02:18AM
Re: MySQL optimization for testing purpose
591
April 09, 2018 07:18AM
528
April 09, 2018 07:23AM
608
April 09, 2018 07:34AM
489
April 09, 2018 08:00AM
699
April 09, 2018 10:06AM
514
April 10, 2018 08:24AM
525
April 10, 2018 10:27AM
482
April 10, 2018 11:07AM
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.