Size of a record?

[siliconmike]

How to find:

1. total size of data in bytes, in a record
2. total size in bytes of a record (including MySQL's own header bytes)

Mike

[Bill Karwin]

Re: Size of a record?

siliconmike wrote:[color=blue]
> How to find:
>
> 1. total size of data in bytes, in a record
> 2. total size in bytes of a record (including MySQL's own header bytes)[/color]

Does this help?

http://dev.mysql.com/doc/mysql/en/storage-requirements.html

There may be API functions in various programming interfaces like ODBC,
JDBC, or DBD that help to calculate this too. I haven't checked, so you
might want to look at the API reference docs. It depends on what
interface you are using in your applications.

Regards,
Bill K.