[Phpmyadmin-devel] PACK_KEYS, CHECKSUM, DELAY_KEY_WRITE on InnoDB
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. -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet
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
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
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
participants (2)
-
Marc Delisle -
Sebastian Mendel