- Mine
- Wednesday, July 11th, 2007 at 2:15:06pm MDT
- DROP TABLE IF EXISTS `la1`;
- CREATE TEMPORARY TABLE la1 (
- `la1_id` int(8) unsigned NOT NULL default '0'
- );
- INSERT INTO `la1` (lal_id)
- SELECT DISTINCT a_id as la1_id
- FROM ruwiki_p.pagelinks,
- articles
- WHERE pl_from in
- (
- SELECT lkr_id
- FROM linkers
- ) and
- pl_namespace=0 and
- pl_title=a_title and
- pl_from!=a_id;
- The result is in 50% ok, and in 50% is: 'ERROR 1213 (40001) at line 359: Deadlock found when trying to get lock; try restarting transaction'
advertising
Update the Post
Either update this post and resubmit it with changes, or make a new post.
You may also comment on this post.
Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.