MySQL Forums
Forum List  »  Performance

Re: MySQL optimization for testing purpose
Posted by: Sebastien FLAESCH
Date: April 06, 2018 02:00AM

Thanks, but no, it does not help me...

I don't understand why you point me to the Percona product site.

Seems that the link you provided is about:

1) Servers with a lot of RAM (I have Oracle MySQL 8.0 on a desktop PC with 8Gb)

2) Percona's specific innodb_lazy_drop_table option, which is not MySQL standard.

https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html

3) This discussion is from 2011, so I assume that there have been enhancements and changes in the MySQL code that can affect CREATE TABLE / DROP TABLE perfs.

Seb

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.