Title: SQL-MYSQL Lock slow… error
Last modified: August 19, 2016

---

# SQL-MYSQL Lock slow… error

 *  [applemaybe](https://wordpress.org/support/users/applemaybe/)
 * (@applemaybe)
 * [16 years, 5 months ago](https://wordpress.org/support/topic/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..

The topic ‘SQL-MYSQL Lock slow… error’ is closed to new replies.

## Tags

 * [apache](https://wordpress.org/support/topic-tag/apache/)
 * [lock](https://wordpress.org/support/topic-tag/lock/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [applemaybe](https://wordpress.org/support/users/applemaybe/)
 * Last activity: [16 years, 5 months ago](https://wordpress.org/support/topic/sql-mysql-lock-slow-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics