1
Workload-Specific Database Design
medium
A developer is trying to create a FULLTEXT index on a column in an RDS MySQL instance. The error log shows the index creation failed. What is the most likely cause?
Exhibit
Refer to the exhibit. === Amazon RDS MySQL Error Log === 2023-03-15 10:45:12 123456 [ERROR] [MY-013142] [Server] InnoDB: Table 'mydb.orders' has a FULLTEXT index on column 'description'. The maximum column length for FULLTEXT index is 4294967295. However, the column length is 4294967295 which may cause performance issues. 2023-03-15 10:45:12 123456 [ERROR] [MY-010067] [Server] Cannot create FULLTEXT index on column 'description' because the column is too long.