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]

Reply via email to