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
12238
June 04, 2010 10:07PM
5137
June 05, 2010 12:43AM
Re: Lock wait timeout exceeded; try restarting transaction
3233
June 06, 2010 09:01AM
4251
June 06, 2010 10:39AM
3087
June 06, 2010 08:17PM
2508
June 06, 2010 08:37PM
3845
June 07, 2010 05:53PM
2914
June 08, 2010 01:23AM
3147
June 08, 2010 01:52AM
2106
June 08, 2010 09:02AM
3023
June 08, 2010 12:55PM
1885
June 09, 2010 12:49AM
3086
June 10, 2010 11:22PM
3452
June 11, 2010 09:25AM
3074
June 11, 2010 04:04PM
1794
June 11, 2010 08:02PM
3093
June 15, 2010 07:27PM
7310
June 15, 2010 08:13PM
2533
June 15, 2010 11:02PM
2388
June 15, 2010 11:04PM
3170
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.