As far as I know memory usage between the two table types is roughly the
same. The way memory is setup/used is somewhat different however. For
myisam the primary memoy buffer to accelerate queries is the key_buffer
which caches data for keys. In innodb you have more options to set with
the main
Here is another question. Can you achieve the same performance having
to different kinds of databases as though you were only using one? I
am assuming that you are going to run into problems because you cannot
set both types of databases to have a lot of memory allocated to them.
Right?
On
Yes, if you use both table types within a single database then you will
have to split up the memory usage. However, in many databases there are
just one or two tables that use 90% of the disk/memory space. If this
is your situation then you just allocate most of the memory for the
table type