![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png){kind=logo}
Opened 11 years ago
Closed 17 months ago
#35109 closed enhancement (wontfix)
Add Online DDL support to dbDelta
| Reported by: | pento | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | Database | Version: | |
| Severity: | normal | Keywords: | needs-patch needs-unit-tests |
| Cc: | Focuses: | performance |
Description
Since MySQL 5.1, a bunch of table level operations can be done in an asynchronous manner.
We can add support for this by adding ALGORITHM=INPLACE to the ALTER TABLE query, but the fun part is that this algorithm isn't supported for all types of operations.
So, we have a couple of options:
- Keep an array of what operations can be done online in each MySQL and MariaDB version, which will need to be updated for each new version of MySQL.
- Try all
ALTERqueries with the algorithm flag, then catch any SQL errors and fall back to the old style if needed. This will need careful testing with old versions of MySQL, particularly.
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-index-overview.html
Change History (5)
This ticket was mentioned in Slack in #core by chriscct7. View the logs.
10 years ago
Note:
See TracTickets
for help on using tickets.
@pento should this be punted, maybe early, to a future release?