Comments on: MySQL InnoDB Sorted Index Builds https://www.percona.com/blog/mysql-innodb-sorted-index-builds/ Tue, 06 Aug 2019 20:02:10 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Satya Bodapati https://www.percona.com/blog/mysql-innodb-sorted-index-builds/#comment-10970832 Mon, 27 May 2019 09:11:39 +0000 https://www.percona.com/blog/?p=56485#comment-10970832 Hello Fernando,

If you foresee that there will lot of DMLs after add index/ optimize table, then 90 should be a good value start with.
Suggest to have good strategy to do such changes. May be try on slave first.

]]> By: Fernando Mattera https://www.percona.com/blog/mysql-innodb-sorted-index-builds/#comment-10970779 Mon, 13 May 2019 13:50:18 +0000 https://www.percona.com/blog/?p=56485#comment-10970779 Hi, in your opinion, what’s the average innodb_fill_factor percent value suggested for all purpose tables?
I understood 100 isn’t good enough.
Thanks in advance

]]>