I am running MySQL 5.0.19 which i downloaded as a binary on my RHEL 3 with 6G RAM and Dual 2.8GHz Pentiums on a HP DL380 and the data directory is on an external Compaq RAID
I am constantly getting index corruptions. On average my table inserts are about 1.6 lines per day.
I have read about compiling MySQL without linuxthreads to go around a bug but have not found how to do that. i dont know the compiler directive to do that.
http://forums.mysql.com/read.php?21,37901,38086#msg-38086
also the top shows:
Mem: 5932084k av, 5913932k used, 18152k free, 0k shrd, 5036k buff
4574436k actv, 569680k in_d, 95716k in_c
Swap: 2044072k av, 52k used, 2044020k free 5485960k cache
some how mysql is eating up all the memory. when i restart the system, and run a query, the used goes from about 100Megs to almost 6Gigs as seen in the top. cant quite understand why
my my.cnf looks like:
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-external-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
thread_concurrency = 16
thread_cache_size=100
character-sets=latin1
#log-bin
#log-long-format
#log-slow-queries
set-variable = wait_timeout=1800
set-variable = interactive_timeout=1800
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
all i get in the error log is
60403 2:20:44 [ERROR] /usr/local/mysql/bin/mysqld: Table './cdrs/RATEDCDR' is marked as crashed and should be repaired
i can repair the tables with myisamchk -r RATEDCDR but it takes a while since the table is about 30 Gigs
I had upgraded from MySQL 4 some time back, but didnt just move the tables, but actually dumped the data and reinserted it so that cannot be an issue
I need help to diagnose the issue and solve it. i cant quite figure out what is corrupting the index and how the fix the problems
Any help would be greatly appreciated.
Thanks for the help in advance
Edited 2 time(s). Last edit at 04/03/2006 02:08AM by shiraz khalid.