[MDEV-26930] Update is taking too much time after migrating to mariadb Created: 2021-10-28 Updated: 2021-12-05 Resolved: 2021-12-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Update |
| Affects Version/s: | 10.6.4 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Suhas Kumar | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Description |
|
After migrating from mysql 5.7 to mariadb 10.6.4 the normal update which used to finish in seconds is now taking 5-8 minutes and live transactions are not getting updated. After sometimes we face timeout error and again we need to kill older sesssions and start again. It is impacting our busines please help me. |
| Comments |
| Comment by Daniel Black [ 2021-10-29 ] |
|
Can you include a `show processlist` while this is happening to see what SQL is in progress? |
| Comment by Daniel Black [ 2021-10-29 ] |
|
When you see some long running queries. Use show explain for <thread_id?> to capture what its doing. |