CPU high usage after mariadb upgrade 10.11

You PHP-FPM is what has the load from your screenshots.

I think your server is messed up, PHP-FPM should NOT show up on a dnf update, this is built by CWP.

So I'm guessing you installed PHP and MariaDB on their own and not from CWP.

So you have LAMP installed before CWP, which is advised not to do as it can corrupt the server.

Your best option is redo the server WITHOUT LAMP, just the basic image from your provider.

Then let CWP install everything, and then compile PHP from within CWP, not the PHP repos.

After CWP has installed everything, then you can upgrade MariaDB following one of the guides out there, like:
https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-in-cwp-on-almalinux-8/

But if this is a new server, best bet is to use the AlmaLinux 9.x (usually 9.4) image for the provider.

If you want, you can do the reimage, and I can login to the bare system and get everything installed for you.
Just PM your server details.