Getting some data from mysql

[tschitschi]

Don't knwo wheter to post it here or in the MySQL forum. If I'm wrong, please do move the thread.

I'd be happy if anyone could tell me, how do I get a number of things out of my vB mysql database (into a php script):

1. number of records in the database (not in a table) and the disk space they use
2. MegaBytes, which could be freed by optimizing all tables of the database
3. database traffic since last reboot (overall, in, out)
4. query cache + query cache allocation (in MB) (how may queries are in the cache)
5. cache efficiency (hitrate) in percent
6. key buffer + key buffer allocation (in MB)
7. buffer efficiency (hitrate) in percent

It would be great if someone can answer this questions!

Thanx in advance, Gigi.

[tschitschi]

numbers 1,2,6,7 still missing. figered out the other stuffe by myself