sslug-teknik team mailing list archive

[Johnny Ernst Nielsen <johnny.ernst.nielsen@xxxxxxxxxx>]

God dag Niklas,

Tirsdag den 4. februar 2003 16:43 kvad du:
> > > > Der er faktisk hele 3, lige så snart computeren er startet.
> > >
> > > Vad menar du, kör du 3 forskellige mysqld?
> >
> > I min processliste (KDE ProcessTable) figurerer 3 x mysqld
> > De har hver deres PID
> > Derudover er de ens:
> > 0% bruger, 0% system, 0 nice, 20920 VmSize, 2228VmRss,
> > bruger=mysql, kommando=/usr/sbin/mysqld
>
> Aah ok, det skulle vara ok, vi vill bara vara säkra på att du har 1
> MySQL server, vad säger ps -ef|grep mysqld_safe (eller safe_mysqld)
> från din shell?

shell>ps -ef|grep safe_mysqld
root      1375     1  0 15:53 ?        00:00:00 /bin/sh 
/usr/bin/safe_mysqld --user=mysql 
--pid-file=/var/lib/mysql/mysqld.pid 
--socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql

> Testade du igen efter din restart?

Ja.

> Om det inte funkar fortfarande,
> vilka permissions (och ownership och group) har /etc/my.cnf?

shell>ls -l /etc/my.cnf
-rw-------    1 mysql    daemon       2594 2003-02-04 14:58 
/etc/my.cnf

> Kan vi också få se vad du har i den?

Ja da :o)

---o| my.cnf start |o---

# 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 = /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=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]
skip-column-names
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

---o| my.cnf slut |o---

Hilsen Johnny :o)