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.

Help with my.cnf

Discussion in 'Workarounds and Optimization' started by farmorais, Jan 29, 2013.

  1. farmorais

    farmorais Registered

    Joined:
    Aug 6, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I configurated the /etc/my.cnf to my server, because the MySQL was not killing the process and even freezing my machine sometimes with the memory usage.

    But, with the configuration I did, looks like the memory usage still increasing, even when the mysql processes are being killed.


    The configuration of /etc/my.cnf:

    [mysqld]
    innodb_file_per_table=1
    set-variable = max_connections=1000
    key_buffer =2048M
    table_cache = 36272
    open_files_limit = 16344
    join_buffer_size = 8M
    read_buffer_size = 8M
    sort_buffer_size = 8M
    tmp_table_size=512M
    read_rnd_buffer_size=8M
    max_heap_table_size=256M
    myisam_sort_buffer_size=256M
    thread_cache_size=8
    thread_cache=8192
    query_cache_type=1
    query_cache_limit=512M
    query_cache_size=1024M
    thread_concurrency = 8
    wait_timeout = 10
    connect_timeout = 10
    interactive_timeout = 10
    long_query_time=1
    log-slow-queries = /var/log/mysqlslowqueries.log
    max_allowed_packet=128M


    My server is one i7-2600K CPU @ 3.40GHz with 32Gb RAM and I don't know what to do to stop the memory usage increasing.

    Any help?

    Regards,

    Fabio Morais
     
Loading...

Share This Page