Extreme Lag Spikes when using PEX SQL

Discussion in 'Spigot Plugin Help' started by Lordcre_, May 21, 2016.

  1. I've been experiencing a ton of lag ever sense I switched to MySQL database instead of flatfile. Any ideas on what is causing this?

    [​IMG]
     
  2. Could you post your timings.

    Also is your MySQL database hosted locally, or off-site?
     
  3. It seems to be PEX causing the problem...
     
  4. It's all of my servers, pex is using an incredible amount of RAM.
     
  5. Based on the timings, I would say you're running an off-site MySQL database. I'm not sure how MCProHosting handles MySQL databases, but if it's possible to get a locally hosted MySQL databases, that would greatly increase performance.

    If your MySQL host is 127.0.0.1 or localhost, then it's locally hosted. You may want to verify this.

    Also you stated that PEX uses an incredible amount of RAM, that doesn't seem to be the case. According to your screenshot you are only using 670 / 1979 MB, so plenty left. You probably referred to the percentage of the tick it occupies.
     
    • Informative Informative x 1
  6. Lol, forgive me of my ignorance. Thanks a ton for your help!