MySQL 4.1.12-debian + large HEAP table

2005-08-03 Thread gaga moo
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

Re: MySQL 4.1.12-debian + large HEAP table

2005-08-04 Thread gaga moo
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