Database size in mysql

database_size.sql

SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

show variables where variable_name = 'general_log';
set global general_log = 0;

select count(*) from mysql.general_log;
select count(*) from mysql.general_log_backup;
select count(*) from mysql.slow_log;
select count(*) from mysql.slow_log_backup;

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = "mysql" AND TABLE_NAME LIKE "%log%";

CALL mysql.rds_rotate_slow_log;  -- http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html
CALL mysql.rds_rotate_general_log;