The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Tuning Mysql for lower overall server load

Discussion in 'General Discussion' started by fishfreek, Mar 20, 2004.

  1. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    I saw a link to an EV1 thread about tuning mysql for better handeling.

    Alot of the responses where a little confusing to me so I was hoping maybe someone could provide what they have done.

    The servers all have 1gb of ram and are AMD XP3000 cpu's with IDE disks.

    I added the following lines to my.cnf yesterday.

    query_cache_type=1
    query_cache_limit=1M
    query_cache_size=16M
    table_cache=1024
    key_buffer=128M

    Overall the load that mysql puts on the server went down but I also feel that the performance of mysql has gone down aswell. Im trying to find a nice balance between performance and load.
     
Loading...

Share This Page