1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Optimizing MySQL

Discussion in 'Plesk for Linux - 8.x and Older' started by linuxxphybrid, Jun 5, 2005.

  1. linuxxphybrid

    linuxxphybrid Guest

    0
     
    I'd like to get more performance out of MySQL, and I'd like to use my-large.cnf for this reason.

    q1. My server has 2GB memory. Is using my-large.cnf reasonable?

    q2. How do I use my-large.cnf instead of my.cnf that Plesk 7.5 installs?
     
  2. hardweb

    hardweb Guest

    0
     
    The optimization of the Mysql engine depends on the type of queries you run an it's not trivial. You can replace the /etc/my.cnf file with the my-large.cnf, but most likely there will be no performance improvement.
     
  3. linuxxphybrid

    linuxxphybrid Guest

    0
     
    Isn't there something non-expert can do to boost performance, or this is something we need to study, take time and approach very patiently?
     
  4. jamesyeeoc

    jamesyeeoc Guest

    0
     
    Performance tuning can be done even by non-experts. However, it will take much time on your part to do much research and testing/monitoring.

    It is up to you to decide if it is time well spent, or if it would be more cost effective to pay an expert to do it for you.

    Just like you would not just put a nitrous oxide booster into just any automobile and expect it to work, there are many factors to consider when dealing with a server.

    (sorry, my analogy is really a poor one, but too tired to think of a better one)
     
  5. hardweb

    hardweb Guest

    0
     
    In your situation the only course I see is:

    1. Change config
    2. Test
    3. Wait
    4. Repeat

    but it will take a loooong time.
     
Loading...