1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

My databases were causing excessive load on the server..

Discussion in 'MySQL' started by bilal bhatti, May 22, 2016.

  1. #1
    My databases were causing excessive load on the server...So I also know the issues where are in the database but i don't know how to solve that? Is there anybody who can guide me step by step to solve this problem?
     
    bilal bhatti, May 22, 2016 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    There isn't really any blanket method of fixing load issues because it is very dependent on the available resources, the database structure and engine, and the actual load on the website using the database.

    What exactly in the database is causing the problem. It might be something as simple as query optimization. For high usage databases or for heavy loads, it might require upgrading to better or a dedicated server.
     
    jestep, Jun 10, 2016 IP