awsdocs / amazon-aurora-user-guide

The open source version of the Amazon Aurora User Guide. You can provide feedback by submitting issues in this repo, or propose changes by submitting a pull request.
Other
53 stars 102 forks source link

Upgrading to Aurora MySQL version 3 alternative solution to dangling fulltext_index Errors #72

Closed HSken closed 2 years ago

HSken commented 2 years ago

Description of changes:

While performing the upgrade we encountered the "dangling fulltext_index" issue described in this documentation.

After reading the Mysql documentation, we decided to first try to OPTIMIZE the tables, this worked and is a far easier and faster solution to solve this issue than the solution provided in this documentation (creating a new table).

Hope this helps people in the future facing the same issue.

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.

claytran commented 2 years ago

merged- thanks @HSken!