Advertisement:

Author Topic: Convert your tables to InnoDB  (Read 224229 times)

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: Convert your tables to InnoDB
« Reply #240 on: April 24, 2011, 12:14:48 PM »
You could ask your host to enable InnoDB. Or, like you said, move hosts.
Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Offline 008Rohit

  • Semi-Newbie
  • *
  • Posts: 84
  • Gender: Male
    • TechTage
Re: Convert your tables to InnoDB
« Reply #241 on: April 24, 2011, 01:19:48 PM »
@ Joshua

Normal support staffs of iPage know nothing about MySQL, They say "Our advanced technical support person will contact you" everytime. :(
I wanted someone's VPS, as I cant afford to buy one myself atm. but noone is willing to share their VPS with me.
TechTage Forum - Vintage Technology - on MDDHosting - CloudLinux & LiteSpeed Powered - MDDHosting Review

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: Convert your tables to InnoDB
« Reply #242 on: April 24, 2011, 03:58:34 PM »
That's sad. I definitely would not be using a host that didn't know how to enable InnoDB.
Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Offline naikvarda

  • Semi-Newbie
  • *
  • Posts: 10
Re: Convert your tables to InnoDB
« Reply #243 on: April 25, 2011, 01:09:53 AM »
This is really nice information related to the conversion.

Offline 008Rohit

  • Semi-Newbie
  • *
  • Posts: 84
  • Gender: Male
    • TechTage
Re: Convert your tables to InnoDB
« Reply #244 on: April 25, 2011, 07:42:53 AM »
That's sad. I definitely would not be using a host that didn't know how to enable InnoDB.
I asked them today to enable InnoDB tables. and their advanced technical support person replied after an hour saying that InnoDB is not supported on their server...
Even status.php cant track their MySQL processes or Processor information. :(
TechTage Forum - Vintage Technology - on MDDHosting - CloudLinux & LiteSpeed Powered - MDDHosting Review

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: Convert your tables to InnoDB
« Reply #245 on: April 26, 2011, 06:45:34 PM »
I would definitely change hosts.
Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Offline Realinfo

  • Full Member
  • ***
  • Posts: 627
    • Real Info
Re: Convert your tables to InnoDB
« Reply #246 on: October 14, 2012, 01:06:45 AM »
"You have to choose at least one column to display"

I got this message........

Offline Realinfo

  • Full Member
  • ***
  • Posts: 627
    • Real Info
Re: Convert your tables to InnoDB
« Reply #247 on: December 15, 2012, 09:48:34 PM »
"You have to choose at least one column to display"

I got this message........

Bump

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Convert your tables to InnoDB
« Reply #248 on: August 21, 2013, 06:36:05 PM »
Hi,

Having made these database changes to InnoDB - I now get this error whenever trying to post

Unknown column 'log_time' in 'where clause'
File: /xxx/xxx/public_html/fiddleforum/Sources/Subs.php
Line: 3110

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Convert your tables to InnoDB
« Reply #249 on: August 21, 2013, 07:02:03 PM »
Fixed it by running upgrade.php again

Offline madfiddler

  • Full Member
  • ***
  • Posts: 667
  • Gender: Male
  • Flit Kills Moths
    • madfiddler
Re: Convert your tables to InnoDB
« Reply #250 on: August 21, 2013, 07:53:45 PM »
Ok, these errors go away when running upgrade, however if I do a database optimise, it comes back.

I tried converting the settings table back to MyIASM and get this

ALTER TABLE x_settings
ENGINE=MyIASM;# MySQL returned an empty result set (i.e. zero rows).

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,781
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: Convert your tables to InnoDB
« Reply #251 on: June 04, 2014, 02:48:58 PM »
I just did this conversion on my website, and I've noticed a speed difference. Thank you for the suggestion.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: Convert your tables to InnoDB
« Reply #252 on: June 04, 2014, 02:53:19 PM »
Good job using 9 year old advice without checking if it's still relevant...
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,781
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: Convert your tables to InnoDB
« Reply #253 on: June 04, 2014, 04:45:03 PM »
Well, it's worth a try. If you make the appropriate backups prior to trying, and if things go wrong, you can always go back... So why the smite? No one gave me an instructional manual on how to run a forum, I'm learning as I go. If you don't have any constructive criticism for us, then get lost, otherwise play nice.

- http://www.simplemachines.org/community/index.php?topic=496086.0

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,982
    • StoryBB/StoryBB on GitHub
Re: Convert your tables to InnoDB
« Reply #254 on: June 04, 2014, 05:01:40 PM »
Because this is lacking a number of tables, lacking a good number of enhancements and taking advice from a 9 year old topic as gospel is a bad idea.

Just because it doesn't have any consequences *now* doesn't mean there won't be consequences in the future. Also, I *really* hope you didn't touch smf_boards or smf_categories in your conversion.

Also, 'smite', really? You really don't know me very well by now, do you? I treat everything in black and white as it is presented to me. 9 year old advice, written for SMF years ago, for a totally different version of MySQL... it could have all kinds of consequences, which you might not find out until too late.

Fine, you don't want my advice, I can manage that.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Biology Forums

  • SMF Hero
  • ******
  • Posts: 3,781
    • StudyForcePS on Facebook
    • @studyforceps on Twitter
Re: Convert your tables to InnoDB
« Reply #255 on: June 04, 2014, 05:11:05 PM »
Just because it doesn't have any consequences *now* doesn't mean there won't be consequences in the future. Also, I *really* hope you didn't touch smf_boards or smf_categories in your conversion.

Those boards weren't designed for innoDB, you'd need to alter some table attributes. I didn't change those.

I get your mannerism, but sometimes it comes across as smug, especially with your vast amount of knowledge in this field. From an educators standpoint, your way of approaching questions (from students, like myself) would never work in a classroom - not that it matters here.