MyISAM versus Innodb - help me!!

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
We have developed a site where users can post blogs.

Now, each blog is stored in a separate row, in a table called

This single table would be the most active one and would grow to large
 size in the coming years.

What is the most advisable engine for this table - Innodb or MyISAM ?

Also, I do need FULLTEXT search, and since Innodb doesn't support
 FULLTEXT indexes, are there 3rd party tools that could do the indexing

 ? (Maybe mnoGoSearch ?)


Re: MyISAM versus Innodb - help me!!

Quoted text here. Click to load it


you don't think there should be one table called "blog_table" with the
name of each blog ("Jenny's Cool BlogWorld") and then a seperate table
called "blog_entries" that has the actual blog entry and a reference to
which blog it should appear in (an ID from "blog_table")?   I *guarantee*
this is the proper way to do this, rather than keeping everything in one
single table.  For example, what if Jenny wanted to change the title of
her Blog to "Jenny's Terrible BlogWorld"?  Or if Jenny wanted to change
her email address/age/sex/anything?  Or if she wanted to delete a single
blog entry?

So, we're looking at three tables at minimum:


OwnerID | OwnerName | OwnerEmail
1          Sammy P.
2          Jenny S.
4          Marvin H.


BlogID | BlogOwner | BlogTitle
1          2            "Jenny's Cool BlogWorld"
2          4            "Marvin's Blog o Plenty"


EntryID | BlogID | BlogEntry
1           2        "My name is Marvin. I am 11 years old."
2           1        "If my name wasn't Jenny, things would be easy"
3           1        "Today mom said, 'Jenny you are great!'"

Therefore, the table seeing the most action/size increase would be

Quoted text here. Click to load it

i can't see why you'd even consider InnoDB for this project.  what makes
you think you need transactions for this project?  

Quoted text here. Click to load it

well you've answered your own question here, dont you think.  forget
third-party tools.  again, there is no reason from what you've given as
to why InnoDB should even be considered.

Instead of leaping in with "what engine should I choose", you should make
sure your database schema is as good as it can be.  I would say that the
amount of customizable web projects that run smoothly off of a single
table in a database would be close to zero.  

Re: MyISAM versus Innodb - help me!!

Good Man wrote:
Quoted text here. Click to load it

Oh well, your 'blog_entries' is my 'blog_table', but your mail confirms
that what I'm doing is right.

Quoted text here. Click to load it

Well I was also considering factors like
increased speed due to row level locking in Innodb
and other factors (unknown to me) where my choice of Innodb would be
justified even though I am not using transactions..

Re: MyISAM versus Innodb - help me!!

Quoted text here. Click to load it

you won't notice it - go MyISAM all the way for this project.

Site Timeline