Hi :) I'm having trouble using "LOAD INDEX INTO CACHE". It isn't loading any index blocks!
I am using 4.1.7-standard, for pc-linux on i686 on a redhat box. mysqladmin debug reports this, before a LOAD INDEX: Key caches: default Buffer_size: 2147483648 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 So I do this: mysql> load index into cache records_x -> ; +----------------------+--------------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------------+--------------+----------+----------+ | test.records_x | preload_keys | status | OK | +----------------------+--------------+----------+----------+ 1 row in set (0.01 sec) And then no index appears to have been loaded. Despite the index file being 800MB in size, after issuing this command there appears to be no disk IO, and no cpu used by mysql. It also returns immediately (0.01 sec) when it should take at least 10 seconds or so to read 800MB from the disk. Key caches: default Buffer_size: 2147483648 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 I have tried creating specific caches too instead of using the default one, but that makes no difference. Myisamcheck -dvi reports: MyISAM file: records_x Record format: Fixed length Character set: latin1_swedish_ci (8) File-version: 1 Creation time: 2004-09-20 0:59:10 Recover time: 2004-10-17 3:54:44 Status: checked,analyzed Data records: 36322509 Deleted blocks: 0 Datafile parts: 36322509 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3 Datafile length: 435870108 Keyfile length: 814886912 Max datafile length: 51539607550 Max keyfile length: 17179868159 Recordlength: 12 table description: Key Start Len Index Type Rec/key Root Blocksize 1 2 4 unique unsigned long 1 1024 1024 2 9 4 multip. unsigned long 2244 163126272 1024 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 4 3 6 3 4 9 4 Other perhaps pertinant information via mysqladmin debug is: Memory status: Non-mmapped space allocated from system: 3780612 Number of free chunks: 8 Number of fastbin blocks: 0 Number of mmapped regions: 11 Space in mmapped regions: -2100240384 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 3747644 Total free space: 32968 Top-most, releasable space: 11488 Estimated memory (with thread stack): -2096332796 Status information: Current dir: /var/lib/mysql/ Running threads: 2 Stack size: 126976 Cheers! Andrew. __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
