Hello,
i try do migrate from MyISAM to InnoDB and i convert every my table but when i try to convert "prefix_site_content" i get error:
"SQL Error: The used table type doesn`t support FULLTEXT index"
have you idea how can i change the stored engine?
Thanks
palma non sine pulvere
You cannot use InnoDB tables for MODX at the current time, at least not for the site_content table. MODX requires a fulltext index on that table at this time, which is not supported by that storage engine.
I have site with >5,000 pages and when i migrate to InnoDB (without site_content unfortunately
) i thing is load faster
palma non sine pulvere
With the recent optimizations to the InnoDB engine, it is certainly possible that it is outperforming the MyISAM engine in places. Historically this was not true and I think it would make a great feature request for MODX to fully support the InnoDB engine, either by default or as an optional feature.
-
- 24,544 Posts
It would be great to have transaction processing for some applications.
-
- 11 Posts
This is great information. Thank you. Two questions:
Was wondering if a conversion to InnoDB was on a schedule for an upcoming release?
If not, is there any reason why, with that one table exception, that we should not convert to it if running on MySQL 5.5.x?