Re: Does innodb have a temp table space?

2010-09-02 Thread neutron
h RAM and >> DISK >> based) >> >> http://dev.mysql.com/doc/refman/5.1/en/create-table.html >> >> Look at: >> >> TABLESPACE >> PARTITIONS >> ENGINE >> >> > -Original Message- >> > From: neutron [mail

Does innodb have a temp table space?

2010-09-01 Thread neutron
Hi all, As far as I know, some DB has a separate table space to store temp data (such as for external sort). My questions are: 1. Does innodb also has a separate temp-tablespace? 2. If I don't use "innodb_file_per_table", where is innodb's temporary tablespace? Is it in the shared tablespace?

how to run dbt 1/3/4/5 with mysql?

2010-08-30 Thread neutron
Hello all, I have run dbt2 with mysql. Can I also run dbt1/3/4/5 with mysql? thanks! -neutron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Can InnoDB do without doublewrite

2010-08-17 Thread neutron
lways replay the log to restore partial pages. I haven't grasped full knowledge of doublewrite and InnoDB yet. Is there anything wrong with my above comments? Why do we need the extra doublewrite? -Neutron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u