MySQL Forums - Events (Job Scheduler)

Events and stored procedures (no replies)

Robert Hairgrove — Sat, 04 May 2013 10:37:54 +0000

I already posted this question in the MySQL Docs forum, but thought more people might read it here. Although the sample code SEEMS to work OK, I'm mostly worried that there might be some kind of undefined behavior going on here because the documentation is so clear about stating that it really shouldn't work at all.

We are using MySQL 5.1.69, and I'm a little confused about this bit from the documentation concerning events:

"An event may not be created, altered, or dropped by a stored routine, trigger, or another event. An event also may not create, alter, or drop stored routines or triggers. (Bug #16409, Bug #18896)"
http://dev.mysql.com/doc/refman/5.1/en/stored-program-restrictions.html#stored-routines-event-restrictions

But I have seen numerous instances on the web which give code examples of stored procedures which contain ALTER EVENT statements. When I tried this myself, it seemed to work OK:


CREATE DATABASE IF NOT EXISTS mydb;
USE mydb;

CREATE TABLE IF NOT EXISTS mydb.test_event ( 
id int(11) NOT NULL AUTO_INCREMENT, 
dummy varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'x', 
PRIMARY KEY (id) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

DELIMITER // 

CREATE EVENT mydb.event_test 
ON SCHEDULE EVERY 5 SECOND 
ON COMPLETION PRESERVE 
DISABLE 
DO insert into mydb.test_event (dummy) VALUES ('x'); 
// 

CREATE PROCEDURE mydb.enable_event() 
MODIFIES SQL DATA 
BEGIN 
ALTER EVENT mydb.event_test ENABLE; 
END// 

CREATE PROCEDURE mydb.disable_event() 
MODIFIES SQL DATA 
BEGIN 
ALTER EVENT mydb.event_test DISABLE; 
END// 

DELIMITER ; 

SET GLOBAL event_scheduler=ON;

-- verify that it is running:
SHOW PROCESSLIST;

-- output:
Id	User	Host	db	Command	Time	State	Info
105	phpmyadmin	localhost	NULL	Sleep	0	 	NULL
106	bob	localhost	mydb	Query	0	NULL	SHOW PROCESSLIST
107	event_scheduler	localhost	NULL	Daemon	0	Waiting on empty queue	NULL

CALL mydb.enable_event();

-- verify that the event is enabled:
SELECT * FROM test_event;

CALL mydb.disable_event();

set global event_scheduler=OFF;
SHOW PROCESSLIST;

I have a different user account which has only SELECT and EXECUTE privileges on mydb. Assuming that the event scheduler is running, now that user can turn the event 'test_event' on and off, which was the whole purpose of this exercise.

QUESTION: Does this work reliably? If so, why does this work if the documentation says it shouldn't?

Enabling Event scheduler gives "start: Job failed to start" error (no replies)

Brian Jasperson — Thu, 02 May 2013 16:08:50 +0000

I'm using mysqld Ver 5.5.22-0ubuntu1 for debian-linux-gnu on x86_64 ((Ubuntu)) under Ubuntu 12.04.1 LTS (GNU/Linux 3.2.0-24-generic x86_64). Updates are current.

I had two events that were working fine, and then a power outage knocked the server out. Since then, mysql will not start if event_scheduler=ENABLED in /etc/mysql/my.cnf:

# service mysql restart
mysql stop/waiting
start: Job failed to start

I dropped both events from the events table, and /var/log/mysql.err is completely empty.

Setting event_scheduler=DISABLED allows mysql to start fine.

Any assistance would be greatly appreciated.

MySQL auto update doesn't work (no replies)

joel trab — Mon, 01 Apr 2013 16:36:28 +0000

HI,

I'm trying to do an automatically update using MySQL events.

When I use datas from a single table, the update ends well, but when I use datas from other tables, the update doesn't work.

Here is my event code :
"delimiter |

create event test
on schedule every 1 minute
do
begin
declare p,g,b,pp,pg,pb,i,ap,ag,ab,np,ng,nb,ep,eg,eb INT;
declare done INT default 0;
declare c cursor for select IDVILLAGE, PIERRE, GOLD, BOIS, PRODPIERRE, PRODGOLD, PRODBOIS, EPIERRE, EGOLD, EBOIS from VILLAGE;
declare continue handler for sqlstate '02000' set done = 1;
open c;
repeat
fetch c into i,p,g,b,pp,pg,pb,ep,eg,eb;
select ab.NIVEAUAMEL into ap from AMELBAT ab, BATIMENTVILLAGE bv where ab.IDBAT=bv.IDBATVIL and bv.IDVILLAGE=iv and ab.IDAMELIORATION in (79, 82, 85);
select ab.NIVEAUAMEL into ag from AMELBAT ab, BATIMENTVILLAGE bv where ab.IDBAT=bv.IDBATVIL and bv.IDVILLAGE=iv and ab.IDAMELIORATION in (80, 83, 86);
select ab.NIVEAUAMEL into ab from AMELBAT ab, BATIMENTVILLAGE bv where ab.IDBAT=bv.IDBATVIL and bv.IDVILLAGE=iv and ab.IDAMELIORATION in (81, 84, 87);
set p = p+(1+(ap/20))*pp;
set g = g+(1+(ag/20))*pg;
set b = b+(1+(ab/20))*pb;
if p>ep then
set p=ep;
end if;
if g>eg then
set g=eg;
end if;
if b>eb then
set b=eb;
end if;
update VILLAGE set PIERRE=p, BOIS=b, GOLD=g where IDVILLAGE=i;
until done end repeat;
close c;
end |

delimiter ;"

Unable to find my.ini file to set variable event_scheduler = on (3 replies)

Preethi K — Thu, 13 Dec 2012 13:23:37 +0000

I'm using windows Os, mysql - v5.1.66.
The event scheduler does not seem to work after an restart of MYSQL server, After reading lot many posts, i learnt setting event_scheduler variable in my.ini file resolves the problem but, i searched a lot for the file in my system without any success.
Somebody help me please

EVENT with specific requirement (1 reply)

Robert Hilsenbeck — Wed, 05 Dec 2012 07:52:43 +0000

Hello everybody

I want to apply an daily csv data import with an EVENT.
Don't know if my requirement work in general.
I get a csv file at a not consistent time, so the EVENT should start when the file is available.
Is it possible to create a statement for this issue?
Thanks

Prepared Statement inside a Scheduled Event? (1 reply)

Ian Gates — Wed, 07 Nov 2012 08:47:26 +0000

Is there a limitation with using Prepared Statements inside a [scheduled] event.

I am trying to create an event that will rename a table at the start of each month, so it changes from 'tablename' to 'tablename_yyyymm' (e.g. tablename_201210). I have all the code, and on it's own it works fine, but when I test it in the Scheduled Event it seems to stop at 'EXECUTE stmt;'

My code is:
DELIMITER //
CREATE EVENT IF NOT EXISTS tableName_change
ON SCHEDULE
EVERY 1 MONTH STARTS '2012-12-01 00:00:00'
ON COMPLETION PRESERVE
COMMENT ''
DO
BEGIN

#Stop Replication
STOP SLAVE;

#If Month=Jan Use Last Year
SET @YearToUse = (
SELECT
CASE
WHEN MID(NOW(),6,2) = 1 THEN LEFT(NOW(),4)-1
ELSE LEFT(NOW(),4)
END AS YearToUse
);

#If Month=Jan Set Month to 12
SET @MonthToUse = (
SELECT
CASE
WHEN MID(NOW(),6,2) = 1 THEN 12
ELSE MID(NOW(),6,2)-1
END AS MonthToUse
);

#Name of new Table
SET @NewName = CONCAT('tablename_',@YearToUse,@MonthToUse);

#Rename Table to table_YYYYMM
SET @SQL = (CONCAT('RENAME TABLE tableName TO ',@NewName));
PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

#Create blank table
SET @SQL = (CONCAT('CREATE TABLE tablename LIKE ',@NewName));
PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

#Restart Replication
START SLAVE;

END //
DELIMITER;

EVENT not running HELP (no replies)

Darren White — Fri, 19 Oct 2012 11:02:43 +0000

I have used an event with event_scheduler many times not problem.....has been deactivated a while.....I now try start it and nothing is happening! Could be I have a new server version since I last tested it.

Server 5.5.28

set global event_scheduler=1;

DELIMITER $$

USE `ddd`$$
CREATE EVENT logging
ON SCHEDULE
EVERY 1 SECOND
STARTS (NOW() + INTERVAL 1 SECOND) -- enter sampling period here
DO
BEGIN

-- start streamers 1-24
INSERT INTO `ddd`.`log_streamer_01` (streamer_tension, cable_speed, reel_speed_rpm, meter_out, synchro_delta_deviation, time)
SELECT streamer_tension, cable_speed, reel_speed_rpm, meter_out, synchro_delta_deviation, NOW()
FROM `ddd`.`b04_reel_data` WHERE id=1;

Use Event Mysql (1 reply)

Draxent Seventh — Tue, 23 Oct 2012 06:35:54 +0000

Hi everybody !!!
I was trying to create a mysql event.
I use XAMPP and phpMyAdmin.
I created a simple event:
-----------
DELIMITER ;;
CREATE EVENT INCREASE
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
UPDATE `translation` SET `probability` = `probability`+1;
END;;
DELIMITER ;
-----------

After I created I tried to see the table "information_schema".
The event was created correctely, but after 5 minutes nothing happens.
Infact the `EVENTS`.LAST_EXECUTED field was remained NULL.

I tried also to change the function with this difference:
"ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE".
Nothing.

How can I make to work my event?
What did I wrong?

Thanks you ;)

