MySQL Forums
Forum List  »  Memory Storage Engine

Re: table size growth
Posted by: Benjamin Tuffreau
Date: March 09, 2012 10:31AM

Hello Rick,


Yes, the engine is 'MEMORY' and I get the size from information_schema, with the following query:

select round((INDEX_LENGTH + DATA_LENGTH)/1024/1024,2) from tables where table_schema like 'database' and table_name like 'table'


About the cost of memory allocation.. I meant that perhaps MySQL anticipates the need in memory for a table by allocating more than necessary instead of allocating memory everytime there is an 'insert' because the memory allocation costs CPU (in C for example). I just wonder if it works this way.. and if it's the case, is this behavior/feature tunable?

The CPU are fine.. we start using MEMORY to increase speed of some query.

And yes, we have a lot of indexes: 'show index from my_table' shows 17 indexes.


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
6680
March 08, 2012 04:53AM
2225
March 09, 2012 09:45AM
Re: table size growth
2167
March 09, 2012 10:31AM
2429
March 10, 2012 11:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.