Hi guys,
It's only 1277608 records in my table but the size is about 1.2GB.
Is it normal or what can i do to decrease the size?
TABLE STRUCTURE
CREATE TABLE `mydatabase`.`company_general` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category` char(50) NOT NULL,
`group` char(50) NOT NULL,
`type` char(50) NOT NULL,
`priority` char(5) NOT NULL,
`status` char(50) NOT NULL,
`created_by` char(50) NOT NULL,
`created_date` datetime NOT NULL,
`modified_by` char(50) NOT NULL,
`modified_date` datetime NOT NULL,
`ref1` char(255) NOT NULL,
`ref2` char(255) NOT NULL,
`ref3` char(255) NOT NULL,
PRIMARY KEY (`ID`,`category`,`group`,`type`,`priority`,`status`,`ref1`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=90000001 DEFAULT CHARSET=utf8;
INSERTED DATA (sample)
INSERT INTO company_general (`category`, `group`, `type`, `priority`, `status`, `created_by`, `created_date`, `modified_by`, `modified_date`, `ref1`, `ref2`, `ref3`) VALUES ('All','','', '01', 'Active', 'system', now(), 'system', now(), 'UPPER POWER ','','');