MySQL Server Information

Posted on By David Kittell 
SHOW VARIABLES;

SHOW STATUS;

select version();

SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc.
SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc.

References: http://stackoverflow.com/questions/3939803/how-to-get-mysql-server-info-using-command-line

All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MySQL SQL

Related Posts

C# Application Form Closing Event Question

Posted on

Sometimes you have a program that you would prefer someone not close without confirming they truly meant to close it. This script will assist in providing a question before the program simply closes. private void fm1_FormClosing(object sender, FormClosingEventArgs e) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to close?",…

Read More

Get User Details Function

Posted on

— Get User’s First Name, Last Name SELECT dbo.GetUserDetails(120, 1) — Get User’s Last Name, First Name SELECT dbo.GetUserDetails(120, 4) — Get User’s Username SELECT dbo.GetUserDetails(120, 2) — Get User’s Email Address SELECT dbo.GetUserDetails(120, 3) IF OBJECT_ID(N’dbo.GetUserDetails’) IS NOT NULL DROP FUNCTION dbo.GetUserDetails GO CREATE FUNCTION dbo.GetUserDetails ( @userid INT…

Read More