Re: not optimizing the table after index is created

[ragen sol]

Here is create table statement

CREATE TABLE `m_cont` (
`m_id` int(10) unsigned NOT NULL,
`m_type` varchar(50) default NULL,
`m_sb` varchar(500) default 'No Subject',
`snd_time` varchar(50) default NULL,
PRIMARY KEY (`msg_id`),
KEY `indx_msg_id_1` (`msg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I did not created the index at the time of table creation. but after that using

create index indx_name on table t1;

after that i ran the optimize table command;

then it showed that error.