Date: 04/11/05 (MySQL Communtiy)    Keywords: mysql, sql

I've finally put together a code-based load balancing scheme for distributing server load to a pool of slaves. The issue I'm up against now is a way to poll the slaves to see which has the lowest load, and there doesn't seems to be a standard simple MySQL command to report that.

I'd like to keep the methods confined to SQL commands that can be executed via remote connections. The only option I can see at the moment is do "show processlist" and filter it to see the number of currently executing queries and get the average execution time, though that seems to be a bit "heavy".

I haven't seen anything in show status or the like that shows something as basic as server load.

I'm sure this has been covered before but I haven't been able to find any references. Any ideas?

Source: http://www.livejournal.com/community/mysql/53451.html