We all know MySQL has its limits – it works fine in general, but has its weaknesses too. The authors of MySQL Performance blog started a miniseries about such limitations for experienced users. Okay, I guess you know there’s no way to create fulltext index on InnoDB tables – but bid you know, that MySQL [...]
Posts Tagged ‘MySQL’
There are many developers who prefer using ENUM in MySQL, which seems to be a viable choice many times. However it’s important to take care as…
ENUM requires a rebuild of the table when adding a value to the middle of the set.
ENUM values are ordered in the order they’re added to the database
ENUM values do [...]