Skip to content
David Kittell
David Kittell

Application & System: Development / Integration / Orchestration

  • Services
    • Application Development
    • Online Application Integration
  • Code
  • Online Tools
  • Tech Support
David Kittell

Application & System: Development / Integration / Orchestration

MySQL Server Information

Posted on September 11, 2015 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.

Related

Code MySQL SQL

Post navigation

Previous post
Next post

Related Posts

PowerShell – Lock Workstation

Posted on November 9, 2015November 9, 2015

This is a great script to add to a setup script to lock the workstation after everything is done or before everything starts Function Lock-WorkStation { $signature = @" [DllImport("user32.dll", SetLastError = true)] public static extern bool LockWorkStation(); "@ $LockWorkStation = Add-Type -memberDefinition $signature -name "Win32LockWorkStation" -namespace Win32Functions -passthru $LockWorkStation::LockWorkStation()…

Read More

RedHat – Search/Join/Leave Microsoft Active Directory (AD)

Posted on September 9, 2016

This script will assist in searching for, joining or leaving a Microsoft Active Directory (AD). While this is specifically written and tested for Red Hat you should be able to do it with Fedora or CENTOS without changing anything. If you are on a different distro like Ubuntu it will…

Read More

PowerShell – Ping Subnet

Posted on November 9, 2015

#requires -Version 2.0 Function Ping-Subnet { #.Synopsis # Ping a subnet returning all alive hosts. #.Example # Ping-Subnet -IP 192.168.1.0 -Netmask /24 #.Example # Ping-Subnet -IP 192.168.1.128 -Netmask 255.255.255.128 Param( [string] $IP, [string] $netmask ) Begin { $IPs = New-Object System.Collections.ArrayList $Jobs = New-Object System.Collections.ArrayList $max = 50 Function Get-NetworkAddress…

Read More

Code

Top Posts & Pages

  • PowerShell - Rename Pictures to Image Taken
  • Front Page
  • PowerShell - IIS Remove Site
  • SQLite - Auto-Increment / Auto Generate GUID
  • PowerShell - FTP Upload Directory With Sub-Directories

Recent Posts

  • Javascript – Digital Clock with Style
  • BASH – Web Ping Log
  • BASH – Picture / Video File Name Manipulation
  • Mac OSX Terminal – Create SSH Key
  • Bash – Rename Picture

Top Posts

  • PowerShell - Rename Pictures to Image Taken
  • PowerShell - IIS Remove Site
  • SQLite - Auto-Increment / Auto Generate GUID
  • PowerShell - FTP Upload Directory With Sub-Directories
  • Raspberry Pi - Remove Default Apps
  • PowerShell - Change Windows CD/DVD Drive Letter
©2025 David Kittell | WordPress Theme by SuperbThemes