index-wp-mysql-for-speed icon indicating copy to clipboard operation
index-wp-mysql-for-speed copied to clipboard

TiDB doesn't handle ROW_FORMAT=DYNAMIC

Open OllieJones opened this issue 1 year ago • 0 comments

耗子 @haozi reports

I’m using TiDB as my database, but it doesn’t support ROW_FORMAT=DYNAMIC, so I get a These database tables need upgrading to MySQL's latest table storage format, InnoDB with dynamic rows. notice.

TiDB does not support this operation, I modified the plugin and commented out the ALERT TABLE in the upgradeTableStorageEngine function to skip it.

After operation, everything is ok.

I think a judgment should be added, when the database is TiDB, the upgradeTableStorageEngine function should not executed.

MyInfo: Plugin:1.4.12 MySQL:5.7.25-TiDB-v6.5.1 WordPress:6.2 WordPress database:53496 php:8.1.15

OllieJones avatar Mar 31 '23 09:03 OllieJones