MySql 索引限制

给json中的字段创建索引

alter table customer add index usera((CAST(custom_json ->> '$.userId' as CHAR(500))));

创建索引数量限制报错

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

评论

暂无评论