Jump to content

InnoDB for Image Gallery Tables


Recommended Posts

Dear all,

 

For photo gallery tables (named: gallery_album, gallery_image, gallery_relation), I have seen a recommendation to use InnoDB engine in preference to MyISAM. I thought MyISAM would be the choice for all tables but tables for transactions. Do you agree with the recommendation to using InnoDB for photo gallery tables and why?

Link to post
Share on other sites

The fact that InnoDB supports transactions and foreign keys and MyISAM does not is enough for me to always use InnoDB. The table-level locking that MyISAM does has also brought applications to a halt, where many people are waiting to write to a particular table that one person is selecting data from even though they are working with different rows. MyISAM still locks the entire table.

Link to post
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.

Loading...
×
×
  • Create New...