Mailinglisten-Archive |
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
php::bar PHP Wiki - Listenarchive