phpbar.de logo

Mailinglisten-Archive

Kommunikationsfehler --- was zu tun????
Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Kommunikationsfehler --- was zu tun????



Hallo,

es werden immer wieder prozesse abgebrochen mit dieser mistigen
Fehlermeldung:
	Fehler 127. (table handler)
damit kann ich absolut nichts anfangen.

In der log-Datei stehen sehr viele Meldungen der Form:

001123 10:26:01  Verbindungsabbruch  63 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:26:36  Verbindungsabbruch  65 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:27:00  Verbindungsabbruch  69 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:27:02  Verbindungsabbruch  70 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:27:12  Verbindungsabbruch  71 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:28:01  Verbindungsabbruch  74 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:28:45  Verbindungsabbruch  27 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:29:00  Verbindungsabbruch  82 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:30:01  Verbindungsabbruch  84 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)
001123 10:30:07  Verbindungsabbruch  85 zu db: 'archiv' user: 'hkt' host:
`localhost' (Fehler beim Lesen eines Communication-Packets)

Ich fahre die aktuelle (..28) version von mysql und myisamchk bringt keine
Fehler.

Das ganze System ist äußerst instabil.


Wer kann mir helfen?


Danke

Dieter


Dr. med. Dipl.-Math. Dieter Becker
Medizinische Universitäts- und Poliklinik
Innere Medizin III
D66421 Homburg
-----------------------------------------
Tel: 06841 16 3046 / -3077
Fax: 06841 16 3043 / -3385
Email: db_(at)_med-in.uni-sb.de
# mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/var) 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.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
set-variable	= key_buffer=256M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=256
set-variable	= sort_buffer=1M
set-variable	= record_buffer=1M
set-variable	= myisam_sort_buffer_size=64M
set-variable	= thread_cache=8
set-variable	= thread_concurrency=8
log
log-bin		= /d1/mysql/binlog
log-bin-index	= /d1/mysql/binlog.index
log-update	= /d1/mysql/updatelog
datadir		= /d1/mysql
tmpdir		= /tmp
language	= german

# Uncomment the following if you are using BDB tables
#set-variable	= bdb_cache_size=64M

# Point the following paths to different dedicated disks
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname

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

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

[isamchk]
set-variable	= key_buffer=128M
set-variable	= sort_buffer=128M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[myisamchk]
set-variable	= key_buffer=128M
set-variable	= sort_buffer=128M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

Home | Main Index | Thread Index

php::bar PHP Wiki   -   Listenarchive