MySQL Forums :: Newbie :: exact row size of InnoDB table


Advanced Search

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 morteza ir 04/09/2011 01:41AM
Re: exact row size of InnoDB table Rick James 04/10/2011 11:21AM


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.