Hi All,
I NEED SOME ADVISE ON WHAT IS THE BEST WAY TO PARTITION THIS TABLE.
| job_file | CREATE TABLE `job_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job_user_id` int(11) NOT NULL,
`job_methods_id` int(11) DEFAULT NULL,
`work_id` int(11) DEFAULT NULL,
`member_id` int(10) unsigned DEFAULT NULL,
`subject_uri` text NOT NULL,
`subject_gram` text,
`reply` mediumtext,
`date_entered` datetime NOT NULL,
`subject_guid` varchar(36) DEFAULT NULL COMMENT ,
`test_error` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `C_job_methods_job_file` (`job_methods_id`),
KEY `C_job_user_job_file` (`job_user_id`),
KEY `C_work_job_job_file` (`work_id`),
KEY `C_member_job_file` (`member_id`),
KEY `test_error` (`is_error`),
KEY `date_entered` (`date_entered`),
CONSTRAINT `_____C_job_methods_job_file` FOREIGN KEY (`job_methods_id`) REFERENCES `job_methods` (`id`),
CONSTRAINT `_____C_job_user_job_file` FOREIGN KEY (`job_user_id`) REFERENCES `job_user` (`id`),
CONSTRAINT `_____C_work_job_file` FOREIGN KEY (`work_id`) REFERENCES `work` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=155289248 DEFAULT CHARSET=utf8 |
ASKER