Hello Gleb,
Thanks for your answer.
--- Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
> > 1. Why does the HEAP table take so much more
> physical
> > space than the MyISAM table?
>
> There is a formula which allows to count the
> approximate memory usage
> for one row. Multiply an ob
Hello.
> 1. Why does the HEAP table take so much more physical
> space than the MyISAM table?
There is a formula which allows to count the approximate memory usage
for one row. Multiply an obtained value by number of rows and compare the
results with the size of your table. See:
http:
Guys,
I have two questions that I hope someone would be able
to answer.
First some backround, I'm running a standard debian
package of mysql 4.1 (currently the latest version)
with no my.cnf tweaks except turning on query caching
(using the default values from the manual) and
allowing for large
