"Reduce your overall MySQL memory footprint for system stability"

Discussion in 'Server Operation' started by Stephan, Jun 11, 2009.

  1. Stephan

    Stephan New Member

    MySQLTuner says:
    how can i do that in centos5?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    MySQLTuner should tell you which variables you should adjust.
     
  3. Stephan

    Stephan New Member

    -------- Recommendations -----------------------------------------------------
    General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Enable the slow query log to troubleshoot bad queries

    somebody knows how to do it?
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's in /etc/my.cnf?
     
  5. Stephan

    Stephan New Member

    but even when i don't have anything on /etc/my.cnf i keep getting this message

    2 quad cores + 10GB

    [mysqld]
    #local-infile=0
    #external-locking
    memlock
    myisam_recover

    skip-name-resolve

    max_connect_errors = 1000000

    max_connections = 10000

    innodb_additional_mem_pool_size = 16M
    innodb_buffer_pool_size = 4G
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_file_io_threads = 4
    innodb_thread_concurrency = 16
    innodb_max_dirty_pages_pct = 90
    innodb_lock_wait_timeout = 120


    key_buffer = 32M
    read_buffer_size = 2M
    read_rnd_buffer_size = 16M
    bulk_insert_buffer_size = 64M
    myisam_sort_buffer_size = 128M

    table_open_cache = 2048

    sort_buffer_size = 8M
    join_buffer_size = 8M
    thread_concurrency = 32
    thread_stack = 1M
    transaction_isolation = REPEATABLE-READ

    myisam_sort_buffer_size = 64M
    table_cache = 5000
    thread_cache_size = 700

    wait_timeout = 10
    connect_timeout = 10
    interactive_timeout=10

    max_heap_table_size = 64M
    max_allowed_packet = 64M

    query_cache_limit = 4M
    query_cache_size =128M
    query_cache_type = 1

    #log
    #log_warnings

    [mysqld_safe]
    # Increase the amount of open files allowed per process. Warning: Make
    # sure you have set the global system limit high enough! The high value
    # is required for a large number of opened tables
    open-files-limit = 8192
     

Share This Page