How to stop replicating events? (2 replies)

Adam Newman — Thu, 04 Oct 2012 15:01:20 +0000

Hello!

We had a problem where our slave attempted to replicate a "DROP EVENT" statement from our master, but the event did not exist on the slave and so an error occured, causing replication to halt.

The event didn't exist on our slave because while the event was running on the master, the slave (after processing the initial "CREATE EVENT" statement) was rebooted and "forgot" about the event. When the master finished its event, the slave received the "DROP EVENT" statement and threw an error.

I had to then pick through the binlogs to find the position of this statement and skip it which took some time.

We don't actually need to run the event on the master, and would prefer if we could prevent the replication of the EVENT statements altogether. Is there any way to do this? We've used a wildcard prefix for tables which works ok for that, but I can't see a way to do this for EVENTs?

There is another thread that asked this question but it appears to be closed:

http://forums.mysql.com/read.php?119,241951,241951#msg-241951

**EDIT**

Been digging around in the options and I still can't find anything that helps. A workaround would be to have the event scheduler use "DROP IF EXISTS" when purging the events on mysql shutdown. At least then only a warning would be generated and replication would not halt.

Is there any way to override the event scheduler purge process so it doesn't try to do a "DROP EVENT"?

Cheers,
Adam.

scheduled task doesn't work on 5.524-log/windows (1 reply)

