Jump to content

[Mysql] Default Storage Engine


deajakovl

Recommended Posts

Hello,

 

Got problems with setting default storage engine to InnoDB on johnny. Is it even possible to make that?

I created 4 tables gave them engine type InnoDB, but when I want to join them with foreign keys I can't do that.

I thought problem was in default storage engine on MySQL server, it is set to MyISAM is there a chance to change that?

Picture is here http://prntscr.com/9zvnsh

 

Ty for your help.

Link to comment
Share on other sites

We changed it to MyISAM intentionally. InnoDB has a past history of being extremely unreliable here.

 

It crashed a while back (on both servers no less!) and was broken for well over a year. It was actually just fixed a few months ago. It was read-only for everyone, and the mysql server would crash for everyone on the server every time someone tried to edit an InnoDB table. A ton of users had to convert their databases to MyISAM at that point, or have their databases manually restored when the server was fixed. Everyone had to recreate their database users too.

 

In fact, because of it, I don't even have a single InnoDB table on my account anymore that I can test with! I dropped all of mine when the server was finally capable of doing it without crashing...

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...