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

[Marc Delisle]

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