Mysql query to return server load average

Does anyone know of a MySQL query that returns the server's cu开发者_如何学JAVArrent load average?

Do you mean the actual system load average? This has nothing to do with MySQL. For example on Linux, you can get it from /proc/loadavg.

Correct me if I'm wrong, but the load average variable is a property of the machine, not the MySQL server. So to retrieve the avg. load you should be looking for a system call, not a SQL-query.

You might want to look into this statement:
http://dev.mysql.com/doc/refman/5.1/en/show-status.html

SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr]

SHOW STATUS provides server status information. This information also can be obtained using the mysqladmin extended-status command. The LIKE clause, if present, indicates which variable names to match. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 20.28, “Extensions to SHOW Statements”. This statement does not require any privilege. It requires only the ability to connect to the server.

Do you have mytop installed?

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server

Mytop allows you to monitor what is happening in real time, everything from number of queries per second to key efficiency of the queries.

See Using Mytop: A MySQL Monitor