• 27-11-2017, 16:11:42
    #1
    Linux sunucularınızda mysql performans problemi yaşıyorsanız aşağıda ki kodları
    /etc/my.cnf dosyasını bu şekilde düzenleyiniz.
    [mysqld]
    bind-address = 127.0.0.1
    local-infile=0
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    ##Mysql bypass güvenliği kodu
    set-variable=local-infile=0
    ##
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    max_connections = 400    
    max_user_connections=40    
    key_buffer_size = 256M    
    myisam_sort_buffer_size = 16M    
    read_buffer_size = 1M
    table_open_cache = 2048
    thread_cache_size = 128
    wait_timeout = 20
    connect_timeout = 10
    tmp_table_size = 128M
    max_heap_table_size = 64M
    max_allowed_packet=268435456
    net_buffer_length = 5500
    max_connect_errors = 10
    concurrent_insert = 2
    read_rnd_buffer_size = 242144
    bulk_insert_buffer_size = 2M
    query_cache_limit = 2M
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 87382
    query_alloc_block_size = 21845
    transaction_alloc_block_size = 2730
    transaction_prealloc_size = 1364
    max_write_lock_count = 2
    log-error
    external-locking=FALSE
    open_files_limit=15000
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    [mysqld_safe]
      [mysqldump]
    quick
    max_allowed_packet = 8M
    [isamchk]
    key_buffer = 128M
    sort_buffer = 128M
    read_buffer = 64M
    write_buffer = 64M
      [myisamchk]
    key_buffer = 128M
    sort_buffer = 128M
    read_buffer = 64M
    write_buffer = 64M
      #### Per connection configuration ####
    sort_buffer_size = 2M
    join_buffer_size = 2M
    thread_stack = 192K
    log-slow-queries
      
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    sonrasında
    ssh a bağlanıp
    service mysqld restart
    ve yola devam
  • 28-11-2017, 09:53:08
    #2
    GiRGiN adlı üyeden alıntı: mesajı görüntüle
    Linux sunucularınızda mysql performans problemi yaşıyorsanız aşağıda ki kodları
    /etc/my.cnf dosyasını bu şekilde düzenleyiniz.
    [mysqld]
    bind-address = 127.0.0.1
    local-infile=0
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    ##Mysql bypass güvenliği kodu
    set-variable=local-infile=0
    ##
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    max_connections = 400    
    max_user_connections=40    
    key_buffer_size = 256M    
    myisam_sort_buffer_size = 16M    
    read_buffer_size = 1M
    table_open_cache = 2048
    thread_cache_size = 128
    wait_timeout = 20
    connect_timeout = 10
    tmp_table_size = 128M
    max_heap_table_size = 64M
    max_allowed_packet=268435456
    net_buffer_length = 5500
    max_connect_errors = 10
    concurrent_insert = 2
    read_rnd_buffer_size = 242144
    bulk_insert_buffer_size = 2M
    query_cache_limit = 2M
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 87382
    query_alloc_block_size = 21845
    transaction_alloc_block_size = 2730
    transaction_prealloc_size = 1364
    max_write_lock_count = 2
    log-error
    external-locking=FALSE
    open_files_limit=15000
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    [mysqld_safe]
      [mysqldump]
    quick
    max_allowed_packet = 8M
    [isamchk]
    key_buffer = 128M
    sort_buffer = 128M
    read_buffer = 64M
    write_buffer = 64M
      [myisamchk]
    key_buffer = 128M
    sort_buffer = 128M
    read_buffer = 64M
    write_buffer = 64M
      #### Per connection configuration ####
    sort_buffer_size = 2M
    join_buffer_size = 2M
    thread_stack = 192K
    log-slow-queries
      
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    sonrasında
    ssh a bağlanıp
    service mysqld restart
    ve yola devam
    Paylaşımın için teşekkürler hocam