Check database size in MySQL
SELECT table_schema "Database Name", sum( data_length + index_length ) / 1024 / 1024 "Database Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;
Create a scheduled event for regular execution
-- shows event scheduler thread if active
show processlist
-- enabled event scheduler (if not active before)
SET GLOBAL event_scheduler = 1;
-- dummy table for testing
CREATE TABLE event_test (
val varchar(100) not null primary key
);
-- Actual event and schedule, documentation here
-- http://dev.mysql.com/doc/refman/5.1/en/create-event.html
CREATE EVENT IF NOT EXISTS event_test_evt ON SCHEDULE EVERY 1 MINUTE DO
INSERT INTO event_test (val) VALUES (date_format(NOW(), '%Y-%m-%d'));
-- drop event event_test_evt;
-- SET GLOBAL event_scheduler = 0;