MySQL high performance

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

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

Open Support Ticket
  • Author
    Posts
  • December 18, 2017 at 12:21 am #409841

    Jacob Paulsen
    Full Member
    Post count: 45

    Hello,

    we have a website with around 80K places. The website has (twice) crashed (and came back after deactivating the WPGeoDir plugin).

    Did some research and noticed that with a traffic of around 40 to 50 visitors clicking on the map the MySQL server has a constant CPU usage of 250% reaching up to 750% sometimes.

    Is there any optimized MySQL server configuration to use?

    The site is hosted on a VPS server with dedicated resources.

    The results return clustered (server side) but for thousands of locations not sure if it efficient.

    Any suggested tests to take to have a better understanding of the WPGeoDir plugin impact ?

    December 18, 2017 at 2:00 am #409843

    Guust
    Moderator
    Post count: 29970

    Have you tried to enable the map cache at GD > Design > map. Look towards the bottom of the page. I’ll get Stiofan to look at your question too. Thanks

    December 18, 2017 at 11:23 am #409914

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    As Guust suggested, try the map cache first, and let us know how you get on.

    Thanks,

    Stiofan

    December 19, 2017 at 11:30 am #410003

    Jacob Paulsen
    Full Member
    Post count: 45

    Thank you for your suggestions. It seems to have improved a lot. Will monitor for now and if something unusual comes up will let you know.

    December 20, 2017 at 12:18 pm #410103

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Thanks for letting us know 🙂

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)

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

Open Support Ticket