Ilya Shipitsin — Wed, 18 Jul 2012 21:43:30 +0000

Hello!

I'm running mysql-5.5.24-log on windows.

the following statement creates scheduled event, but I see no evidence of its work

use mysql;
delimiter \\
create event if not exists disable_innodb_flush
on schedule every 1 minute
starts current_timestamp
do
begin
insert into t (t) values (current_timestamp);
set global innodb_flush_log_at_trx_commit = 2;
end

what could be wrong ?

scheduled batch command (1 reply)

Anthony Thomas — Tue, 10 Jul 2012 17:24:27 +0000

I'm trying to run a scheduled batch command of the form:

mysql> create event e_test on schedule every 1 day do source /var/www/home/test.sql;

This gives me:

ERROR 1064 (42000): You have an error in your SQL syntax ..

while

mysql> source /var/www/home/test.sql;

works perfectly fine.

I tried running with '\. /var/www/home/test.sql' instead of 'source /var/www/home/test.sql' but that gives me:

Failed to open file '/var/www/home/test.sql;', error: 2

Any ideas would be appreciated.

(running mysql 5.1.49-3 (Debian) )

Using the MySQL event scheduler to rotate the slow query log (no replies)

Edwin Desouza — Thu, 28 Jun 2012 18:51:01 +0000

Using the MySQL event scheduler to rotate the slow query log
http://swanhart.livejournal.com/135348.html

Strange event behavior (no replies)

Aldo Doronzo — Mon, 11 Jun 2012 09:07:34 +0000

Good morning everyone! I'm having a strange behavior for the query you find at the bottom.

As you can see, I use the IF in the select and it properly works. It writes 'No travel' when the date is '1899', otherwise it writes the normal date.

if I execute the INSERT/SELECT statement by myself, it works perfectly. However, if I use the create event (the one at the bottom), the event is properly executed, but the IF part has a strange behavior, and it reports almost always 'No travel'.

This is so strange, please help me!

