1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Optimizing MySQL

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

  1. linuxxphybrid

    linuxxphybrid Guest

    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

    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

    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

    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

    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.