Slow query issue

This topic contains 21 replies, has 3 voices, and was last updated by  IAN PETERS 7 years, 4 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • December 1, 2017 at 2:23 pm #407763

    IAN PETERS
    Buyer
    Post count: 39

    Hi

    this is reference to my site https://usaysi.co.uk Stiofan has worked on the tables for this site previously. I have attached a slow query report that my server admin has produced previously, Stiofan has access to a Skype group with Danila and myself and is probably the best person to pick this up again if he is available.

    The page download speed in google search console is running at between 1500 and 4800ms the site is large over 500,000 pages in the sitemap

    It is also crashing a lot 503 and 504 errors when I am trying to merge and delete locations

    See attachment

    Thanks

    Ian

    December 1, 2017 at 2:42 pm #407767

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
    December 1, 2017 at 3:32 pm #407783

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
    December 1, 2017 at 5:22 pm #407801

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    December 1, 2017 at 7:15 pm #407826

    IAN PETERS
    Buyer
    Post count: 39

    try 2020 not 22

    December 1, 2017 at 7:53 pm #407837

    Alex Rollin
    Moderator
    Post count: 27815

    Same issue

    Different host url?

    December 1, 2017 at 7:57 pm #407838

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
    December 1, 2017 at 8:06 pm #407841

    Alex Rollin
    Moderator
    Post count: 27815

    Hello!

    I tried all 3 hostnames and no luck.

    You might consider making a key/user

    December 1, 2017 at 8:12 pm #407844

    IAN PETERS
    Buyer
    Post count: 39

    I have asked my server admin, it might take a few hours to get a response as he is in Russia, I am in the UK

    December 1, 2017 at 10:32 pm #407863

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
    December 2, 2017 at 7:23 am #407904

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
    December 2, 2017 at 1:41 pm #407927

    Alex Rollin
    Moderator
    Post count: 27815

    Hello!

    I still can’t get in using those credentials; SSH and SFTP both timeout.

    We will be limited to the logs you send over and what we can see in WP.

    December 2, 2017 at 2:55 pm #407935

    IAN PETERS
    Buyer
    Post count: 39

    Can you give me an IP address, you may be blocked?

    Is PHP admin or ssh any use? It’s an Nginx server

    December 2, 2017 at 6:00 pm #407951

    Alex Rollin
    Moderator
    Post count: 27815

    Hello!

    I have flagged this and we will follow up to take a look as soon as the team gets back into the office Monday. Whatever you can open up is what they’ll have to work with.

    December 3, 2017 at 1:10 pm #408026

    IAN PETERS
    Buyer
    Post count: 39
    This reply has been marked as private.
  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 22 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