Event Scheduler – the classification.

MySQL Server derives its own CRON from version 5.1.6. It is a relevant mechanism like DBMS_SCHEDULER | DBMS_JOB in Oracle or CRON on unix. This feature is perfect for DBA. I use it once it was introduced but now the time has come to classify them conforming to their function.
1. Maintenance (OPTIMIZE, ANALYZE, etc.);
2. ETL (fulfill new structures with extracted data, e.g. ROLAP);
3. Data Modification (operations DML on data conforming to your data flow model);
4. Archiving (moving data into archive tables);

Now, I can use the prefix for the event for better administrating.
1. Maintenance – mntn_;
2. ETL – etl_;
3. Data Management dm_;
4. Archiving – arch_

  1. No comments yet.

  1. No trackbacks yet.