Lookin' forward

Aldo

CREATE EVENT AggiornamentoFmsOdierno
ON SCHEDULE EVERY 1 DAY STARTS '2012-06-08 03:00:00'
DO
INSERT INTO fms_vehicle_day_sum_fercam (F, Plate, GroupId, Day, `First Start`, `Last Stop`, `Km Start`, `Km Stop`, `Total Cons Start`, `Total Cons Stop`, `Dist Diff`, `Cons Total`, `Cons Drive`, `Cons Stand`)
SELECT
vehicles.Code,
vehicles.Name AS Plate,
vehicles.GroupId AS GroupId,
fms_vehicle_day_sum.Day,
IF(fms_vehicle_day_sum.FirstStart = '1899-12-30 00:00:00','No Travel',fms_vehicle_day_sum.FirstStart) `First Start`,
IF(fms_vehicle_day_sum.LastStop = '1899-12-30 00:00:00','No Travel',fms_vehicle_day_sum.LastStop) `Last Stop`,
fms_vehicle_day_sum.Km_Start AS `Km Start`,
fms_vehicle_day_sum.Km_Stop AS `Km Stop`,
fms_vehicle_day_sum.FMS_TotalConsStart AS `Total Cons Start`,
fms_vehicle_day_sum.FMS_TotalConsStop AS `Total Cons Stop`,
fms_vehicle_day_sum.DistDiff AS `Dist Diff`,
fms_vehicle_day_sum.ConsTotal AS `Cons Total`,
fms_vehicle_day_sum.ConsDrive AS `Cons Drive`,
fms_vehicle_day_sum.ConsStand AS `Cons Stand`
FROM fms_vehicle_day_sum
LEFT JOIN vehicles ON vehicles.id=fms_vehicle_day_sum.VehicleId
WHERE (fms_vehicle_day_sum.Day = SUBDATE(CURDATE(), 1)) AND (vehicles.code LIKE 'F%')
ORDER BY vehicles.Code;

Event ERROR (2 replies)

David parker — Thu, 07 Jun 2012 06:33:18 +0000

CREATE EVENT e_vicidial_auto_calls
ON SCHEDULE
EVERY 55 SECOND
COMMENT 'Clears out sessions table'
DO
DELETE FROM vicidial_auto_calls where channel IS NULL

Above event creations gives me an Error and I cant add the event.. Pl advice.

How to obtain the list of stored procedure parameters?? (1 reply)

duan xz — Thu, 10 May 2012 07:48:15 +0000

In java program, how to obtain mysql stored procedure parameter list??
As in SqlServer, you can call sp_sproc_columns to obtain the parameters columns of a stored procedure.in mysql,How to do it?
Any help is appreciated！

duanxz
Regards！

How to obtain the list of stored procedure parameters?? (no replies)

duan xz — Mon, 07 May 2012 09:33:05 +0000

In java program, how to obtain mysql stored procedure parameter list??

As in SqlServer, you can call sp_sproc_columns to obtain the parameters columns of a stored procedure.in mysql,How to do it?

Any help is appreciated！

duanxz
Regards！

Can an event run again if it is already running? (no replies)

Glenn Schworak — Sat, 21 Apr 2012 22:00:06 +0000

I have started working with events and until now they have all been daily clean-up events that don't take long to run.

I have an idea for a new event that I want to run every 10 minutes (or so). But the catch is, in some cases (not often) the run time on the event can take well over 10 minutes and it has a high processor load.

If I schedule this event to run every 10 minutes (for example) and it is alreay running, will I end up with two copies of the event running and hammer my processor? or will the scheduler see that the event is still running from the last time and skip execution?

If it will just fire off another copy of the event, how can I prevent this?

What is wrong with this EVENT? (1 reply)

Russell Brown — Sat, 28 Apr 2012 09:35:20 +0000

Hello, im fairly new to MySql and im playing around with events :D
Im having a spot of bother with one im wondering if anyone can point out to me why its not working correctly or at least not the way i expect.

CREATE EVENT newQueue1
ON SCHEDULE EVERY 30 SECOND
DO
BEGIN
DECLARE amount integer;
SET amount = (SELECT amount FROM queue WHERE id=1);
IF amount <= 0 THEN
//Do something else
ELSE
UPDATE queue SET amount=amount-1, total_production_time=total_production_time-30 WHERE id=1;
END IF;
END;

