MySQL Hilfe bei Pfadangaben.

Dieses Thema im Forum "Installation und Konfiguration" wurde erstellt von Balu, 22. Jan. 2010.

  1. Balu

    Balu New Member

    Hallo

    Habe Gestern von einem Freund eine my.cnf bekommen zur verbesserung des mysqld servers. Würde das gerne gegen meine eigene austauschen
    und brauche dazu etwas hilfe bei der pfad anpassung.

    Suse 11.1
    ISP 2.2.34

    Code:
    [client]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    port                            = 3306
    socket                          = /var/run/mysqld/mysqld.sock
    
    [mysql]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    prompt                          = u@h [d]>_
    no_auto_rehash
    
    [mysqladmin]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    
    [mysqlcheck]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    
    [mysqldump]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    max_allowed_packet              = 32M
    quote_names
    quick
    
    [mysqlimport]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    
    [mysqlshow]
    character_sets_dir              = /usr/share/mysql/charsets
    default_character_set           = utf8
    
    [isamchk]
    character_sets_dir              = /usr/share/mysql/charsets
    key_buffer_size                 = 256M
    
    [myisamchk]
    character_sets_dir              = /usr/share/mysql/charsets
    key_buffer_size                 = 256M
    
    [myisampack]
    character_sets_dir              = /usr/share/mysql/charsets
    
    [mysqld_safe]
    err_log                         = /var/log/mysql/mysql.err
    
    [mysqld]
    character_sets_dir              = /usr/share/mysql/charsets
    character_set_server            = utf8
    default_character_set           = utf8
    user                            = mysql
    port                            = 3306
    bind_address                    = 127.0.0.1
    socket                          = /var/run/mysqld/mysqld.sock
    pid_file                        = /var/run/mysqld/mysqld.pid
    log_error                       = /var/log/mysql/mysqld.err
    log_slow_queries                = /var/log/mysql/slow-queries.log
    basedir                         = /usr
    datadir                         = /var/lib/mysql
    tmpdir                          = /var/tmp
    slave_load_tmpdir               = /var/tmp
    language                        = /usr/share/mysql/english
    log_bin                         = /var/lib/mysql/mysql-bin
    relay-log                       = /var/lib/mysql/relay.log
    relay-log-index                 = /var/lib/mysql/relay.index
    relay-log-info-file             = /var/lib/mysql/relay.info
    master-info-file                = /var/lib/mysql/master.info
    #master_host                     = <hostname>
    #master_user                     = <username>
    #master_password                 = <password>
    #master_port                     = 3306
    #auto_increment_increment        = 10
    #auto_increment_offset           = 1
    server_id                       = 1
    back_log                        = 50
    sync_binlog                     = 0
    binlog_cache_size               = 1M
    max_binlog_size                 = 100M
    expire_logs_days                = 7
    slave_compressed_protocol       = 1
    lower_case_table_names          = 1
    safe_user_create                = 1
    delay_key_write                 = ALL
    myisam_recover                  = FORCE,BACKUP
    myisam_recover_threads          = 1
    key_buffer_size                 = 512M
    record_buffer                   = 2M
    join_buffer_size                = 2M
    sort_buffer_size                = 2M
    read_buffer_size                = 2M
    read_rnd_buffer_size            = 8M
    myisam_sort_buffer_size         = 64M
    max_allowed_packet              = 32M
    max_heap_table_size             = 64M
    tmp_table_size                  = 64M
    table_cache                     = 1024
    query_cache_type                = 1
    query_cache_size                = 128M
    query_cache_limit               = 16M
    thread_concurrency              = 8
    thread_cache_size               = 16
    max_connections                 = 100
    ft_max_word_len                 = 20
    ft_min_word_len                 = 3
    long_query_time                 = 3
    local_infile                    = 0
    log_warnings                    = 2
    log_queries_not_using_indexes
    log_slave_updates
    log_long_format
    skip_locking
    skip_name_resolve
    skip_external_locking
    skip_show_database
    #skip_innodb
    innodb_thread_concurrency       = 8
    innodb_buffer_pool_size         = 512M
    innodb_additional_mem_pool_size = 16M
    innodb_data_home_dir            = /var/lib/mysql
    innodb_log_arch_dir             = /var/lib/mysql
    innodb_log_group_home_dir       = /var/lib/mysql
    innodb_data_file_path           = ibdata1:2000M;ibdata2:10M:autoextend
    innodb_flush_method             = O_DIRECT
    innodb_log_file_size            = 100M
    innodb_log_buffer_size          = 8M
    innodb_log_files_in_group       = 2
    innodb_flush_log_at_trx_commit  = 2
    innodb_max_dirty_pages_pct      = 90
    innodb_lock_wait_timeout        = 120
    innodb_file_per_table
    
    [mysqlhotcopy]
    interactive_timeout
    Danke schon mal für die hilfe.
    MFG
     
  2. Till

    Till Administrator

    1) Mach eine Kopie Deiner my.cnf datei.
    2) Übernimm nur die Einstellungen die keinen Pfad beinhalten aus dem "[mysqld]" Abschnitt der neuen Datei in Deine bestehende my.cnf Datei und starte mysql neu.
     

Diese Seite empfehlen