Page 1 of 1

Server statistics

Posted: Mon 22 Dec 2008 12:57
by PhilNS
I was hoping to read some decent MySQL Server statistics using TMyServerControls so my program can keep a general eye on what’s going on and I ask a user to take a look if things do start playing up!

The variable ‘Uptime’ returns a string value in second, but what do some other useful values return?
Connections
Open_files
Open_tables
Opened_tables
Threads_connected
Slow_queries

I have tried variants as well as standard types and they all cause violations.

Is there a better way of showing all the server variables such as filling a string list in a memo component that way I can get the user to read off any number of useful facts?

Thanks for your help and a great set of components.

Posted: Mon 22 Dec 2008 13:46
by Dimon
To view TMyServerControl.ShowStatus variables you can display data in the DBGrid component.
You can find detailed information about these variables in MySQL Reference Manual.