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

[Sebastian Mendel]

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.


-- 
Sebastian Mendel

www.sebastianmendel.de
www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet