Review main Abandoned

95351[TASK] Speed up MySQL functional database resets

Wouter Wolters CR 0 V 0 Easy +25 −22 updated 09/04/26, 14:15

Commit message

Functional test cleanup truncates every touched MySQL and MariaDB table. TRUNCATE performs expensive DDL even for tables without an auto-increment column, where no sequence state needs to be restored.

Delete rows from populated tables without auto-increment instead and retain TRUNCATE when the counter must restart. MySQL can omit the current counter for populated auto-increment tables, so inspect the column metadata before selecting DELETE.

For Extbase RelationTest, this reduces the MariaDB 10.4 runtime from about 63.3 to 57.3 seconds and the MySQL 8.4 runtime from 112.1 to 100.1 seconds. The complete MariaDB functional suite passes with 12,523 tests and 73,326 assertions.

Review

  • Code review CR 0
  • Verified V 0
    • core-ci +1 CI

Files 2

Review log 23

  1. Wouter Wolters uploaded patch set 1 08/17/26, 13:02

  2. core-ci voted on patch set 1 V +1 08/17/26, 13:08 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/106828

  3. Wouter Wolters abandoned the change 09/04/26, 14:15

    will be updates in another change