mysql ha_err_key_not_found_Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;？

原帖由 jinguanding 于 2011-5-9 09:11 发表

这种方法少用，因为是掩盖报错，而没解决真实问题...

--   从库的所有配置参数，通过show variables;获取

'auto_increment_increment', '1'

'auto_increment_offset', '1'

'autocommit', 'ON'

'automatic_sp_privileges', 'ON'

'back_log', '50'

'basedir', '/usr/local/mysql/'

'big_tables', 'OFF'

'binlog_cache_size', '32768'

'binlog_direct_non_transactional_updates', 'OFF'

'binlog_format', 'MIXED'

'bulk_insert_buffer_size', '8388608'

'character_set_client', 'utf8'

'character_set_connection', 'utf8'

'character_set_database', 'utf8'

'character_set_filesystem', 'binary'

'character_set_results', 'utf8'

'character_set_server', 'utf8'

'character_set_system', 'utf8'

'character_sets_dir', '/usr/local/mysql/share/mysql/charsets/'

'collation_connection', 'utf8_general_ci'

'collation_database', 'utf8_general_ci'

'collation_server', 'utf8_general_ci'

'completion_type', '0'

'concurrent_insert', '1'

'connect_timeout', '10'

'datadir', '/usr/local/mysql/var/'

'date_format', '%Y-%m-%d'

'datetime_format', '%Y-%m-%d %H:%i:%s'

'default_week_format', '0'

'delay_key_write', 'ON'

'delayed_insert_limit', '100'

'delayed_insert_timeout', '300'

'delayed_queue_size', '1000'

'div_precision_increment', '4'

'engine_condition_pushdown', 'ON'

'error_count', '0'

'event_scheduler', 'OFF'

'expire_logs_days', '0'

'flush', 'OFF'

'flush_time', '0'

'foreign_key_checks', 'ON'

'ft_boolean_syntax', '+ ->

'ft_max_word_len', '84'

'ft_min_word_len', '4'

'ft_query_expansion_limit', '20'

'ft_stopword_file', '(built-in)'

'general_log', 'OFF'

'general_log_file', '/usr/local/mysql/var/sh-192-168-250-40.log'

'group_concat_max_len', '1024'

'have_community_features', 'YES'

'have_compress', 'YES'

'have_crypt', 'YES'

'have_csv', 'YES'

'have_dynamic_loading', 'NO'

'have_geometry', 'YES'

'have_innodb', 'YES'

'have_ndbcluster', 'DISABLED'

'have_openssl', 'NO'

'have_partitioning', 'YES'

'have_query_cache', 'YES'

'have_rtree_keys', 'YES'

'have_ssl', 'NO'

'have_symlink', 'YES'

'hostname', 'sh-192-168-250-40.chinascopefinancial.com'

'identity', '0'

'ignore_builtin_innodb', 'OFF'

'init_connect', ''

'init_file', ''

'init_slave', ''

'innodb_adaptive_hash_index', 'ON'

'innodb_additional_mem_pool_size', '1048576'

'innodb_autoextend_increment', '8'

'innodb_autoinc_lock_mode', '1'

'innodb_buffer_pool_size', '8388608'

'innodb_checksums', 'ON'

'innodb_commit_concurrency', '0'

'innodb_concurrency_tickets', '500'

'innodb_data_file_path', 'ibdata1:10M:autoextend'

'innodb_data_home_dir', ''

'innodb_doublewrite', 'ON'

'innodb_fast_shutdown', '1'

'innodb_file_io_threads', '4'

'innodb_file_per_table', 'OFF'

'innodb_flush_log_at_trx_commit', '1'

'innodb_flush_method', ''

'innodb_force_recovery', '0'

'innodb_lock_wait_timeout', '50'

'innodb_locks_unsafe_for_binlog', 'OFF'

'innodb_log_buffer_size', '1048576'

'innodb_log_file_size', '5242880'

'innodb_log_files_in_group', '2'

