Re: MySQL optimization for testing purpose
On 04/03/2018 06:15 PM, Sebastien FLAESCH wrote: 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 FYI, 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) Seb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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
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... 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