Home > Archive > MySQL Server Forum > August 2005 > Size of a record?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Size of a record?
siliconmike

2005-08-07, 8:23 pm

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

2005-08-07, 8:23 pm

siliconmike wrote:
> 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)


Does this help?
http://dev.mysql.com/doc/mysql/en/s...quirements.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.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com