Return to Snippet

Revision: 25155
at March 21, 2010 23:18 by zonetrooperex


Initial Code
/* MYSQL Administration Tools */

/* Variables */
#SHOW GLOBAL VARIABLES;
#SHOW SESSION VARIABLES;

/* Database Objects */
#SHOW TABLES;
#SHOW TRIGGERS
#SHOW PROCEDURE STATUS;
#SHOW FULL PROCESSLIST;

/* Debugging */
#SHOW COUNT(*) WARNINGS;
#SHOW WARNINGS;
#SHOW GLOBAL STATUS;
#SHOW ENGINE INNODB STATUS;
#SHOW ERRORS;

/* End */

Initial URL


Initial Description
Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)

Initial Title
MySQL Administation Snippet

Initial Tags
mysql

Initial Language
MySQL