MySQL Hilfe bei Pfadangaben.

#1
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
 

Till

Administrator
#2
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.
 

Werbung

Top