Sleeping Queries after terminating import process

This topic contains 15 replies, has 2 voices, and was last updated by  Stiofan O’Connor 7 years, 3 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: 

  • Author
    Posts
  • #392851

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57

    Hello,

    I have tried to upload 200 new places to our directory (240,000 places so far), but the process became so slow that it chocked the site.

    I terminated the process, but now the site is very slow. I contacted our hosting company they have informed me that there are sleeping queries in MySQL.

    Have you guys seen anything like this before? And how can I fix it?

    Thank you

    Here is the notes from our hosting company:

    One thing I am noticing is an excess of sleeping queries in the database dentalt0_live:

    | Id | User | Host | db | Command | Time | State | Info |
    | 7699 | dentalt0_live | localhost | dentalt0_live | Sleep | 96 | | |
    | 7739 | dentalt0_live | localhost | dentalt0_live | Sleep | 7 | | |
    | 7741 | dentalt0_live | localhost | dentalt0_live | Query | 4 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* , (3958.761 * 2 * ASIN(SQRT( PO |
    | 7742 | dentalt0_live | localhost | dentalt0_live | Sleep | 0 | | |
    | 7743 | dentalt0_live | localhost | dentalt0_live | Sleep | 15 | | |
    | 7745 | dentalt0_live | localhost | dentalt0_live | Sleep | 14 | | |
    | 7746 | dentalt0_live | localhost | dentalt0_live | Sleep | 14 | | |
    | 7747 | dentalt0_live | localhost | dentalt0_live | Sleep | 8 | | |
    | 7748 | dentalt0_live | localhost | dentalt0_live | Sleep | 2 | | |

    This is contributing to the extremely high CPU usage by the dentalt0 cPanel account (96%):

    dentalt0 35106 43.75% 24551.12re 27.65% 4560.51cp 96.89% 0avio 42373k
    mysql 1842 2.30% 39.58re 0.04% 106.07cp 2.25% 0avio 28924k
    root 33710 42.01% 28052.02re 31.59% 23.69cp 0.50% 0avio 17451k
    nobody 8083 10.07% 33962.37re 38.25% 16.18cp 0.34% 0avio 49288k
    cpanelconnecttrack 5 0.01% 271.52re 0.31% 0.26cp 0.01% 0avio 2860k
    nscd 1 0.00% 271.13re 0.31% 0.05cp 0.00% 0avio 282240k

    #392888

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hello,

    I have not seen that before.

    How many listings do you have and what is your server specs?

    If you provide wp-admin and cpanel details i will check things for any problems.

    Thanks,

    Stiofan

    #392900

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57
    This reply has been marked as private.
    #392907

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Naoufel,

    Yeah your site seems pretty slow for the server its on, something does not seems right.
    How “live” is this site, i would like to do some testing. (maybe tomorrow)

    Thanks,

    Stiofan

    #392908

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57

    hello,

    You can run test today if the down time is minimal.

    #392912

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    ok i am going to run some tests now, please avoid the wp-admin area for a bit.

    Thanks,

    Stiofan

    #392913

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    OK i ran some tests (i have finished for now) and the problem seems to be with the “unyson” plugin, i am guessing something about it does not scale well, but here are some stats below on a GD page (some other pages were worse):

    site load stats with unyson disabled:
    78 queries
    8mb memory used
    0.66s SQL run time
    1.84 total load time.

    site load stats with unyson enabled:
    250 queries
    32mb memory used
    4.83s SQL run time
    8.16 total load time

    What do you use that plugin for? It seems to be a page builder?
    If it were me i would make the pages, save the html and make static page templates of them, but it depends how much extra CSS/JS is required to load.

    Let me know ur thoughts.

    Thanks,

    Stiofan

    #392914

    Stiofan O’Connor
    Site Admin
    Post count: 22956
    This reply has been marked as private.
    #392915

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57

    hello,

    Thank you. But I am confused as the site was very fast before I attempted to upload the new listings.

    #392916

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    When you say the “new listings” you mean all your GD listings or just that last 200?
    I am just going by the evidence, that plugin does not seem to scale very well, maybe you can try asking them for support?

    Thanks,

    Stiofan

    #392919

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57
    This reply has been marked as private.
    #393237

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    I am not really sure, that is just what i found from my quick testing, i would need to dig further to know for sure, but if ur site is live it makes it difficult.

    Stiofan

    #393252

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57

    Hello,

    I am 100% percent committed to resolving this issue I have 2 files that I need to upload to the directory. One of them has 50,000 records. so if you need to take the website down to test.

    Please let me know and I will redirect the site to a temp page.

    We love your Directory and would like to make it work for us.

    #393253

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Do you have skype? we might be able to make progress faster if we can communicate faster (text), what is your skype ID?

    Thanks,

    Stiofan

    #393258

    Naoufel Benkerroum
    Lifetime Member
    Post count: 57
    This reply has been marked as private.
Viewing 15 posts - 1 through 15 (of 16 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount