MySQL Forums
Forum List  »  Events (Job Scheduler)

lock tables
Posted by: jongse park
Date: June 07, 2015 11:05PM

Hi,

I use innodb tables.
I execute insert query and delete query concurently for a table.
There is no locks on a table in sql commnad lines.
and
I use crontab to delete rows instead of event scheduler. there is no lock

When I use event scheduler for the delete query. there is a lock.

mysql> select * from mysql.event\G
*************************** 1. row ***************************
db: gsdm
name: requestIdDelete_schedule
body: delete from gsdm.requestIdTable where expireday+interval 0 Hour < now()
definer: root@localhost
execute_at: NULL
interval_value: 60
interval_field: SECOND
created: 2015-06-04 17:21:17
modified: 2015-06-04 19:06:44
last_executed: 2015-06-04 11:31:17
starts: 2015-06-04 10:21:17
ends: NULL
status: DISABLED
on_completion: DROP
sql_mode:
comment:
originator: 0
time_zone: SYSTEM
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
db_collation: latin1_swedish_ci
body_utf8: delete from gsdm.requestIdTable where expireday+interval 0 Hour < now()
1 row in set (0.00 sec)
-----------------------------------

What happen to the event scheduler?
Does event scheduler locks tables usualy?


Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
lock tables
1584
June 07, 2015 11:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.