Advertisement:

Author Topic: Is InnoDB fully supported in 2.0.x?  (Read 1697 times)

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 824
    • sbulen on GitHub
Is InnoDB fully supported in 2.0.x?
« on: July 01, 2017, 03:08:29 PM »
I've been thinking of making the conversion to InnoDB, but it is unclear to me whether it is explicitly supported. 

It's not mentioned on the requirements page:
https://wiki.simplemachines.org/smf/SMF2.0:Requirements_and_recommendations

There is an old thread or two that mention issues with merge functions, but they are old. 

I've been assuming it's OK...  Checking that assumption... 


Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,212
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Is InnoDB fully supported in 2.0.x?
« Reply #1 on: July 01, 2017, 04:33:09 PM »
It should work ok. Main thing is to make all the tables the same type otherwise there could be performance issues on the joins
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,792
    • Arantor on GitHub
Re: Is InnoDB fully supported in 2.0.x?
« Reply #2 on: July 01, 2017, 05:30:54 PM »
Also read the performance notes, I seem to recall there used to be issues around certain tables needing to be reordered though I think those were fixed in 2.0.8.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 824
    • sbulen on GitHub
Re: Is InnoDB fully supported in 2.0.x?
« Reply #3 on: July 01, 2017, 10:18:09 PM »
Thanks for the input.

I'd read all of those notes, but it's hard to tell if any of the concerns apply to current versions or not. 

I've had my test environments InnoDB for a while, so I went for it in prod.  So far, so good.  If anything pops up, I'll report back. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 824
    • sbulen on GitHub
Re: Is InnoDB fully supported in 2.0.x?
« Reply #4 on: July 12, 2018, 10:28:10 AM »
A year later and everything is fine.  No issues whatsoever. 

Medium-sized forum (165517 Posts in 18774 Topics by 24414 Members - most online today: 85, including guests).   

Interesting discussion on InnoDB on this thread, including some restrictions, e.g., on fulltext searches & filesystem restores:
https://www.simplemachines.org/community/index.php?topic=560209.msg3979759#msg3979759

Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 68,792
    • Arantor on GitHub
Re: Is InnoDB fully supported in 2.0.x?
« Reply #5 on: July 12, 2018, 10:32:54 AM »
There used to be issues prior to 2.0.8 with board ordering, but the only blocker left is full text indexes if you’re on below 5.6. Everything else should be fine now.
To assume is to hope that those who came before had the presence of mind and capacity to implement the dreams of those who would come after.

Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.