Posted By

zonetrooperex on 03/21/10


Tagged

mysql administration admin


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

megadeth_tom
virendrakryadav


MySQL Administation Snippet


 / Published in: MySQL
 

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

  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  

You need to login to post a comment.