What the above is currently doing is take the amount from 200 to 0 on the first pass when it should take really 1 of every 30 seconds.

What have i done wrong? Any help would be greatly appreciated.

Many thanks in advance

mysql Event running yearly calculations (no replies)

Damian Hynes — Tue, 10 Apr 2012 13:31:38 +0000

I have the following code

CREATE EVENT myevent2
ON SCHEDULE EVERY '1' YEAR
STARTS commit_date + INTERVAL 1 YEAR
DO
UPDATE lms.loan

if new.app_loan_type='Computer Loan' then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.computer_interest/100));
end if;

if new.app_loan_type="Miscellaneous Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.miscellaneous_interest/100));
end if;

if new.app_loan_type="Motor Vehicle Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.motor_vehicle_interest/100));
end if;

if new.app_loan_type="Motor Vehicle Insurance Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.mv_insurance_interest/100));
end if;

if new.app_loan_type="Motor Vehicle Repair Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.mv_repair_interest/100));
end if;

if new.app_loan_type="Salary Advance Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.salary_advance_interest/100));
end if;

if new.app_loan_type="Tertiary Loan" then
SET NEW.app_yearly_intrst = (NEW.app_ln_amnt *(NEW.tertiary_interest/100));
end if;

SET NEW.app_mnthly_intrest = (NEW.app_yearly_intrst/12);
SET NEW.app_quarterly_intrest = (NEW.app_mnthly_intrest * 3);
SET NEW.app_amnt_owed = (NEW.app_ln_amnt+ NEW.app_yearly_intrst);

END$$
I am trying to create an event to calculate interest for two loan types: 'Computer Loan' and 'Miscellaneous Loan'.. etc, on a Yearly basis, however the yearly basis is dependent on the the commit_date column that would be a year from the commit_date column, then if the app_loan_type is 'Computer Loan'or 'miscellaneous Loan' then the yearly interest is calculated Im also calculating monthly interest, Quarterly Interest and total amount owed, but my main problem is how to set the interval of commit_date and current date to be 1 year

event to export table to csv log file every day at midnight (3 replies)

Darren White — Wed, 07 Mar 2012 17:02:51 +0000

