Databases
StackOverflow2013
Postsdbo
POShould I use MyISAM or InnoDB Tables for my MySQL Database?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
    primarykey
    data
    text
    <p>I have the following two tables in my database (the indexing is <em>not</em> complete as it will be based on which engine I use):</p> <p><strong>Table 1:</strong></p> <pre><code>CREATE TABLE `primary_images` ( `imgId` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `imgTitle` varchar(255) DEFAULT NULL, `view` varchar(45) DEFAULT NULL, `secondary` enum('true','false') NOT NULL DEFAULT 'false', `imgURL` varchar(255) DEFAULT NULL, `imgWidth` smallint(6) DEFAULT NULL, `imgHeight` smallint(6) DEFAULT NULL, `imgDate` datetime DEFAULT NULL, `imgClass` enum('jeans','t-shirts','shoes','dress_shirts') DEFAULT NULL, `imgFamily` enum('boss','lacoste','tr') DEFAULT NULL, `imgGender` enum('mens','womens') NOT NULL DEFAULT 'mens', PRIMARY KEY (`imgId`), UNIQUE KEY `imgDate` (`imgDate`) ) </code></pre> <p><strong>Table 2:</strong></p> <pre><code>CREATE TABLE `secondary_images` ( `imgId` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `primaryId` smallint(6) unsigned DEFAULT NULL, `view` varchar(45) DEFAULT NULL, `imgURL` varchar(255) DEFAULT NULL, `imgWidth` smallint(6) DEFAULT NULL, `imgHeight` smallint(6) DEFAULT NULL, `imgDate` datetime DEFAULT NULL, PRIMARY KEY (`imgId`), UNIQUE KEY `imgDate` (`imgDate`) ) </code></pre> <p>Table 1 will be used to create a thumbnail gallery with links to larger versions of the image. <code>imgClass</code>, <code>imgFamily</code>, and <code>imgGender</code> will refine the thumbnails that are shown. </p> <p>Table 2 contains images <em>related</em> to those in Table 1. Hence the use of <code>primaryId</code> to relate a single image in Table 1, with one or more images in Table 2. This is where I was thinking of using the Foreign Key ability of InnoDB, but I'm also familiar with the ability of Indexes in MyISAM to do the same.</p> <p>Without delving too much into the remaining fields, <code>imgDate</code> is used to order the results.</p> <p>Last, but not least, I should mention that this database is <em>READ ONLY</em>. All data will be entered by me. I have been told that if a database is read only, it should be MyISAM, but I'm hoping you can shed some light on what <em>you</em> would do in my situation.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USstefmikhail
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. USWilliam The Dev
      1. VTFavorite
    3. VO
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis question begs debate ...should be migrated to Programmers ...???
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. USIAbstract
    2. CO@IAbstract - You speak of something I'm unaware of but would be glad to oblige if you elaborate...
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. USstefmikhail
    3. COhttp://Programmers.StackExchange.com is more subjective than StackOverflow. The way the question is asked will beg debate over which is better ...and, typically these questions have been closed. But since Programmers exists now and allows a greater deal of subjectivity in questions, seems like a better fit ...imho.
      singulars
      1. POShould I use MyISAM or InnoDB Tables for my MySQL Database?
      1. USIAbstract
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload