[MDEV-29272] Performance regression Created: 2022-08-08 Updated: 2023-09-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.5.16 |
| Fix Version/s: | 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Marc | Assignee: | Axel Schwenke |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
| Description |
|
Since update from 10.5.15 to 10.5.16 I can see ~double of cpu usage while the questions to the server are equal. |
| Comments |
| Comment by Sergei Golubchik [ 2022-08-10 ] |
|
any other info you can provide? like, what are the sql statements that cause it? |
| Comment by Marc [ 2022-08-26 ] |
|
As you can see, the load on the machine changes by mid of june. This is the time when the new release was installed: While the workload by queries is "constant": There was no change in the webapps using the database. |
| Comment by Sergei Golubchik [ 2022-08-27 ] |
|
Unfortunately, it doesn't help much, this simply repeats what you said above, "update from 10.5.15 to 10.5.16 I can see ~double of cpu usage". What kind of sql statements do your webapps use? Can you show an example of a statement that use more CPU or take longer after the upgrade? May be a general query log or SHOW PROCESSLIST could help to get a sample of the load. |
| Comment by Marc [ 2022-08-29 ] |
|
maybe this is all caused by #27883 |