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 obtained value by number of > rows and compare the > results with the size of your table. See: > > http://dev.mysql.com/doc/mysql/en/memory-storage-engine.html OK, meanwhile I saw this in the docs: MEMORY tables use a fixed record length format. So I guess this is why my HEAP table is triple the size of the disk table. (Many varchars...) > > 2. How can I trace the memory consumption from > within > > mysql to know what's causing the huge spikes in > > consumption that eat my entire system memory? > > > Check if memory frees after dropping your HEAP > table. Sometimes > I met the weird behavior with non-official binaries. > So, if nothing > helps, try the latest release from > http://dev.mysql.com/downloads. I did so, no memory at all was freed by mysql. Does anybody on the list know how I can see exactly how the memory allocated by mysql is utilized internally? I'm suspecting a leak. Thanks __________________________________ Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
