I recently reinstalled Manjaro and wanted a simple way to monitor system performance. I created a script that calculates Pi for a brief period and logs the completion time. This time was consistently between 16 and 18 seconds for several months.
Here the script:
On March 11th, I had trouble installing and configuring MySQL/MariaDB. I also made some changes to PHP settings and possibly other system configurations. Unfortunately, I wasn’t careful in documenting all the changes I made, and my history file seems incomplete.
After these changes, my performance script now shows a slower completion time (around 25 seconds).
If I can’t find a easy way to bring perfance back like it was before, I think I will reinstall again my machine.
Before reinstalling, I’d like to ask for advice on how to troubleshoot the performance issue. What specific things should I check or reinstall to try to fix the slowdown?
As @linux-aarhus said, the database specifically does not come cheap, and like he also said, combined with Apache and PHP it can be heavy on a system. Especially considering it’s 3 server grade applications running constantly. Whether they are actively in use or not.
To confirm it’s them, you can stop them and run your test:
By all means reinstall your system for the sake of a few seconds. That is what a typical Windows user might do when faced with an equally insummountable dilemma…
Or, if you really must save those precious few seconds, consider creating a script to start the respective services manually; when you need them. In this way, your system will not be affected by the additional overhead during boot.
Well this is a performance drop from 40%. I would certainly investigate. Probably just the database if it is a big thing, frequently accessed.
If half of your cpu time is taken from some process you would also be able to see it with some process monitor, be it top or gnome-monitor.
MariaDB is not causing that unless it’s being heavily used. If it’s not being used then there should be no impact on your system. Use ps -ef --sort +time to see what is using cpu time.
This (“no” meaning “negligible”).
RAM usage however might always be a problem even when that mariadb isn’t queried/taxed alot.
Also you did not share any system information, see
(“no” meaning “negligible”).