[MDBF-142] Upgrade the MariaDB version used by the new buildbot Created: 2020-09-28 Updated: 2022-02-05 Resolved: 2022-02-05 |
|
| Status: | Closed |
| Project: | MariaDB Foundation Development |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Vlad Bogolin | Assignee: | Vlad Bogolin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | 0d | ||
| Time Spent: | 1h | ||
| Original Estimate: | 0d | ||
| Issue Links: |
|
||||||||||||
| Description |
|
The current version used by buildbot is 10.1. While investigating an issue with buildbot interface being unresponsive during log cleanup (which involves a massive delete operation that freezes the log tables), Vicentiu suggested that an upgrade of the MariaDB server used by the buildbot may help in speeding up this operation. |
| Comments |
| Comment by Daniel Black [ 2020-12-01 ] |
|
Why did it freeze? Was there concurrent operations that where in lock wait? Was the delete using an index? Was the innodb log buffer and log file sufficient to include the delete? |
| Comment by Vlad Bogolin [ 2020-12-07 ] |
|
A large delete was responsible for blocking other operations. Vicentiu looked on the configurations and said that everything looks good. By making multiple smaller deletes everything seems fine. |