Show Status

[aaron_karp]

If I want to display the resuts of the SHOW STATUS SQL command on my PHP page, how would I accomplish this? I assume that I can't just run it like a normal SQL query, can I? If so, how do I retrieve the results?

The mysql functions I've found, such as mysql_stat, are not complete enough.

Thanks.

[rachel2004]

The following works under Linux. Haven't tested it on Win32, though:

<?php 

echo exec("/usr/local/mysql/bin/mysqladmin status -u username --password=my_password");

?>

[aaron_karp]

Good call with the exec. Thanks Rachel.

[rachel2004]

You're welcome, Aaron.

[aaron_karp]

If I wanted to run something more complex like:

STATUS;SHOW FULL PROCESSLIST;SHOW TABLE STATUS;

How would I do that?