SQL-MYSQL Lock slow… error

Hi,

when I get instant visitors, mysql and apache locks itself.

PHPmyadmin logs:

5386 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5387 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5388 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5389 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5390 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5392 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5394 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5396 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5397 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5400 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5402 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5403 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5404 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5405 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5406 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5407 turkyurd_turkyur localhost turkyurd_turkyurdu Query 18 Locked UPDATE wp_posts SET post_parent = 134855 WHERE…
Kill 5409 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5410 turkyurd_turkyur localhost turkyurd_turkyurdu Query 6 Copying to tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5411 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5412 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5413 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5414 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5415 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5416 turkyurd_turkyur localhost turkyurd_turkyurdu Query 121 Sending data SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5418 turkyurd_turkyur localhost turkyurd_turkyurdu Query 119 Sending data SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5419 turkyurd_turkyur localhost turkyurd_turkyurdu Query 5 Sorting result SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5420 turkyurd_turkyur localhost turkyurd_turkyurdu Query 119 Sending data SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5422 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5423 turkyurd_turkyur localhost turkyurd_turkyurdu Query 118 Sending data SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5424 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 removing tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5425 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5426 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5427 turkyurd_turkyur localhost turkyurd_turkyurdu Query 9 Copying to tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5428 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT COUNT(*) FROM wp_term_relationships, wp_pos…
Kill 5429 turkyurd_turkyur localhost turkyurd_turkyurdu Query 8 Copying to tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5430 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5431 turkyurd_turkyur localhost turkyurd_turkyurdu Query 10 Sorting result SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5432 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT guid FROM wp_posts WHERE post_parent = ‘134…
Kill 5433 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…
Kill 5435 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5436 turkyurd_turkyur localhost turkyurd_turkyurdu Query 2 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5437 turkyurd_turkyur localhost turkyurd_turkyurdu Query 3 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5438 turkyurd_turkyur localhost turkyurd_turkyurdu Query 1 Locked SELECT * FROM wp_posts WHERE (post_type = ‘page’ …
Kill 5439 turkyurd_turkyur localhost turkyurd_turkyurdu Query 7 Copying to tmp table SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_pos…

SQL Log from SSH :

# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 38 Lock_time: 21 Rows_sent: 6 Rows_examined: 13676
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 38 Lock_time: 21 Rows_sent: 6 Rows_examined: 13676
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# Time: 091212 15:47:41
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 59 Lock_time: 22 Rows_sent: 1 Rows_examined: 42749
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 37 Lock_time: 23 Rows_sent: 6 Rows_examined: 13676
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 65 Lock_time: 46 Rows_sent: 1 Rows_examined: 42749
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 64 Lock_time: 22 Rows_sent: 1 Rows_examined: 42749
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 72 Lock_time: 42 Rows_sent: 1 Rows_examined: 42749
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 70 Lock_time: 41 Rows_sent: 1 Rows_examined: 42749
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.$
# User@Host: turkyurd_turkyur[turkyurd_turkyur] @ localhost []
# Query_time: 64 Lock_time: 45 Rows_sent: 1 Rows_examined: 42749

wich plugins i use: related_posts, viva_zoom, akismet, get_recent_comments and WP_Super_cache

i have 21 sql query in main page.. but i have inter i7 server 12Gb rams 4 process cpu 3tb harddisk..

Please help for fix my problem.

Thanks..