Calculate row size?

[twifosp]

SHOW TABLE STATUS FROM your_db_name [like 'tabe_name']

Will give me average row sizes, but let's say I needed an exact size for each row. What would be the method to select the size of a specific row?

 

[r937]

here's one way:

SELECT * FROM daTable

and count the bytes in your application code



alternatively, you could develop a formula based on the specific columns in your table, and calculate 1 byte for TINYINTs, 2 bytes for SMALLINTs, 4 bytes for INTEGERS, 8 bytes for BIGINTs, LENGTH() for CHARS and VARCHARS, eck settera, eck settera...

SELECT formula FROM daTable



r937.com | rudy.ca