HEAP table size

Hello, I am using HEAP tables and would like to see how much memory they use. I found this snipped of instruction in the MySQL-documentation: -- 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*))

maximum heap table size allowed

Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation apply equally to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street

Re: maximum heap table size allowed

Banach, Timothy P writes: Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation apply equally to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA

maximum heap table size

Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation also apply to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street Corporation Westwood,