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.
Marc