ok I have no experience of Events or the Mysql command line (I've used workbench).

I have some log tables being generated using triggers.

Now I want to export these tables to a csv files and empty these tables once a day.

I have some code for generating the log files which works:

SELECT @myCommand := concat(
"SELECT * into OUTFILE 'C:/logs/log_01_",
DATE_FORMAT(now(),'%Y_%m_%d_%h_%i_%s'), ".csv'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
FROM log_streamer_01");
PREPARE stmt FROM @myCommand;
EXECUTE stmt;

now I want to have a schedule that executes this every day at 00:00:00 and then empties the table (ready to be filled again over the next day).

I would really appreciate some help to get me started quickly here. :-)

Help getting event to work (no replies)

Jan Klemmensen — Sat, 18 Feb 2012 17:52:29 +0000

Hi all,

I am trying to create an event which deletes items in a cart more than 1 hour old, and at the same time updates to other tables. - I can see that the event is running, but nothing is being executed, can someone point out what is wrong?

Are the variables being declared wrongly perhaps?

DELIMITER |
CREATE
EVENT delete_cart
ON SCHEDULE EVERY 5 MINUTE
DO
BEGIN

DECLARE cartID INTEGER(11);
DECLARE cartProductID INTEGER (11);
DECLARE cartAntal INTEGER (11);
DECLARE cartStr VARCHAR(5);

SELECT id, produkt_id, antal, str INTO cartID, cartProductID, cartAntal, cartStr FROM cart WHERE added_date >= added_date + 10000 LIMIT 1 ;

UPDATE products SET stock = stock + cartAntal WHERE produkt_id = cartProductID;

UPDATE sizes SET antal = antal + cartAntal WHERE size = cartStr AND product_id = cartProductID;

DELETE FROM cart WHERE id = cartID;

END |
DELIMITER ;

Unfortunately nothing happens at all :-/

I hope somone can see what is wrong here!
Regards Jan Klemmensen

Schedule an event for N Wednesdays in a month for N years (1 reply)

My SQL — Mon, 05 Dec 2011 16:41:50 +0000

Hi all,

I need an event that will call N stored procedures on a specific Wednesdays in a month at a specific time (say; 7am) for N years.

example, the event should kick on the following Wednesdays:

9/11/2011
23/11/2011
7/12/2011
21/12/2011
4/01/2012
18/01/2012
1/02/2012
15/02/2012
29/02/2012

...basically it should follow this sequence; 1 Wednesday YES, 1 Wednesday NO; 1 Wednesday YES, 1 Wednesday NO; 1 Wednesday YES, 1 Wednesday NO....

Your help is highly appreciated.

Thanks

Event for each selected row (no replies)

Duluman Eduard — Sun, 28 Aug 2011 16:47:50 +0000

Hi there, I want to create an event scheduler in mysql, but I dont have the required experience to do that.

I have a table named villages and a table named build.
The event must select every seconds the rows from build that have end_time = UNIX_TIMESTAMP(NOW()) and for each selected row it should proceed as it follows:

set @level = select this.building from villages where id = this.village;
update villages set this.building = @level + 1 where id = this.villages;
delete from build where id = this.id

by this.id / this.building I mean the id and the building column data from the actual row.

Finding/killing long running InnoDB transactions with Events (no replies)

Edwin DeSouza — Thu, 04 Aug 2011 15:09:36 +0000

Finding/killing long running InnoDB transactions with Events
http://www.markleith.co.uk/?p=730

Using the event scheduler to purge the process list
http://datacharmer.blogspot.com/2008/10/using-event-scheduler-to-purge-process.html

`kill_run_aways` Stored Proc
http://forge.mysql.com/tools/tool.php?id=106

Yoshinori: Tracking long running transactions in MySQL
http://yoshinorimatsunobu.blogspot.com/2011/04/tracking-long-running-transactions-in.html

MySQL Utilities: mysqlprocgrep
http://wb.mysql.com/utilities/man/mysqlprocgrep.html

How to debug long-running transactions in MySQL
http://www.mysqlperformanceblog.com/2011/03/08/how-to-debug-long-running-transactions-in-mysql/

Access remotely to events (no replies)

morteza ir — Fri, 15 Jul 2011 14:33:27 +0000

Hi
I handling my DB remotely. Like creating and modifying stored procedures and functions.
But when i want to create new events remotely. Mysql throw following error:
“ Access denied for user 'root'@'%' to database 'myDB' ”
May anyone help me ?

Best.
Morteza

How to tell what happened to my event? (no replies)

Pieter Huiberts — Fri, 15 Jul 2011 12:40:00 +0000

Hello,
I have created a simple event that supposed to run every morning at 2am. the event will call a SP that copies a table to hist and purges old records from the orig, see below. The 'Show events' command demonstrates that the event is registered. The SP works, it has been tested many times. This morning I do not find a history tabl ewith this mornings 2am timestamp, indicating the event is not working.

How can I tell what happened to the event, if anything?
Thanks!

drop event if exists cleanRev_cdmrpUpdates;
delimiter |
-- http://mysqlresources.com/documentation/stored-routines/148
CREATE EVENT cleanRev_cdmrpUpdates
ON SCHEDULE EVERY 1 day
STARTS '2011-07-14 02:00:00'
ON COMPLETION PRESERVE
COMMENT 'Daily backup and purge of rev_cdmrp.updates table'
do call sp_cleanRev_cdmrpUpdates();

delimiter ;

Repeat Event daily at particular time (1 reply)

Amuthasakaran Bala Subramanian — Fri, 01 Jul 2011 07:23:09 +0000

hi
i need to run a event in mysql which should execute script everyday @00:01:00 repeatly...

Pls help me to create this event scheduler in mysql

Highlights of Lucene Revolution 2011--Now in Slides (no replies)

sandra willson — Fri, 10 Jun 2011 07:34:22 +0000

Lucid Imagination founder Marc Krellenstein kicked off the Lucene Revolution yesterday with a keynote address covering the history of search. Here are the slides, followed by some highlights. http://bit.ly/m8lnK1

modify the schedule of an event without use the Alter command (1 reply)

Jorge Jaen — Wed, 01 Jun 2011 07:05:50 +0000

is there a way to modify the schedule of an event without use the Alter command?

maybe updating the table information_schema.events?

Thank you in advance

Find/Kill long running InnoDB transactions with Events (no replies)

Edwin DeSouza — Tue, 31 May 2011 15:18:37 +0000

Find/Kill long running InnoDB transactions with Events
http://www.markleith.co.uk/?p=730