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*)) sizeof(char*) is 4 on 32-bit machines and 8 on 64-bit machines." -- But frankly, I don't get it. Could someone please explain this to me? Lets say I have a heap-table that looks like this: CREATE TABLE get_mem( id INT NOT NULL, name CHAR(15) NOT NULL, nr MEDIUMINT NOT NULL, PRIMARY KEY(id) ) TYPE = HEAP; How would I calculate the memory used for 1 row? Thank you, Mathias _______________________________________________________ Spara filer på nätet. Lagra upp till 500 Mb på Passagen http://webbdrive.passagen.se --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php