[Phpmyadmin-devel] PACK_KEYS, CHECKSUM, DELAY_KEY_WRITE on InnoDB

[Marc Delisle]

Sebastian Mendel a écrit :
> Marc Delisle wrote:
> 
>> Sebastian Mendel a écrit :
>>
>>> Hi,
>>>
>>> PACK_KEYS, CHECKSUM, DELAY_KEY_WRITE
>>>
>>> can also be set on InnoDB, BDB aso.
>>>
>>> whether it has an effect on this engines or not, should phpMyAdmin 
>>> display this properties as well, possible with a note that this 
>>> settings have no effect?
>>>
>>> f.e. if you created MyISAM tables with this options enabled (long 
>>> years ago), converted them to InnoDB and now export and import it 
>>> onto a server without InnoDB you have the above options enabled again 
>>> whether the Operator wanted it or not.
>>>
>>> If this option can be set phpMyAdmin should display it, regardless if 
>>> it has an effect or not.
>>>
>>>
>> Hi Sebastian,
>> I think that if MySQL supports the syntax, we should also, because in 
>> the future it might have an effect. And displaying a remark about the 
>> non-effect is correct, but we'll have to monitor the new MySQL 
>> versions to see if the option ever becomes effective.
> 
> 
> just to clarify, its not about supporting the 'syntax', i mean 
> displaying it in the table operations page.
> 
> 
Yes, I meant the interface.

Marc