MySQL optimization for testing purpose
- Date: Tue, 3 Apr 2018 17:59:16 +0200
- From: Sebastien FLAESCH <sf@xxxxxxx>
- Subject: MySQL optimization for testing purpose
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...
How can this happen?
Any log I could enable and provide here?
Thanks in advance!
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql