dbrowse

Brief Server Status

This node is informative, descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Node/View

[skip to the dbrowse Navigation information]

Synopsis

This is a brief server status report for the current database.

Description of Results

This page represents the same information you would receive if you ran the mysql> status command from the MySQL client program, sometimes called the “terminal monitor”, or just monitor, from the command line of your server. Note that this is the most common method of doing this, but you can connect to the server from other machines that are configured to do so—hence the term client program. See the MySQL Tutorial, and in particular the section on Connecting for more information on using this program.

Also, I have augmented the results with a few extra variables for your convience, and of course the results are much easier to access from here and are easier to read and understand since I’m also providing documentation of the values from this dbrowse view.

For detailed documentation regarding the information displayed on this page, visit the MySQL Reference Manual section on Server Status Variables. Brief descriptions are listed below, some of which have links to more specific sections of the manual. The Extended Server Status and Server Variables views of this application will display a much greater number of these server variables and their values.

MySQL Terms

Thread ID

The reference ID for the current connection. This is similar to a process ID under most multi-tasking operating systems. MySQL supports many simultaneous connections/threads.

Server Version

The version number of the MySQL server program.

Client Version

The client library version number. The monitor program, as discussed above, is only one of many clients that may connect to the server. By using PHP to do the same, and display these results, I am also acting as a client. Each of them are using a common library of software routines to accomplish this interaction. I could use any number of other programming languages, such as C or Perl, to do the same thing.

Protocol Version

This is the MySQL network protocol version used for connection and communication between clients and the server. An excellent document on this topic with many details is available at Ian Redfern’s MySQL Protocol.

Connection

The connection parameters between the client and the server. First the host and then the method. In this case localhost, meaning the client and the server are on the same machine, and Unix socket. See What is a Socket? for more information. If the MySQL server was on a remote host, then I would be communicating with it over a TCP/IP network connection instead, usually through port 3306. Programmers interested in the API for client connections can find details at the documentation on the C mysql_real_connect() library function.

Unix Socket

The location of the Unix socket file. The one shown here also happens to be the default.

Database

The database we’re connected to.

User

The username used to connect. Normally a password would also be associated with this parameter.

Server Timestamp

The date and time on the host computer.

Character Set

The character set used by the MySQL server.

Uptime

How long the server has been running. Internally this is maintained in seconds, which isn’t very friendly—especially if the the server has been running for a long time! So I’ve converted it to a format typical of the BSD Unix uptime(1) program.

Threads

Number of concurrent threads.

Total Queries

How many queries the server has processed since it was started (uptime).

Slow Queries

The number of queries that have taken longer than long_query_time seconds to execute. Any tables that generate slow queries are candidates for optimization.

Opened Tables

The number of tables that have been opened since the server started.

Flush Tables

Under certain circumstances a database administrator may need to clear internal caches and reload data from a table. This is a count of how many times this has been done since the server was started.

Open Tables

Currently opened tables.

Average Queries Per Second

A simple statistic: total queries/uptime (in seconds).

Note: Regarding the Server Timestamp in this view: I have formatted it according to the localtime/TZ on this host, and in preference to my Language. This is easily modified if you wish to use or adapt this application for your own purposes.

Navigation

This is a terminating view in one query path for the active database. You may use your Web browser to return to the previous view for other routes to follow.