Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. How to Optimize MySql Database?

How to Optimize MySql Database?

Scheduled Pinned Locked Moved Database
databasecode-reviewcsharpasp-netmysql
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    Paramhans Dubey
    wrote on last edited by
    #1

    Hi Experts, We have created an application in ASP.Net 2.0 and with MySQL 5.0.67 as Backend. The application was running great from months, but recently we have discovered that there is a performance degrades in the database. Actually database was designed by one of my colleague how didn’t have much of database background so database design is not a professional one. I would also like to mention that this is my first Project on MySQL. I have worked on SQL Server till now. When I started analyzing the database I found indexing was missing in the tables. Introduction of Indexes has improved the performance somewhat. Can any one please tell me what else can I do to improve the performance. Please help me its urgent Thanks and Regards, Paramhans Dubey

    A D 2 Replies Last reply
    0
    • P Paramhans Dubey

      Hi Experts, We have created an application in ASP.Net 2.0 and with MySQL 5.0.67 as Backend. The application was running great from months, but recently we have discovered that there is a performance degrades in the database. Actually database was designed by one of my colleague how didn’t have much of database background so database design is not a professional one. I would also like to mention that this is my first Project on MySQL. I have worked on SQL Server till now. When I started analyzing the database I found indexing was missing in the tables. Introduction of Indexes has improved the performance somewhat. Can any one please tell me what else can I do to improve the performance. Please help me its urgent Thanks and Regards, Paramhans Dubey

      A Offline
      A Offline
      Ashfield
      wrote on last edited by
      #2

      Paramhans Dubey wrote:

      didn’t have much of database background so database design is not a professional one

      So the design may be wrong to start with

      Paramhans Dubey wrote:

      indexing was missing in the tables

      Another sign that he didn't know ehat he was doing

      Paramhans Dubey wrote:

      Please help me its urgent

      Do what you should have done in the first place, employ someone who knows what they are doing. Without the schema, useage, etc its impossible to say what should be done anyway.

      Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

      P 1 Reply Last reply
      0
      • A Ashfield

        Paramhans Dubey wrote:

        didn’t have much of database background so database design is not a professional one

        So the design may be wrong to start with

        Paramhans Dubey wrote:

        indexing was missing in the tables

        Another sign that he didn't know ehat he was doing

        Paramhans Dubey wrote:

        Please help me its urgent

        Do what you should have done in the first place, employ someone who knows what they are doing. Without the schema, useage, etc its impossible to say what should be done anyway.

        Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

        P Offline
        P Offline
        Paramhans Dubey
        wrote on last edited by
        #3

        Hi Thanks for your reply and suggestion. We are in process to recruitin someone who knows the job, but meanwhile we just cant sit and wait for him to join and do the job. Anyways I was going through one article where I came to know about Table Engines and their usage. I also came to know there Using MyISAM table engine can improve the read perfomance of the tables but the author also wrote that Your tables will get corrupted eventually but there was no explaination about how and why it happens? I fyou know the reason then kindly tell me Thanks and Regards, Paramhans Dubey.

        1 Reply Last reply
        0
        • P Paramhans Dubey

          Hi Experts, We have created an application in ASP.Net 2.0 and with MySQL 5.0.67 as Backend. The application was running great from months, but recently we have discovered that there is a performance degrades in the database. Actually database was designed by one of my colleague how didn’t have much of database background so database design is not a professional one. I would also like to mention that this is my first Project on MySQL. I have worked on SQL Server till now. When I started analyzing the database I found indexing was missing in the tables. Introduction of Indexes has improved the performance somewhat. Can any one please tell me what else can I do to improve the performance. Please help me its urgent Thanks and Regards, Paramhans Dubey

          D Offline
          D Offline
          Dave2909
          wrote on last edited by
          #4

          OK, so your DB started performing poorly after it ran for awhile....that's a pretty broad problem, but here's a few things you might try: 1) I fully agree with Bob's post - if you want it to work correctly, get someone who knows what they're doing to set things up properly. (Though I understand that doesn't fix your problem today.) 2) Check for any tables that have grown excessively large. It's possible that you have some large logging / history tables and such that can easily be archived and deleted from the working tables. 3) If there's any way to narrow your problem down to a few areas (perhaps the top 2 or 3 stored procedures you're having trouble with?) you can look at modifying indexes specifically to help with those queries - just be sure you don't replace one problem with another. 4) You could always throw more hardware at it for a temporary fix... If you have any more specifics about what the problem is, perhaps we could better help. -Dave

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups