Support Forum
Support Forum
Offline
will do, got side tracked, my chickens decided spring was here and figured they would take a walk around the neighborhood, those chickens are lucky my wife loves them, will try in the next couple minutes
Offline
Just a update, I decided to hold off until I heard back from wp-engine, their response
We do automatically force some tables to InnoDB for performance reasons. You can change the database engine on your end to create the index, but please bear in mind that it will likely be a temporary change. I wouldn't consider this to be a bad thing, as the only consideration is from a performance side, not server stability or security.
My response back was why would it be a temporary change? Haven't heard back yet, so since they gave me the green light, I've tested switching it on my staging server and it works, it works with and without creating the index. Is the index necessary?
One other weird thing I noticed, every table for simplepress is already MyISAM, the only two that are InnoDB are the sfposts and sfoptions tables, is the sfoptions being InnoDB a concern?
I did create the table and tested it, search still works fine, just want to double check this is the way to do it if needed to create it before I do it on my live site, thank-you
Offline
I dont believe it would be a concern... strange that just the two however...
that looks like the proper way to add the fulltext index...
did the search actually work without the index? by that I mean find results? can let Andy weigh in as our db expert, but perhaps its performance and other searches (ie matching) that it directly affects...
Visit Cruise Talk Central and Mr Papa's World
Offline
yep, worked fine without the index, well fine until a member complains any ways lol
Offline
i did open up a task for me to take a fresh look at the innoDB options as it is true that they are better performers. That will be after the release of our 5.4.2 however.
Our sfoptions table being innoDB will not matter but it hardly needs to be. It s a very small table.
 |
YELLOW
SWORDFISH
|
Offline
Yellow Swordfish said
i did open up a task for me to take a fresh look at the innoDB options as it is true that they are better performers. That will be after the release of our 5.4.2 however.Our sfoptions table being innoDB will not matter but it hardly needs to be. It s a very small table.
Thanks Yellow, will I be fine if I do not create the index? Or is that mandatory? It seems to work with and without the index in place
All RSS