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
