Event Scheduler

Code Ape Tech Column

Jan 12, 2024 · Databases

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

This article explains MySQL event scheduler fundamentals, including enabling/disabling the scheduler, creating, altering, and dropping events, scheduling syntax, and practical examples such as generating real-time sales data and periodic statistics, providing code snippets and best‑practice guidance for database automation.

Data GenerationDatabase AutomationEvent Scheduler

0 likes · 9 min read

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

Selected Java Interview Questions

Jan 6, 2024 · Databases

MySQL Event Scheduler: Concepts, Operations, and Practical Examples

This article explains MySQL event scheduler fundamentals, its advantages, common commands for managing events, detailed syntax for creating events, and provides practical examples such as generating real‑time sales data and scheduled statistics, helping developers automate repetitive database tasks.

Data GenerationDatabase AutomationEvent Scheduler

0 likes · 10 min read

Aikesheng Open Source Community

Jul 5, 2023 · Databases

Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch

This article explains the MySQL event_scheduler thread, why killing it during master‑slave failover produces an "Unknown thread id" warning in MySQL 8.0, how to manage events, and the impact of these internal daemon sessions on replication and failover processes.

Database AdministrationEvent SchedulerMaster-Slave Switch

0 likes · 15 min read

Understanding MySQL Event Scheduler and Why Its Connections Cannot Be Killed During Master‑Slave Switch

Aikesheng Open Source Community

Feb 21, 2021 · Databases

Using MySQL Events and Stored Procedures to Monitor InnoDB Lock Waits

This article explains how to replace shell‑script based lock‑wait monitoring with MySQL Event and Stored Procedure mechanisms, showing step‑by‑step creation of a monitoring database, procedure, scheduled event, and how to interpret the generated lock‑wait log table for troubleshooting.

Event SchedulerInnoDBMySQL

0 likes · 6 min read

Using MySQL Events and Stored Procedures to Monitor InnoDB Lock Waits

Tencent Database Technology

Oct 24, 2019 · Databases

Analysis of MySQL Event Scheduler: Architecture, Heap Algorithms, and Bug Fixes

This article examines MySQL's event scheduler architecture, detailing its core classes, execution flow, heap insertion and deletion algorithms, and investigates two critical bugs—slow‑log misrecording and delayed event execution—while proposing concrete fixes to improve reliability.

Bug FixDatabase InternalsEvent Scheduler

0 likes · 16 min read

Analysis of MySQL Event Scheduler: Architecture, Heap Algorithms, and Bug Fixes