[MDEV-16041] Do not write for null update (properly fix MySQL Bug#29157) Created: 2018-04-26 Updated: 2018-04-26 Resolved: 2018-04-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 5.5, 10.0, 10.1, 10.2, 10.3 |
| Fix Version/s: | 10.2.15, 10.3.7 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marko Mäkelä | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | performance, upstream | ||
| Issue Links: |
|
||||||||
| Description |
|
monty noted that InnoDB takes a lot of time to perform null updates. The reason is that even though an empty update vector was created, InnoDB will go on to write undo log records and update the system columns DB_TRX_ID and DB_ROLL_PTR in the clustered index, and of course write redo log for all this. This could have been fixed properly when MySQL Bug #29157 was addressed over 10 years ago. |