How to diagnose database test issues?

  • Resolved Nick

    (@nickchomey)


    4 years, 3 months ago

    Are you able to give any insight into why I might be getting a score of zero on my database tests? They’re taking 1.5 minutes on one server (which otherwise gets exceptional scores), whereas it takes seconds on others.

    https://ibb.co/10cvymg

    • This topic was modified 4 years, 3 months ago by Nick.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Anton Aleksandrov

    (@antonaleksandrov)

    4 years, 2 months ago

    Hm, interesting. What OS do you have? It might be some MySQL query limit, that is terribly limiting very large number of queries..

    Thread Starter Nick

    (@nickchomey)

    4 years, 2 months ago

    Thanks for the reply! I am using Ubuntu 20.04. I managed to improve things by changing innodb_flush_log_at_trx_commit in the database to 2, which makes it flush to disk once a second rather than on each request. Though it still doesn’t explain why I wasn’t having trouble with a different VPS and same setup.

    Anyway, I moved to a different VPS recently and just got a score of 9.5 on the benchmark, with all tests in the 9-10 range except “Importing large amount of data to database”, which had 6.94.

    I’ll close this now.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘How to diagnose database test issues?’ is closed to new replies.