MySQL Forums
Forum List  »  Optimizer & Parser

Re: not optimizing the table after index is created
Posted by: ragen sol
Date: October 18, 2011 04:24AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: not optimizing the table after index is created
971
October 18, 2011 04:24AM


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.