Hi,
I've run myisampack to compress a table and am now trying to recreate the index using myisamchk (as root) but I get an error 27.
# myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp internet_usage.MYI
- check record delete-chain
- recovering (with sort) MyISAM-table 'internet_usage.MYI'
Data records: 30972875
- Fixing index 1
myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode: 27)
myisamchk: error: 27 when fixing table
MyISAM-table 'internet_usage.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
# perror 27
Error code 27: A file cannot be larger than the value set by ulimit.
The ulimits are set as follows:
default: fsize = 2097151 core = 2097151 cpu = -1 data = 262144 rss = 65536 stack = 65536 nofiles = 2000
root: fsize = -1 core = -1 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = 4000
When I run myisamchk, is it running with root privilidges or as user mysql? By the way this is a large enabled filesystem.
Thanks,
JS.
Also, how do you get the --debug option to work in myisamchk ? I've tried different combinations without success e.g.
myisamchk -rq --sort-index --analyze --debug=d,/proxydb/mysql/tmp/debug.out --tmpdir=/proxydb/mysql/tmp internet_usage.MYI
as the option hints: -#, --debug=... Output debug log. Often this is 'd:t:o,filename'
I wondered if there are any variables below I could set which might help?
Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ----------------------------- character-sets-dir (No default value) data-file-length 0 keys-used 18446744073709551615 set-auto-increment 0 set-character-set (No default value) sort-records 0 tmpdir (No default value) key_buffer_size 268431360 myisam_block_size 1024 read_buffer_size 2097144 write_buffer_size 2097144 sort_buffer_size 268435448 sort_key_blocks 16 decode_bits 9 ft_min_word_len 4 ft_max_word_len 254 ft_max_word_len_for_sort 20 ft_stopword_file (No default value)
Also forgot to add this information earlier:
# myisamchk -dvv internet_usage
MyISAM file: internet_usage Record format: Compressed Character set: latin1 (8) File-version: 1 Creation time: 2004-07-09 14:05:56 Recover time: 2004-10-26 16:12:26 Status: crashed Checksum: 25799250 Data records: 247782993 Deleted blocks: 0 Datafile parts: 247782993 Deleted data: 0 Datafile pointer (bytes): 5 Keyfile pointer (bytes): 3 Datafile length: 16718081924 Keyfile length: 1024 Max datafile length: 1099511627774 Max keyfile length: 17179868159 Recordlength: 32
table description:
Key Start Len Index Type Rec/key Root Blocksize
1 2 4 multip. unsigned long 0 1024
Field Start Length Nullpos Nullbit Type Huff tree Bits
1 1 1 constant 1 0
2 2 4 zerofill(2) 2 9
3 6 4 3 9
4 10 4 4 9
5 14 4 5 9
6 18 2 1 2 6 9
7 20 4 1 4 7 9
8 24 4 1 8 8 9
9 28 1 9 9
10 29 1 10 9
11 30 1 9 9
12 31 2 table-lockup 11 0
Would really appreciate any help on this.
Thanks,
JS.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]