WordPress.org

Ready to get started?Download WordPress

Forums

SQL-MYSQL Lock slow... error (1 post)

  1. applemaybe
    Member
    Posted 4 years ago #

    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..

Topic Closed

This topic has been closed to new replies.

About this Topic