What does SHOW CREATE TABLE give you? -Sheeri
On 3/11/06, Holger Sunke <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]