mySQL - what table type to use?
[1/6] from: petr::krenzelok::trz::cz at: 6-Aug-2003 13:04
Hi,
I just downloaded mySQL and Control Centre app yesterday and I set-it-up
under Windows. Well, to be honest, open-source folks still have to
learn, how to make it operable more easily, than to struggle with
configs and manual directory placements etc.
I would like to ask, what type of db you use with mySQL? Is myISAM good
for most cases or is any transactional db type (innoDB, BDB) better path
to follow? i do care of data consistency, but maybe myISAM is good
enough for average news-site or small-portal kind of projects?
Thanks a lot,
-pekr-
[2/6] from: matt:blis at: 6-Aug-2003 12:52
Petr,
myISAM is good enough for most general cases, and easy enough to maintain.
Regards,
Matt
--
NP: nothing at the moment...
Petr Krenzelok wrote:
[3/6] from: g:santilli:tiscalinet:it at: 6-Aug-2003 15:45
Hi Petr,
On Wednesday, August 6, 2003, 1:04:19 PM, you wrote:
PK> I would like to ask, what type of db you use with mySQL? Is myISAM good
PK> for most cases or is any transactional db type (innoDB, BDB) better path
PK> to follow? i do care of data consistency, but maybe myISAM is good
PK> enough for average news-site or small-portal kind of projects?
I never had any data loss on any applications in several years of
use of MyISAM tables. Actually, unless you really need to handle
complex transactions where roll-back is critical, I don't think
there's any need for transactions at all.
Regards,
Gabriele.
--
Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer
Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/
[4/6] from: rgaither:triad:rr at: 6-Aug-2003 14:09
Hi Gabriele, Petr,
> PK> I would like to ask, what type of db you use with mySQL? Is myISAM
> good
<<quoted lines omitted: 6>>
> complex transactions where roll-back is critical, I don't think
> there's any need for transactions at all.
I have only played with mySQL but agree that myISAM is a
reasonable choice for something like a news-site or small-portal.
I would add some caution though to the statement about roll-back
capabilities being for complex transactions. The key to this part
of the decision is as much based on the application type, and the
way it is programmed than the complexity. When you have a db
with transaction support you design and program one way, if you
are using a db without transaction support you need to design it
differently to get reasonable reliability.
FWIW, Rod.
Rod Gaither
[rgaither--triad--rr--com]
336-644-9247
Oak Ridge, NC USA
[5/6] from: g:santilli:tiscalinet:it at: 6-Aug-2003 23:23
Hi Rod,
On Wednesday, August 6, 2003, 8:09:32 PM, you wrote:
RG> are using a db without transaction support you need to design it
RG> differently to get reasonable reliability.
Yes, of course, but it depends on what your DB is modeling.
Roll-back is important if aborting between queries would leave the
DB in an inconsistent state. Transactions are important if your
queries require proper serialization. You usually need these
features (by "need" I mean "can't live without") only for rather
complex databases. In simpler cases (as DBs used for web sites
usually are) you can easily (as you say) just write your software
differently.
Regards,
Gabriele.
--
Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer
Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/
[6/6] from: rgaither:triad:rr at: 6-Aug-2003 17:56
Hi Gabriele,
> RG> are using a db without transaction support you need to design it
> RG> differently to get reasonable reliability.
<<quoted lines omitted: 6>>
> usually are) you can easily (as you say) just write your software
> differently.
I agree. I just wanted to be sure the point about different design
and programming was mentioned, depending on the choice. If
you don't do this for either type of database you can find yourself
in trouble.
Thanks, Rod.
Rod Gaither
[rgaither--triad--rr--com]
Oak Ridge, NC USA
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted