index-wp-mysql-for-speed
index-wp-mysql-for-speed copied to clipboard
TiDB doesn't handle ROW_FORMAT=DYNAMIC
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