[Phpmyadmin-devel] PACK_KEYS, CHECKSUM, DELAY_KEY_WRITE on InnoDB
Marc.Delisle at cegepsherbrooke.qc.ca
Thu Mar 2 02:28:06 CET 2006
Sebastian Mendel a écrit :
> Marc Delisle wrote:
>> Sebastian Mendel a écrit :
>>> 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.
More information about the Developers