Исходное сообщение
"Проблема с mysql " Отправлено sergvic, 26-Фев-06 11:15
>Что значит разрушение? Что в логах? Какая версия? Какой тип, структура таблицы, >настройки my.cnf и что за железо? при проверке check table пишется Key in wrong position at page 35486720 В логах ничего. Mysql 4.1.16   Таблицы MyISAM. ОС FreeBSD 5.4 Memory  1Gb my.cnf [mysqld]                                                                                                                             #port            = 3306                                                                                                               #datadir                = /var/db/mysql                                                                                             #pid-file       = /var/run/mysql/mysql.pid                                                                                           #socket         = /var/run/mysql/mysql.sock                                                                                         #log            = /var/log/mysql.log                                                                                                 log-slow-queries = /var/log/mysql_slow-queries.log                                                                                   log-update                                                                                                                           skip-locking                                                                                                                         skip-networking                                                                                                                     safe-show-database                                                                                                                   character-sets-dir = /usr/local/share/mysql/charsets                                                                                 default-character-set = cp1251                                                                                                       init-connect="SET NAMES cp1251"                                                                                                     #set-variable    = character_set_system=cp1251                                                                                       set-variable    = max_connections=200                                                                                               #set-variable    = max_user_connections=20                                                                                           set-variable    = wait_timeout=120                                                                                                   set-variable    = key_buffer_size=50M  ######                                                                                       set-variable    = max_allowed_packet=1M                                                                                             set-variable    = table_cache=512 ###############                                                                                   set-variable    = read_buffer_size=1M                                                                                               set-variable    = sort_buffer_size=1M                                                                                               set-variable    = record_buffer=10M                                                                                                 read_rnd_buffer_size = 8M                                                                                                           set-variable    = myisam_sort_buffer_size=64M                                                                                       set-variable    = thread_cache=8                                                                                                     query_cache_size = 32M                                                                                                               set-variable    = net_retry_count=5                                                                                                 set-variable    = net_write_timeout=30                                                                                               set-variable    = flush_time=600                                                                                                     set-variable    = interactive_timeout=60                                                                                             set-variable    = long_query_time=15                                                                                                 # Try number of CPU's*2 for thread_concurrency                                                                                       #set-variable        = thread_concurrency=8                                                                                         set-variable    = thread_concurrency=4