[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: PNG File load-year.png     PNG File mysql-year.png    

 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
there are not much slow queries, or anything I can see from processlist. I assume e.g. optimizer uses more cpu but not noteable on a single query. At the moment this does not affect me much - but the higher cpu load can be observed. But I don't have a good clue how to give you more (relevant) information.

Generated at Thu Feb 08 10:07:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.