This is an old revision of the document!


MySQL

Gotchas

mysqladmin flush doesn't display output

Running mysqladmin flush may not be working – check the mysqld error log for results!

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;