1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

MySql overload

Discussion in 'MySQL Forums' started by ravemittal, Feb 11, 2013.

  1. ravemittal

    ravemittal Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Secunderabad
    Hi All,

    We are looking for a specific solution related to our MySql database which is effecting our server performance.

    We have a social networking website which is database intensive (the max. load is on the database server i.e MySql).

    It so happens that our MySql load reaches 70-85% on an average. More of this happens because we complie some reports on a daily basis where we have to create about 60,000 records everyday (10,000 records x 6 tables). Each cron here takes about 30-40 minutes to generate these 10,000 records and we have to run 6 crons daily. While we have checked slow queries, but these queries are optimized. However, due to the nature of these customized reports, it takes quite a load on the MySql server.

    What could be a possible solution for us to reduce the load:
    1. Do we host a database on an alternate server, then generate records to this database?
    2. Do we run a mirror database on another server and run our queries there?

    Any other possible solution where we could pull more data from MySql whenever required without effecting the normal performance of the database while end users are using the site?

    Kindly help!
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I would replicate the database to another physical server and run your reports from that machine.
     
  3. ravemittal

    ravemittal Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Secunderabad
    @Zargon: Thanks for the prompt reply. Do you mean mirroring the database to another server?
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    If you want to call it that. Set up replication of the production database to another physical server then run reports from the replicated database.
     
  5. ravemittal

    ravemittal Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Secunderabad
    Alright! We will try that one. Thanks for the help! :)