mySQL Konfiguration für vServer

Thorsten

SSF Facilitymanagement
Staff member
Hier eine mySQL Beispiel Konfiguration für Serversysteme denen wenig realer Speicher (RAM) zur Verfügung steht (beispielsweise vServer).

mfG
Thorsten
--

# Example mysql config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld deamon
# doesn't use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=16K
set-variable = max_allowed_packet=1M
set-variable = thread_stack=64K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_length=2K
server-id = 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[mysqlhotcopy]
interactive-timeout
 
G

Guest

Guest
in welches File müssen diese Änderungen übernommen werden?
 

Thorsten

SSF Facilitymanagement
Staff member
Hallo Tobias,
das ganze ist im Prinzip die gesamte Konfigurationsdatei. Sieh mal nach ob du im Verzeichnis /etc die Datei my.cnf hast. Genau das ist die Konfig-Datei.

mfG
Thorsten
 
G

Guest

Guest
Für alle diejenigen, die nicht wollen daß die Datenbank von Fremdrechnern erreichbar ist können noch:
Code:
[mysqld]
skip-networking
einfügen. (spart auch (wenige) Resourcen)

Zusätzlich empfehle ich:
Code:
[mysqldump]
quick
set-variable    = max_allowed_packet=16M
fields-terminated-by=;
fields-enclosed-by="
fields-escaped-by=\\
lines-terminated-by=\r\n

[mysqlimport]
fields-terminated-by=;
fields-enclosed-by="
fields-escaped-by=\\
lines-terminated-by=\r\n
Erst damit kann man mysqldump und mysqlimport vernünftig nutzen.
Mit diesen Zeilen verarbeiten die Programme direkt CSV-Dateien.

huschi the husch[/code]
 
Last edited by a moderator:
Top