[rt-users] uhm - why innodb?

Harald Kapper hk at kapper.net
Sun Jul 18 22:14:33 EDT 2004


hi
sorry for my ignorance, but as I'm like fellow list-members in planning the move
from 3.0.9 to 3.2.1 here I'm once again in testing how long a whole insert of
our rt-database into a new database takes (yes, I have to do it the "right" way
for replication to work and other stuff). and the result is mysqldump is pretty
fast :-) - but the inserting is something I should plan for at least a weekend
(and always thought we had fast boxes *g*).

just for the goof I also tested this export+import thing using myisam tables and
(surprise surprise) that got it a lot faster ;-)

now - I don't see relationships between the tables (references) and I deeply
believe rt v2 was running on myisam tables - now I really tried to find a
reference on "why innodb" or at least some transactional code in the sources,
but couldn't find any (but hey, that's me - not a specialst).

so my dumb question here: are innodb-tables necessary? (and why?)

thank you in advance
Harald Kapper, icq# 36178328         kapper.net, inc.
managing director, owner,            loeblichgasse  6
chief executive officer              1090 vienna, .at
tel +43 1 3195500-0, fax +43 1 3195502, hk at kapper.net
--------------quote.of.the.day--------------
 All programmers are optimists
 -- Frederick P. Brooks, Jr.



More information about the rt-users mailing list