Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2004
    Posts
    30

    my.cnf file has only 2 lines...

    My /etc/my.cnf is like this.

    [mysqld]
    set-variable = max_connections=500
    safe-show-database


    I am on RHEL/cPanel/MySQL 4.0.24/PHP4.3.11. It is a Dual Xeon Server with 2 GB Ram with around 150 sites on the server.

    Though I have not faced any problems till now with the existing my.cnf file...Please tell me if my 'my.cnf' config is sufficient? ..if not...then can you please suggest a my.cnf configuration that can help in optimising my servers performance...Thanks for your help...

  2. #2
    Join Date
    Aug 2004
    Location
    Sydney, Australia
    Posts
    464
    Is MySQL overloading your server? What's your average load like?
    Net Logistics Web Hosting - Solutions Through Innovation

  3. #3
    Join Date
    Nov 2004
    Posts
    30
    Though I have not faced any problems till now with the existing my.cnf file...Please tell me if my 'my.cnf' config is sufficient?

  4. #4
    Join Date
    Dec 2004
    Location
    New York, NY
    Posts
    10,574
    I use:

    Code:
    [mysqld]
    max_connections = 500
    key_buffer = 32M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 16M
    query_cache_type = 1
    skip-innodb
    
    [mysqld_safe]
    open_files_limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
    Works perfect.

    HTH

    -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

  5. #5
    Greetings:

    Is there a way to verify or otherwise prove /etc/my.cnf is being used by mySQL?

    Thank you.
    ---
    Peter M. Abraham
    LinkedIn Profile

Posting Permissions

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