Hallo, is there a way of maintaining Memory tables or rebuilding indexes?
I have a "big" memory table with about 300k rows, 12 Attributes, 7 BTREE-Indexes and a PRIMARY KEY (Hash index). Now i'm doing many many Updates (and a little number of inserts) on this table that also do effect indexed attributes. (With many updates I mean about 2000 per second...thats why I have chosen Memory storage engine) The strange thing is that my table grows above linear to the happening inserts, so average row size (=total memory used by table divided by number of rows) increases too. When I now copy this table to another database or another table name by "CREATE TABLE new ..." and then "INSERT INTO new SELECT * FROM old" memory used by new table can be about 50% (depends on number of actions done on the old table before) of memory used by old table although Structure and Data are equal. Could that be a bug? Table size especially of Memory tables should not increase by updates i think... greets! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
