Tompkins Neil wrote:
Just looking for some confirmation that under a single database - I assume
it is perfectly normal to have both MyISAM and InnoDB engines for different
tables ? Is there anything I need to be aware of ?
In most case no problems. MySQL can mix engines without problems.
Every engine uses it's own specific buffers, so if your database becomes
big and memory becomes an issue (large buffers needed) it might be handy
to use only one engine (so you can set the buffers for the other
engine(s) to a very low number).
On a daily basis I use databases with mixed MyISAM and InnoDB tables.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
