MySQL Forums
Forum List  »  Newbie

exact row size of InnoDB table
Posted by: morteza ir
Date: April 09, 2011 01:41AM

Hi
I have a table like below. how can i get the exact size of 1 row?, not average row size. is there any query to do?

Best Regards.
Morteza

CREATE TABLE `a_test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`createdate` date DEFAULT NULL,
`RoPA` decimal(18,4) DEFAULT NULL,
`RoM` decimal(18,4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Edited 1 time(s). Last edit at 04/09/2011 01:42AM by morteza ir.

Options: ReplyQuote


Subject
Written By
Posted
exact row size of InnoDB table
April 09, 2011 01:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.