[wp-trac] [WordPress Trac] #32310: Timeout on big tables upgrade to utf8mb4_unicode_ci

[WordPress Trac]

#32310: Timeout on big tables upgrade to utf8mb4_unicode_ci
-----------------------------+-----------------------------
 Reporter:  gabrielperezs    |      Owner:
     Type:  defect (bug)     |     Status:  new
 Priority:  normal           |  Milestone:  Awaiting Review
Component:  Upgrade/Install  |    Version:  4.2
 Severity:  normal           |   Keywords:
  Focuses:  performance      |
-----------------------------+-----------------------------
 If a table like wp_options is too big, the upgrade process can't finish.
 In my case, the table need around 12 minutes to this change so the
 wordpres upgrade process always hive a timeout.

 The core don't check if the table has the correct collation and send the
 order to change it again, is a loop never ends.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/32310>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform