MySQL optimization for testing purpose
Hi all,
Looking for some configuration tips to speed execution of our non-regression tests with MySQL.
We do pure functional testing, data persistence is not critical.
Our tests are not using a lot of data, but we create and drop a lot of test tables.
We have concurrency tests (processes locking rows), so this feature matters.
Are there some InnoDB params to enable or disable to speed up our tests?
Some tests behave a bit strange, sometimes one of our test takes 1 min 30 secs, sometimes it takes only 15 seconds...
In fact this tests creates and drops ~150 times the same table, having a single column using different types each time.
I can clearly see that sometimes table creations are fast, but from time to time it slows down to about a second to create a table.
How can this happen?
Any log I could enable and provide here?
I have tried following settings, but it did not help:
innodb_stats_auto_recalc=0
innodb_file_per_table=0
innodb_stats_persistent=0
I have recreated my database after restarting the server.
Server version: 8.0.4-rc-log MySQL Community Server (GPL)
Thanks in advance!
Seb
Subject
Views
Written By
Posted
MySQL optimization for testing purpose
1489
April 04, 2018 10:05AM
622
April 04, 2018 10:56AM
677
April 06, 2018 02:00AM
748
April 06, 2018 12:10PM
622
April 09, 2018 02:18AM
738
April 09, 2018 07:18AM
667
April 09, 2018 07:23AM
753
April 09, 2018 07:34AM
640
April 09, 2018 08:00AM
860
April 09, 2018 10:06AM
663
April 10, 2018 08:24AM
678
April 10, 2018 10:27AM
611
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.