Advanced Search

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