Advanced Search

MySQL Administation Snippet

/ Published in: MySQL
Save to your folder(s)
Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. /* MYSQL Administration Tools */
  2.  
  3. /* Variables */
  4. #SHOW GLOBAL VARIABLES;
  5. #SHOW SESSION VARIABLES;
  6.  
  7. /* Database Objects */
  8. #SHOW TABLES;
  9. #SHOW TRIGGERS
  10. #SHOW PROCEDURE STATUS;
  11. #SHOW FULL PROCESSLIST;
  12.  
  13. /* Debugging */
  14. #SHOW COUNT(*) WARNINGS;
  15. #SHOW WARNINGS;
  16. #SHOW GLOBAL STATUS;
  17. #SHOW ENGINE INNODB STATUS;
  18. #SHOW ERRORS;
  19.  
  20. /* End */

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.