Re: How to calculete used memmory when using heap tables in Mysql

2002-11-19 Thread Benjamin Pflugmann
Hi. On Mon 2002-11-18 at 17:05:23 -0800, [EMAIL PROTECTED] wrote: > Hello , > I need help with heap tables and calculating memory usage. I checked > in the Manual and found a formula, but I need help > deciphering it ;) > > " The memory needed for one row in a HEAP table is: > > sizeof(char*) i

How to calculete used memmory when using heap tables in Mysql

2002-11-19 Thread Veselin Iordanov
Hello , I need help with heap tables and calculating memory usage. I checked in the Manual and found a formula, but I need help deciphering it ;) " The memory needed for one row in a HEAP table is: SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2) + ALIGN(length_of_row+1, sizeof(char*))