Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions.
1. What are the best parameter setting in my.cnf for innodb. 2. Is it possible to allocate each table a separate tablespace. 3. Is it possible to create index in a separate tablespace. 4. We planing to create partitioning at application level, is there a limit on no. of partitions, and also is there is a limit on number of rows on each partition. 5. We are planing to migrate from oracle to mysql, is there any particular way to speed up migrating huge data from oracle to mysql. 6. What are the different events do we need to moinitor in Mysql. thanks a lot for all you help. regards anandkl