'innodb_log_group_home_dir', './'

'innodb_max_dirty_pages_pct', '90'

'innodb_max_purge_lag', '0'

'innodb_mirrored_log_groups', '1'

'innodb_open_files', '300'

'innodb_rollback_on_timeout', 'OFF'

'innodb_stats_on_metadata', 'ON'

'innodb_support_xa', 'ON'

'innodb_sync_spin_loops', '20'

'innodb_table_locks', 'ON'

'innodb_thread_concurrency', '8'

'innodb_thread_sleep_delay', '10000'

'innodb_use_legacy_cardinality_algorithm', 'ON'

'insert_id', '0'

'interactive_timeout', '28800'

'join_buffer_size', '131072'

'keep_files_on_create', 'OFF'

'key_buffer_size', '1451229184'

'key_cache_age_threshold', '300'

'key_cache_block_size', '1024'

'key_cache_division_limit', '100'

'language', '/usr/local/mysql/share/mysql/english/'

'large_files_support', 'ON'

'large_page_size', '0'

'large_pages', 'OFF'

'last_insert_id', '0'

'lc_time_names', 'en_US'

'license', 'GPL'

'local_infile', 'ON'

'locked_in_memory', 'OFF'

'log', 'OFF'

'log_bin', 'ON'

'log_bin_trust_function_creators', 'ON'

'log_bin_trust_routine_creators', 'ON'

'log_error', '/usr/local/mysql/var/sh-192-168-250-40.chinascopefinancial.com.err'

'log_output', 'FILE'

'log_queries_not_using_indexes', 'OFF'

'log_slave_updates', 'ON'

'log_slow_queries', 'OFF'

'log_warnings', '1'

'long_query_time', '10.000000'

'low_priority_updates', 'OFF'

'lower_case_file_system', 'OFF'

'lower_case_table_names', '0'

'max_allowed_packet', '33554432'

'max_binlog_cache_size', '18446744073709547520'

'max_binlog_size', '1073741824'

'max_connect_errors', '10'

'max_connections', '151'

'max_delayed_threads', '20'

'max_error_count', '64'

'max_heap_table_size', '16777216'

'max_insert_delayed_threads', '20'

'max_join_size', '18446744073709551615'

'max_length_for_sort_data', '1024'

'max_prepared_stmt_count', '16382'

'max_relay_log_size', '0'

'max_seeks_for_key', '18446744073709551615'

'max_sort_length', '1024'

'max_sp_recursion_depth', '0'

'max_tmp_tables', '32'

'max_user_connections', '0'

'max_write_lock_count', '18446744073709551615'

'min_examined_row_limit', '0'

'multi_range_count', '256'

'myisam_data_pointer_size', '6'

'myisam_max_sort_file_size', '9223372036853727232'

'myisam_mmap_size', '18446744073709551615'

'myisam_recover_options', 'OFF'

'myisam_repair_threads', '1'

'myisam_sort_buffer_size', '268435456'

'myisam_stats_method', 'nulls_unequal'

'myisam_use_mmap', 'OFF'

'ndb_autoincrement_prefetch_sz', '1'

'ndb_cache_check_time', '0'

'ndb_connectstring', ''

'ndb_extra_logging', '0'

'ndb_force_send', 'ON'

'ndb_index_stat_cache_entries', '32'

'ndb_index_stat_enable', 'OFF'

'ndb_index_stat_update_freq', '20'

'ndb_report_thresh_binlog_epoch_slip', '3'

'ndb_report_thresh_binlog_mem_usage', '10'

'ndb_use_copying_alter_table', 'OFF'

'ndb_use_exact_count', 'ON'

'ndb_use_transactions', 'ON'

'net_buffer_length', '16384'

'net_read_timeout', '30'

'net_retry_count', '10'

'net_write_timeout', '60'

'new', 'OFF'

'old', 'OFF'

'old_alter_table', 'OFF'

'old_passwords', 'OFF'

'open_files_limit', '1185'

'optimizer_prune_level', '1'

'optimizer_search_depth', '62'

'optimizer_switch', 'index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on'

'pid_file', '/usr/local/mysql/var/sh-192-168-250-40.chinascopefinancial.com.pid'

'plugin_dir', '/usr/local/mysql/lib/mysql/plugin'

'port', '3306'

'preload_buffer_size', '32768'

'profiling', 'OFF'

'profiling_history_size', '15'

'protocol_version', '10'

'pseudo_thread_id', '46'

'query_alloc_block_size', '8192'

'query_cache_limit', '1048576'

'query_cache_min_res_unit', '4096'

'query_cache_size', '268435456'

'query_cache_type', 'ON'

'query_cache_wlock_invalidate', 'OFF'

'query_prealloc_size', '8192'

'rand_seed1', ''

'rand_seed2', ''

'range_alloc_block_size', '4096'

'read_buffer_size', '16777216'

'read_only', 'ON'

'read_rnd_buffer_size', '33554432'

'relay_log', 'relay-bin'

'relay_log_index', 'relay-bin'

'relay_log_info_file', 'relay-log.info'

'relay_log_purge', 'ON'

'relay_log_space_limit', '0'

'report_host', ''

'report_password', ''

'report_port', '3306'

'report_user', ''

'rpl_recovery_rank', '0'

'secure_auth', 'OFF'

'secure_file_priv', ''

'server_id', '2'

'skip_external_locking', 'ON'

'skip_name_resolve', 'OFF'

'skip_networking', 'OFF'

'skip_show_database', 'OFF'

'slave_compressed_protocol', 'OFF'

'slave_exec_mode', 'STRICT'

'slave_load_tmpdir', '/tmp'

'slave_net_timeout', '3600'

'slave_skip_errors', '1032'

'slave_transaction_retries', '10'

'slow_launch_time', '2'

'slow_query_log', 'OFF'

'slow_query_log_file', '/usr/local/mysql/var/sh-192-168-250-40-slow.log'

'socket', '/usr/local/mysql/tmp/mysql.sock'

'sort_buffer_size', '16777216'

'sql_auto_is_null', 'ON'

'sql_big_selects', 'ON'

'sql_big_tables', 'OFF'

'sql_buffer_result', 'OFF'

'sql_log_bin', 'ON'

'sql_log_off', 'OFF'

'sql_log_update', 'ON'

'sql_low_priority_updates', 'OFF'

'sql_max_join_size', '18446744073709551615'

'sql_mode', ''

'sql_notes', 'ON'

'sql_quote_show_create', 'ON'

'sql_safe_updates', 'OFF'

'sql_select_limit', '18446744073709551615'

'sql_slave_skip_counter', ''

'sql_warnings', 'OFF'

'ssl_ca', ''

'ssl_capath', ''

'ssl_cert', ''

'ssl_cipher', ''

'ssl_key', ''

'storage_engine', 'MyISAM'

'sync_binlog', '0'

'sync_frm', 'ON'

'system_time_zone', 'CST'

'table_definition_cache', '256'

'table_lock_wait_timeout', '50'

'table_open_cache', '512'

'table_type', 'MyISAM'

'thread_cache_size', '8'

'thread_handling', 'one-thread-per-connection'

'thread_stack', '262144'

'time_format', '%H:%i:%s'

'time_zone', 'SYSTEM'

'timed_mutexes', 'OFF'

'timestamp', '1304903843'

'tmp_table_size', '16777216'

'tmpdir', '/tmp'

'transaction_alloc_block_size', '8192'

'transaction_prealloc_size', '4096'

'tx_isolation', 'REPEATABLE-READ'

'unique_checks', 'ON'

'updatable_views_with_limit', 'YES'

'version', '5.1.53-log'

'version_comment', 'Source distribution'

'version_compile_machine', 'x86_64'

'version_compile_os', 'unknown-linux-gnu'

'wait_timeout', '28800'

'warning_count', '0'