Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,202

    Optimal mysql config?

    i currently have this config

    Still sql times are huge, I was given this config by a friend. But to be honest it sucks.

    Any suggestions?

    [mysqld]
    connect_timeout=15
    interactive_timeout=100
    join_buffer_size=1M
    key_buffer=128M
    max_allowed_packet=16M
    max_connections=500
    max_connect_errors=10
    myisam_sort_buffer_size=64M
    read_buffer_size=1M
    read_rnd_buffer_size=768K
    sort_buffer_size=1M
    table_cache=1024
    thread_cache_size=100
    thread_concurrency=4
    wait_timeout=300
    query_cache_size=32M
    query_cache_limit=1M
    query_cache_type=1
    skip-innodb

    Server spec;

    Dual xeon 2.8 ghz
    1gb ram
    2 hard drives ( Not raid )
    Fairly busy server.

    Could someone please give us a good config, I have tried different combos still the sql times are fairly high. around 0.1935sec

    Thanks.

  2. #2
    Join Date
    Apr 2003
    Location
    NC
    Posts
    3,080
    Do you have mysql on a second drive? that will help a lot since you are probably running into IO issues.

    As far as the specific what is best it really depends on the server. If you do a search there are a few threads that talk about it.
    John W, CISSP, C|EH
    MS Information Security and Assurance
    ITEagleEye.com - Server Administration and Security
    Yawig.com - Managed VPS and Dedicated Servers with VIP Service

  3. #3
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,574
    Might want to reduce the query cache size a bit if it is not in use. Another GB of ram will also probably help out. Can you post your 'top' output?

    --GSV
    MediaLayer, LLC - www.medialayer.com Learn how we can make your website load faster, translating to better conversion rates for your business!
    The pioneers of optimized web hosting, featuring LiteSpeed Web Server & SSD Storage - Celebrating 10 Years in Business

  4. #4
    Join Date
    Nov 2002
    Posts
    510
    Please post the output of top and people will be of more help ..

    Well try this:

    Code:
    [mysqld]
    connect_timeout=15
    interactive_timeout=100
    join_buffer_size=512K
    key_buffer=20M
    max_allowed_packet=16M
    max_connections=500
    max_connect_errors=10
    myisam_sort_buffer_size=64M
    read_buffer_size=512K
    read_rnd_buffer_size=512K
    sort_buffer_size=512K
    table_cache=1024
    thread_cache_size=100
    thread_concurrency=4
    wait_timeout=100
    query_cache_size=32M
    query_cache_limit=1M
    query_cache_type=1
    skip-innodb
    Get help with your server optimization - A forum on server optimization...
    ExoPHPDesk - Powerful PHP HelpDesk

Posting Permissions

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