I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. I have been getting an table handler returns error 127 error
If I fix the table with myisamchk -r or -o it will work for a while and then I will get the same error again. Here are some of the stats on the table rows:1126904 index len 48091136 auto inc:1819060 table size(MYD):166 MB index size(MYI):48 MB The table has a big int, primary key, auto increment here is the out put from a myisamchk -r - recovering (with sort) MyISAM-table '../var/table.MYI' Data records: 1126904 - Fixing index 1 Found link that points at 166818084 (outside data file) at 73992880 Found link that points at 166818044 (outside data file) at 83991788 Found link that points at 166818064 (outside data file) at 125436372 - Fixing index 2 - Fixing index 3 Data records: 1126901 Index 1 is the primary key on the bigint, auto increment column. Another point I have a varchar field which has an index on it. I have heard that this can cause some problems but it has never been an issue before. Load average on the server is low 90-95% idle cpu. However mysqld is consistently using about 30% of the Memory and total utilization of memory on the server is holding about 85% of standard memory but 0.2% of swap used. Could this have anything to do with the settings for the server? Thanks for any help Michael Blood +--------------------------+-----------+ | Variable_name | Value | +--------------------------+-----------+ | Aborted_clients | 2491 | | Aborted_connects | 5 | | Bytes_received | 153499291 | | Bytes_sent | 482722726 | | Connections | 3012 | | Created_tmp_disk_tables | 8 | | Created_tmp_tables | 54 | | Created_tmp_files | 2 | | Delayed_insert_threads | 1 | | Delayed_writes | 114 | | Delayed_errors | 0 | | Flush_commands | 20 | | Handler_delete | 76317 | | Handler_read_first | 9743 | | Handler_read_key | 7400844 | | Handler_read_next | 8428214 | | Handler_read_prev | 0 | | Handler_read_rnd | 29873 | | Handler_read_rnd_next | 190413426 | | Handler_update | 123277 | | Handler_write | 6176687 | | Key_blocks_used | 249376 | | Key_read_requests | 80361241 | | Key_reads | 173557 | | Key_write_requests | 15295279 | | Key_writes | 1161751 | | Max_used_connections | 27 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 40 | | Open_files | 78 | | Open_streams | 0 | | Opened_tables | 1163 | | Questions | 398056 | | Select_full_join | 744 | | Select_full_range_join | 0 | | Select_range | 758 | | Select_range_check | 0 | | Select_scan | 4916 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 65 | | Sort_merge_passes | 0 | | Sort_range | 226 | | Sort_rows | 29639 | | Sort_scan | 753 | | Table_locks_immediate | 674329 | | Table_locks_waited | 74 | | Threads_cached | 5 | | Threads_created | 114 | | Threads_connected | 14 | | Threads_running | 1 | | Uptime | 34266 | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
