tschitschi
09-29-2004, 10:40 AM
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):
number of records in the database (not in a table) and the disk space they use
MegaBytes, which could be freed by optimizing all tables of the database
database traffic since last reboot (overall, in, out)
query cache + query cache allocation (in MB) (how may queries are in the cache)
cache efficiency (hitrate) in percent
key buffer + key buffer allocation (in MB)
buffer efficiency (hitrate) in percent
It would be great if someone can answer this questions!
Thanx in advance, Gigi.
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):
number of records in the database (not in a table) and the disk space they use
MegaBytes, which could be freed by optimizing all tables of the database
database traffic since last reboot (overall, in, out)
query cache + query cache allocation (in MB) (how may queries are in the cache)
cache efficiency (hitrate) in percent
key buffer + key buffer allocation (in MB)
buffer efficiency (hitrate) in percent
It would be great if someone can answer this questions!
Thanx in advance, Gigi.