最近发现机器负载很高，经常网站打不开，查看MYSQL进程，发现很多表老是死锁，时间很长，不知道如何解决？论坛都运行好几年了，就是最近2个月很慢，之前都很好的。
| 26343 | uchome | localhost | uchome | Query | 1227 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26350 | uchome | localhost | uchome | Query | 1183 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26354 | uchome | localhost | uchome | Query | 1174 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26359 | uchome | localhost | uchome | Query | 1157 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26367 | uchome | localhost | uchome | Query | 1140 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26370 | uchome | localhost | uchome | Query | 1136 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26373 | uchome | localhost | uchome | Query | 1132 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26377 | uchome | localhost | uchome | Query | 1123 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26378 | uchome | localhost | uchome | Query | 1116 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26379 | uchome | localhost | uchome | Query | 1112 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26380 | uchome | localhost | uchome | Query | 1105 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2827' AND blog.blogid=tb.blo |
| 26381 | uchome | localhost | uchome | Query | 1095 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26382 | uchome | localhost | uchome | Query | 1082 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26386 | uchome | localhost | uchome | Query | 1071 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26388 | uchome | localhost | uchome | Query | 1029 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26389 | uchome | localhost | uchome | Query | 1022 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26390 | uchome | localhost | uchome | Query | 1019 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26391 | uchome | localhost | uchome | Query | 1017 | Locked | SELECT bf.message, bf.target_ids, bf.magiccolor, b.* FROM uchome_blog b
LEFT JOIN uchome_blogf |
| 26392 | uchome | localhost | uchome | Query | 1014 | Locked | UPDATE uchome_blogfield SET `related`='a:0:{}', `relatedtime`='1300455500' WHERE `blogid`='45937' |
| 26395 | uchome | localhost | uchome | Query | 996 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26398 | uchome | localhost | uchome | Query | 980 | Locked | SELECT COUNT(*) FROM uchome_blog b WHERE 1 AND b.dateline>='1300369134' |
| 26406 | uchome | localhost | uchome | Query | 963 | Locked | SELECT COUNT(*) FROM uchome_blog b WHERE b.uid='25678' |
| 26416 | uchome | localhost | uchome | Query | 932 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26421 | uchome | localhost | uchome | Query | 926 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26427 | uchome | localhost | uchome | Query | 907 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26429 | uchome | localhost | uchome | Query | 879 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26431 | uchome | localhost | uchome | Query | 873 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26433 | uchome | localhost | uchome | Query | 871 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26445 | uchome | localhost | uchome | Query | 848 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2939' AND blog.blogid=tb.blo |
| 26446 | uchome | localhost | uchome | Query | 847 | Locked | SELECT b.uid, b.blogid, b.subject, b.dateline, b.pic, b.picflag, b.viewnum, b.replynum, b.friend, b. |
| 26447 | uchome | localhost | uchome | Query | 842 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26455 | uchome | localhost | uchome | Query | 813 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2794' AND blog.blogid=tb.blo |
| 26461 | uchome | localhost | uchome | Query | 805 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26462 | uchome | localhost | uchome | Query | 804 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2827' AND blog.blogid=tb.blo |
| 26467 | uchome | localhost | uchome | Query | 787 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26476 | uchome | localhost | uchome | Query | 777 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26484 | uchome | localhost | uchome | Query | 762 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26488 | uchome | localhost | uchome | Query | 755 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26489 | uchome | localhost | uchome | Query | 751 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26493 | uchome | localhost | uchome | Query | 734 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26494 | uchome | localhost | uchome | Query | 734 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='5188' AND blog.blogid=tb.blo |
| 26500 | uchome | localhost | uchome | Query | 714 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26501 | uchome | localhost | uchome | Query | 711 | Locked | SELECT b.uid, b.blogid, b.subject, b.dateline, b.pic, b.picflag, b.viewnum, b.replynum, b.friend, b. |
| 26503 | uchome | localhost | uchome | Query | 702 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26505 | uchome | localhost | uchome | Query | 695 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26519 | uchome | localhost | uchome | Query | 638 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26520 | uchome | localhost | uchome | Query | 638 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26521 | uchome | localhost | uchome | Query | 638 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26522 | uchome | localhost | uchome | Query | 626 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26523 | uchome | localhost | uchome | Query | 624 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26530 | uchome | localhost | uchome | Query | 603 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26533 | uchome | localhost | uchome | Query | 598 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26535 | uchome | localhost | uchome | Query | 518 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26536 | uchome | localhost | uchome | Query | 582 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26537 | uchome | localhost | uchome | Query | 518 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26538 | uchome | localhost | uchome | Query | 516 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='13924' AND blog.blogid=tb.bl |
| 26539 | uchome | localhost | uchome | Query | 518 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2939' AND blog.blogid=tb.blo |
| 26541 | uchome | localhost | uchome | Query | 516 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26542 | iclient | localhost:36524 | iclient | Query | 61 | NULL | commit |
| 26543 | uchome | localhost | uchome | Query | 517 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26548 | iclient | localhost:45418 | iclient | Sleep | 58 | | NULL |
| 26549 | iclient | localhost:45456 | iclient | Query | 277 | NULL | commit |
| 26551 | uchome | localhost | uchome | Query | 515 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26552 | iclient | localhost:33583 | iclient | Query | 21 | NULL | commit |
| 26553 | uchome | localhost | uchome | Query | 512 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2794' AND blog.blogid=tb.blo |
| 26554 | uchome | localhost | uchome | Query | 503 | Locked | SELECT blog.* FROM uchome_tagblog tb , uchome_blog blog WHERE tb.tagid='2827' AND blog.blogid=tb.blo |
| 26561 | uchome | localhost | uchome | Query | 462 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26566 | uchome | localhost | uchome | Query | 446 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26567 | uchome | localhost | uchome | Query | 445 | Locked | SELECT COUNT(*) FROM uchome_blog b WHERE 1 AND b.dateline>='1300369669' |
| 26570 | uchome | localhost | uchome | Query | 437 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26575 | uchome | localhost | uchome | Query | 399 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26590 | uchome | localhost | uchome | Query | 381 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26592 | uchome | localhost | uchome | Query | 348 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26598 | uchome | localhost | uchome | Query | 343 | Locked | INSERT INTO uchome_blog (`subject`, `classid`, `friend`, `password`, `noreply`, `picflag`, `pic`, `t |
| 26599 | uchome | localhost | uchome | Query | 330 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26600 | uchome | localhost | uchome | Query | 330 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
| 26601 | uchome | localhost | uchome | Query | 321 | Locked | SELECT bf.*, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.blog |
|
置顶卡
喧嚣卡
变色卡
千斤顶
显身卡