About the InnoDB conversion and the tool to do it... We now have got the tool out from the Linux installer on a VM, and have run it on a dev instance. It asks for various values (pool size etc).
- Is there any documentation about what these should be?
- How do these values compare to existing values for MyISAM?
- Where do they get written to?
- What determines whether a newly created database is MyISAM or InnoDB? I don't see anything in the files in
WEB-INF/xml/*
? - Once we convert our existing DBs, how do we ensure that any new ones we make are already in InnoDB format?
- Can the tool be run non-interactively so we can script it for all instances?