>Что значит разрушение? Что в логах? Какая версия? Какой тип, структура таблицы,
>настройки 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