Warning: The system load average is 22.28

[fabioweb90]

Hello, i'm looking about system load average issue and i found this on log
i have a PID 7481 is going to use 80% of CPU
How can i fix this error or what i have to do in order to understand more about this?
Thanks for any suggestion

 

[factor]

In the highlighted section the --log-errors= list the location of the error log file. You can start there.
Also have you tried restarting the mysql server?

high cpu doest mean a problem always could be the site is real busy or the server is under powered.

More info would be needed to help more.

 

[fabioweb90]

Hello! thanks for suggestion i see /var/lib/mysql/server.piucommerce.com.err is 28MB and this is what i found searching for PID 7481

image

Image image hosted in ImgBB

ibb.co

Can i also attached all file if you want and if is possible to share this info..
Regards

 

[factor]

You are on a really old MariaDb version
Also see some reports of missing Tablespaces. You might want to export your db for safe keeping.

Did you try restarting with
systemctl restart mysqld

Also those error go back to February might clean the log and check it in a few days.

 

[fabioweb90]

Okay thanks you right i'm looking for MariaDb upgrade with CustomBuilds 2.0 where i have following settings

image

Image image hosted in ImgBB

ibb.co

Is it safe to update in this way? https://ibb.co/MsSJqp3

 

[factor]

Make sure you backup the dbs


No you cant jump all the way. You have to go in order.

MariaDB udpate

Hi :) Can I update MariaDB 5.5.41 to MariaDB 10 in Direct Admin Custombuild 2.0 ? Same question for phpMyAdmin 4.9.7 update to 4.9.10. Thank You :)

forum.directadmin.com

 

[fabioweb90]

Oky great this means i have to choose 10.1

image

Image image hosted in ImgBB

ibb.co

then save

Choose 10.2 https://ibb.co/g93Y1Vj
save again and go ahead.
Am i right?

Regards

 

[Richard G]

That only changes the choice you want to make. After every time you save, you also have to use the update software option.

 

[fabioweb90]

Ah ok if i understand correctly if i switch to 10.4 example
once i create a new website this will have DB version 10.4 and already existing will have version 10.0. Am i correct?

 

[jhona]

 

[Zhenyapan]

already existing will have version 10.0. Am i correct?

no, you have only one Mysql service in system, so it will be upgraded and all databases will be upgraded too.

 

[fabioweb90]

Ok thanks all clear.
Is it also suggested upgrade MariaDB first or PhpMyAdmin?
Currently i have MariaDB 10.0.38 on direct admin 4.9.7

 

[Active8]

It doesn't really mathers I think but I would go for the SQL > PhpMyadmin path

 

[factor]

MariaDB first

This

Make a backup and keep it off site as well as on the server.

 

[fabioweb90]

Sorry i forgot to ask. Before going to upgrade is it suggested to stop any services?
Regards

 

[Ohm J]

it's good thing to stop httpd before upgrade SQL server, It can prevent data missing. if you have high load website that use with SQL.

Imagine, there have customers Topup on your website, but you suddenly restart mysql server, this will possible make Fail Transaction.

 

[fabioweb90]

Ok perfect you right. So in the end
1) Set websites in maintenance mode
Since my current version is MariaDB 10.0 i have to go step by step with following command
2)
cd /usr/local/directadmin/custombuild
./build update
./build set mysql_backup yes
./build set "mariadb" 10.1 (then 10.2 and go ahead)
./build set mysql_inst "mariadb"
./build "mariadb"

Any other suggestion?

Thanks for the moment

 

[Active8]

./build "mariadb" is wrong use :

./build mariadb

 

[fabioweb90]

Ah ok perfect thanks. Instead here is correct?
./build set "mariadb" 10.1

 

[Richard G]

No the same. Don't use these apostrophe's.

Or just edit options.conf and change version to 10.1 there and run ./build update after saving, also works.