MySQL DBA Scripts
- MySQL: Script to check the size of Database and Tables
- MySQL: Script to find all the Tables without having a Primary Key
- MySQL: How to Install MySQL 5.7 on Ubuntu 16.04?
- MySQL: Script to find Missing Indexes for particular type of Columns
- MySQL: Script to find Long Running Queries and Transactions
- MySQL: Script to find Largest Databases size on Server
- MySQL: Script to find total occupied Size of each Storage Engines
- MySQL: Using SQL Query Profiler finds total execution time and CPU information of the Queries
- MySQL: Script to find default Character Set for Database, Table and Column
- MySQL: Script to find last Updated time of the Table
- MySQL: Script to identify the locks and blocking transactions
- MySQL: Script to find Last AUTO_INCREMENT value for a Table
- MySQL: Script to find Source and Destination of All Foreign Key Constraint
- MySQL: ERROR 1130: Host is not allowed to connect to this MySQL server
- MySQL: Backup and Restore Database using mysqldump
- MySQL: Script to determine the size of innodb_buffer_pool_size
- MySQL: How to Log General and Long Running Queries into Log Table
- MySQL: Script to find Index Usage Statistics of a Database
- MySQL: Import and Export CSV data with Headers
- Delete all duplicate rows in MySQL
- Important MySQL and Ubuntu Console Commands
- Find top N records for each group in MySQL
- Find Table Dependency in MySQL
- Find any text into Stored Procedure and Function of MySQL
- Determine free and occupied size of Tables and Database into MySQL
- Script to Find and Kill Running Process in MySQL
- Insert script for all Countries
