This is an old revision of the document!
MySQL
MySQL is our database server.
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;