inodb: large old ibdata1 and multiple tablespaces

2004-12-06 Thread Paul Mallach
Hi! Running version 4.0 we created a fairly big innodb table (10GB, 72.950.601 rows). After upgrading to 4.1.7 we switched to multiple tablespaces. Then somebody ALTERed the table and innodb created a new idb file for the table. So right now we have 3 large files (old ibdata1|2 and the new

Re: inodb: large old ibdata1 and multiple tablespaces

2004-12-06 Thread Heikki Tuuri
Paul, - Original Message - From: Paul Mallach [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, December 06, 2004 1:59 PM Subject: inodb: large old ibdata1 and multiple tablespaces Hi! Running version 4.0 we created a fairly big innodb table (10GB, 72.950.601 rows