MySQL Forums
Forum List  »  MyISAM

MyISAM Index corruption
Posted by: shiraz khalid
Date: April 03, 2006 01:27AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM Index corruption
2812
April 03, 2006 01:27AM
1896
April 03, 2006 07:31AM
1789
April 03, 2006 09:04AM
1871
April 04, 2006 03:50AM
1756
April 04, 2006 11:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.