Results 1 to 7 of 7
  1. #1

    Question help needed about - how to optimize MySQL server on my Dedicated Server! details...

    help needed about - how to optimize MySQL server on my Dedicated Server! details...


    I have purchased a server from pixelfxsolution.com, their guys are great.

    but the server has some problem such as a heavy load on MySQL server...

    actually the MySQL server is only loading now less than 500MB database (allogether size of 6 databases), it was working well few days ago...

    and i do not see anything change heavy from the Mysql databse,

    but ... whenever i turn on MySQL server ... then the server just become very very slow ... and CP turns into 100% immediately ...

    and pixelfxsolution.com staff told me that i need to upgrade a new server ...
    but as far to now, I have my site only about less than 3 months ... I had just paid for the second month for the server's fee ...


    So, please help me out of this question : how can i optimize mySQL server ...?



    My server hardware is:

    AMD 1400
    1GB RAM
    80GB HD plus another 80GB HD
    100 Mbit Port
    Unmetered Transfer
    Windows 2003 and plesk CP

    i am currently hosting with only 4 sites,
    only one site has about more than 2000 visitors daily,
    others just as new sites ....
    so, please help me ASAP.



    Thank you very much!

    best regards!





    Chessming

  2. #2
    Chess,

    Check the Dedicated Server tutorials, it's a subsection to the Dedicated server forum..lots of stuff there about optimization
    Caro.Net: Support is everything
    Offering High Quality Dedicated Servers.

  3. #3
    thanx, Caro

    i had checked .... but i do not really see it there!

  4. #4
    Join Date
    Apr 2005
    Location
    San Francisco, CA
    Posts
    1,029
    Hire a pro and stop wasting your time. www.rack911.com

    Here is nobody can help you to optimize server without login and inspect everything INSIDE of the server.

  5. #5
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,290
    Have you made any changes to the my.ini file in windows?
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  6. #6
    Join Date
    Nov 2002
    Location
    WebHostingTalk
    Posts
    8,878
    * Moved to Technical and Security Issues

    Sirius
    I support the Human Rights Campaign!
    Moving to the Tampa, Florida area? Check out life in the suburbs in Trinity, Florida.

  7. #7
    Join Date
    Mar 2006
    Location
    New York USA
    Posts
    402
    I know i had a similar issue awhile back, www.seeksadmin.com worked it all out for me, and did it super cheap.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •