InnoDB or MyIsam DB tables?
I have a few questions about the differences. I have site with alot of database activity and I believe I need my tables to be InnoDB to support row locking, what is the downside if any to InnoDB? I read that it slows down your overall DB performance, but is this a negligible difference?Also, this is a silly question I'm sure but I can't figure it out. How do I know if my current talbes are MyIsam or InnoDB? I assume that MyIsam is the default but I would to confirm that it is what I am currently using.
Thanks for the help..