[wp-trac] [WordPress Trac] #51769: Full-text search support

[WordPress Trac]

#51769: Full-text search support
------------------------------------+------------------------------
 Reporter:  zieladam                |       Owner:  (none)
     Type:  enhancement             |      Status:  new
 Priority:  normal                  |   Milestone:  Awaiting Review
Component:  Database                |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  dev-feedback has-patch  |     Focuses:
------------------------------------+------------------------------

Comment (by zieladam):

 > hat would the effect be for someone moving hosts and doing an SQL export
 from a version that supports full text indexes and attempting to import in
 to a version that does not?

 @peterwilsoncc My guess is that the import will fail as `FULLTEXT KEY`
 will be part of `CREATE TABLE` and not a separate `ALTER TABLE` statement.
 One thing we could do is provide good documentation on how to handle this
 case (e.g. drop the index before exporting).

 It is also worth noting that it the last major MySQL version that wouldn't
 support it, 5.5, reached end of life in December 2018. Even MySQL 5.6 is
 not maintained anymore as of February 2021. The official WP.org
 requirements page says that WordPress requires MySQL 5.6 or newer:
 https://wordpress.org/about/requirements/

 So maybe this is not an issue at all?

 > I'm unsure about the 'large site' check, the logic is sound but in my
 experience such sites usually use the cli (wp core update-db) for DB
 upgrades rather than doing them in the admin.

 We could probably follow the same logic in CLI and render a note or prompt
 the user to answer a yes / no question.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/51769#comment:11>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform