Server statistics

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
PhilNS
Posts: 2
Joined: Tue 09 Dec 2008 14:34
Location: Coventry, England

Server statistics

Post by PhilNS » Mon 22 Dec 2008 12:57

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.

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 22 Dec 2008 13:46

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.

Post Reply