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*))
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?
>
> 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 Stre
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, MA
