Monthly Archives: August 2011

MySQL partitions

Have a short look at mysql partitioning. Useful to handle large databases, you can even store partitions on different devices. I want to partition data on a (presumed to be) large table by timestamp, more precise I want a partition … Continue reading

Posted in mysql | Leave a comment

MySQL event scheduler

Pretty cool thing, the mysql event scheduler. Cron jobs inside MySQL. The MySQL event scheduler is off by default, you can switch it on by calling SET GLOBAL event_scheduler = ON; You could event do some automatic drop table if … Continue reading

Posted in mysql | Leave a comment