MySQL

Howtos

Change update_date timestamp automatically
ALTER TABLE `table` CHANGE `update_date` `update_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
Show database sizes
SELECT table_schema AS db, (SUM(data_length + index_length) / 1024 / 1024) AS mb FROM information_schema.tables GROUP BY table_schema;