Web lists-archives.com

Re: Changing storage engine in dump file.




I have already made this attempt. And really I stucked into some problems.
I found lots of full text indexes created on the data directory . I don't
know from where they come. We have never created full text indexes for that
database. Slave also was not able to sync with its master. Now, I have
restored all the things back by restoring mysqldump file as it was.

Best Regards,
Geetanjali Mehra
Senior Database Administrator


On Thu, Aug 13, 2015 at 10:31 PM, Singer Wang <wang@xxxxxxxxxxxxxx> wrote:

> Depending on the version of MySQL and InnoDB engine, the max key length
> can be 3072 for InnoDB..
>
> On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman <vegivamp@xxxxxxxxx>
> wrote:
>
>>
>> ----- Original Message -----
>> > From: "geetanjali mehra" <mailtogeetanjali@xxxxxxxxx>
>> > Subject: Changing storage engine in dump file.
>> >
>> > Is there any implications in doing so. Is this approach correct? Will I
>> > face any problem in syncing the slave?
>>
>> The first thing that occurs to me, is that the maximum key lenght for
>> MyISAM is 1000 bytes, but for InnoDB it is only 786 bytes...
>>
>> Depending on your server version, InnoDB may not yet have fulltext
>> indices, and even if it does, the behaviour is different from the MyISAM
>> ones.
>>
>> You are likely to run into a myriad of tiny little differences, and it
>> seems to me like a fairly bad plan. Why do you want this?
>>
>>
>> --
>> Unhappiness is discouraged and will be corrected with kitten pictures.
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql
>>
>>
>