Re: Lock wait timeout exceeded; try restarting transaction
SHOW CREATE TABLE UAMS_User;
Sounds like you don't have the appropriate indexes.
insert into T2 select eid,ctime from UAMS_User where pid in (select eid from T1) and eid>666 and status>9
What is T1? About how many rows will be in it? Can you turn this into a JOIN? ("IN (SELECT ...)" is often _much_ slower than the equivalent JOIN.)
"ltime<date_sub( NAME_CONST('sp_datetime',..." -- Which tables are ltime and sp_datetime in? Are they indexed?
SHOW TABLE STATUS -- need to see how big the tables are.
Subject
Views
Written By
Posted
12896
June 04, 2010 10:07PM
5455
June 05, 2010 12:43AM
Re: Lock wait timeout exceeded; try restarting transaction
3369
June 06, 2010 09:01AM
4487
June 06, 2010 10:39AM
3209
June 06, 2010 08:17PM
2621
June 06, 2010 08:37PM
4025
June 07, 2010 05:53PM
3128
June 08, 2010 01:23AM
3253
June 08, 2010 01:52AM
2218
June 08, 2010 09:02AM
3161
June 08, 2010 12:55PM
1985
June 09, 2010 12:49AM
3248
June 10, 2010 11:22PM
3575
June 11, 2010 09:25AM
3283
June 11, 2010 04:04PM
1943
June 11, 2010 08:02PM
3263
June 15, 2010 07:27PM
7728
June 15, 2010 08:13PM
2712
June 15, 2010 11:02PM
2503
June 15, 2010 11:04PM
3328
June 15, 2010 11:17PM
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.