Bug #43914 | delayed-file param / a function to execute group of statements in another thread | ||
---|---|---|---|
Submitted: | 27 Mar 2009 15:30 | Modified: | 30 Mar 2009 13:21 |
Reporter: | Serdar S. Kacar | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: General | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[27 Mar 2009 15:30]
Serdar S. Kacar
[29 Mar 2009 11:05]
Valeriy Kravchuk
I think all these (and more!) can be done using events in 5.1+. Please, check http://dev.mysql.com/doc/refman/5.1/en/events.html.
[30 Mar 2009 13:20]
Serdar S. Kacar
> I think all these (and more!) can be done using events in 5.1+ Right. But there are some uncertainaties also. Excerpt from "Event_scheduler::execute_top()" : /* TODO: should use thread pool here, preferably with an upper limit on number of threads: if too many events are scheduled for the same time, starting all of them at once won't help them run truly in parallel (because of the great amount of synchronization), so we may as well execute them in sequence, keeping concurrency at a reasonable level. */ If someone decides to "execute them in sequence" , tasks that can take long times could block other events. Otherwise, I concur that function I mentioned before is fully covered by EVENTs.
[30 Mar 2009 13:21]
Serdar S. Kacar
.