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;