user654123 user654123 - 28 days ago 16
MySQL Question

MySQL query for system specs such as installed RAM or CPUs

I'd like to retrieve information about the system a MySQL server is running on. I am interested in getting the number of logical cores. Is that possible?

I ran

SHOW VARIABLES;
but there is no such info there. I am having access to the server using
PDO
- is there a way to retrieve metadata from the connection or a statement that might hold this kind of data?

Edit: I should probably add the information that the two systems MySQL-Server and Client (which uses PHP from another host) are two physically separated systems, so I only have access via MySQL-queries.

Answer

So, I was doing a little more research on the topic and as of today (Nov '16), it can't be done the way I had required it.