Re: MySQL optimization for testing purpose

On 04/03/2018 05:59 PM, Sebastien FLAESCH wrote:
> 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?
> 
> Thanks in advance!
> Seb
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql