Claudio Nanni wrote:
A very first thing you should do is to evaluate the storage needed by a
single row.
This can be done by summing up all columns data types length in bytes and
index lenght as well.
This should be quite accurate.
Just a tip to start:
http://dev.mysql.com/doc/refman/5.0/en/st
A very first thing you should do is to evaluate the storage needed by a
single row.
This can be done by summing up all columns data types length in bytes and
index lenght as well.
This should be quite accurate.
Just a tip to start:
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid outp
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid outputtin