Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
This is a feature request (Mr Daniel Black suggested filing it with you.)
Please add some system variables (readonly) describing the host machine upon which the MariaDB server runs.
Why? They make server tuning easier and more accessible.
I suggest adding these.
- host_memory int showing total RAM in GiB. See this for the web browser version. https://developer.mozilla.org/en-US/docs/Web/API/Navigator/deviceMemory
- host_concurrency int showing the number of cores / threads available. See this for the web-browser version. https://developer.mozilla.org/en-US/docs/Web/API/Navigator/hardwareConcurrency
- host_speed integer showing speed of fastest host core in MHz.
- host_arch string describing host architecture "x64", "arm64" Like this. https://nodejs.org/api/os.html#osarch
- host_platform string describing the host platform. "linux", "win43", "freebsd" ... Like this. https://nodejs.org/api/os.html#osplatform
- host_os string describing the host OS
These should be GLOBAL STATUS items – they change.
- host_loadavg_1 floats showing the familiar linux load averages
- host_loadavg_5 ...
- host_loadavg_15 ...
"hostname" is already in a system variable. Some of these could also be system variables rather than global status items.
Also, you probably should add a system variable "hoststatus" (ON/OFF, default ON) to allow server operators to conceal all the above information.