MYSQL performance help

Discussion in 'MySQL' started by Raymond.C, Mar 16, 2010.

0
  1. #1
    Hi,

    I have many MYSQL connections running on my database constantly. What settings could I do to increase or make performance more smoother or faster?

    I have 14, 000+ accounts stored and 40-100 of them are online.

    I need some help on performance and stability side.
     
    Raymond.C, Mar 16, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    What type of software is accessing the database, is it something custom made, or some existing software? Do you use MyISAM or InnoDB tables? Also, can you describe the server specs?
     
    jestep, Mar 16, 2010 IP
  3. Raymond.C

    Raymond.C Peon

    Messages:
    516
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Its custom and not existing, I think it uses "InnoDB tables".

    Server specs:

    3GB RAM
    Intel Xeon processors
    100mbps
    Windows 2003 64 bit
     
    Raymond.C, Mar 16, 2010 IP