nicht angemeldet
Hi Christoph,
/usr/local/mysql/current/bin/mysql mußt Du natürlich beim setzen des symbolischen Links auf Deine Struktur anpassen.
Da habe ich noch nicht richtig begriffen.
Wahrscheinlich hat Steffen bereits auch alle Nötige im Pfad stehen - nur ist das noch nicht aktiv. Bei der SuSE ist es nicht unbedingt ausreichend, "rcmysql" zu fahren. Man muß sich einmal ganz vom System abmelden und neu wieder anmelden... oder aber tatsächlich mal den Rechner neu starten.
Habe ich gereade gemacht.
linux:/usr/local/mysql # mysqld start
linux:/usr/local/mysql # Starting mysqld daemon with databases from /var/local/mysql
030703 04:17:32 mysqld ended
Hier meine (geänderte) my.cnf:
Example mysql config file for medium systems.
This is for a system with little memory (32M - 64M) where MySQL plays
a important part and systems up to 128M very MySQL is used together with
other programs (like a web server)
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 = /tmp/mysql/mysql.sock
Here follows entries for some specific programs
The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1
Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000
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
The safe_mysqld script
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[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=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Viele Grüße
Steffen