Announcement

Announcement Module
Collapse
No announcement yet.

Help with my.cnf (8GB Ram)(x64 Mysql)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help with my.cnf (8GB Ram)(x64 Mysql)

    We have 8GB of ram on our server,
    with x64 OS and x64 Mysql. This server
    runs only MySql. What we do with
    this server is very simple, SELECT and INSERT.
    Only two people will use this private server.
    It's not going to be used in public.
    Our biggest table is around 3GB.
    We want to make the most of that 8GB of RAM.
    I posted our my.cnf so anyone tell us
    if there are options that you think
    is wrong and inappropriate. Million thanks in advance. )

    # My.cnf

    [client]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    [mysqld]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    thread_cache_size = 8
    thread_concurrency = 16
    back_log = 50
    max_connect_errors = 10
    table_cache = 2048
    max_allowed_packet = 48M
    binlog_cache_size = 9M
    max_heap_table_size = 1500M
    sort_buffer_size = 36M
    join_buffer_size = 36M
    query_cache_size = 128M
    query_cache_limit = 2M
    ft_min_word_len = 4
    default_table_type = MYISAM
    thread_stack = 192K
    transaction_isolation = REPEATABLE-READ
    tmp_table_size = 2000M
    log-bin=mysql-bin
    log_slow_queries
    long_query_time = 2
    log_long_format
    key_buffer_size = 2000M
    read_buffer_size = 8M
    read_rnd_buffer_size = 48M
    bulk_insert_buffer_size = 512M
    myisam_sort_buffer_size = 512M
    myisam_max_sort_file_size = 10G
    myisam_max_extra_sort_file_size = 10G
    myisam_repair_threads = 1
    myisam_recover
    skip-bdb
    server-id = 1

    [mysqldump]
    quick
    max_allowed_packet = 48M

    [mysql]
    no-auto-rehash

    [isamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M

    [myisamchk]
    key_buffer = 2000M
    sort_buffer_size = 1500M
    read_buffer = 10M
    write_buffer = 10M

    [mysqlhotcopy]
    interactive-timeout

  • #2
    What storage engine do you use? InnoDB or MyISAM?

    Comment


    • #3
      please guid for Innodb engine how we should set variable on the bases of RAM to improve performance

      Comment


      • #4
        Please this this post: http://www.mysqlperformanceblog.com/2007/11/01/innodb-perfor mance-optimization-basics/

        Comment


        • #5
          Hello, thanks for the reply, we use MyISAM tables for the whole database. Thank you )

          Comment


          • #6
            You can also have a look at http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune- in-mysql-server-after-installation/

            Comment

            Working...
            X