Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    3

    Exclamation Unanswered: Index error? (mysql version 3.23.46-max)

    Here is the error message I received.
    InnoDB: Could not find key n 0 with name PRIMARY from dict cache

    The server is running slow during the day and has started crashing regularly at least once per business day.

    Where should I start? - im a mysql newbie.

    The database is size is about 52mb in size.

    thanks
    charley

  2. #2
    Join Date
    Sep 2006
    Posts
    3

    attached below is the winmysqladmin report

    This Report was made using the WinMySQLAdmin 1.3 Tool

    9/18/2006 3:30:18 PM

    Machine description:
    Compiler : VC++ 6.0
    Architecture : i686
    Total Memory : 1048048 KB RAM

    My.ini File
    [mysqld]
    innodb_data_file_path=ibdata1:400M
    innodb_data_home_dir=C:\MySQL\ibdata
    set-variable=innodb_mirrored_log_groups=1
    innodb_log_group_home_dir=C:\MySQL\iblogs
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    innodb_flush_log_at_trx_commit=1
    innodb_log_arch_dir=C:\MySQL\iblogs
    innodb_log_archive=0
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=80M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M
    set-variable=innodb_buffer_pool_size=40M
    set-variable=innodb_additional_mem_pool_size=10M
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50
    set-variable=innodb_mirrored_log_groups=1
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=15M
    set-variable=innodb_log_buffer_size=4M

  3. #3
    Join Date
    Sep 2006
    Posts
    3
    continued.
    Server Status Values

    Server Info 3.23.46-max
    Host Info localhost via TCP/IP
    Client Info 3.23.44
    Proto Info 10
    Aborted_clients 24
    Aborted_connects 1
    Bytes_received 0
    Bytes_sent 0
    Connections 112
    Created_tmp_disk_tables 38
    Created_tmp_tables 455
    Created_tmp_files 4
    Delayed_insert_threads 0
    Delayed_writes 0
    Delayed_errors 0
    Flush_commands 1
    Handler_delete 0
    Handler_read_first 33773
    Handler_read_key 14678850
    Handler_read_next 8124126
    Handler_read_prev 0
    Handler_read_rnd 235167
    Handler_read_rnd_next 227782311
    Handler_update 129812
    Handler_write 2389233
    Key_blocks_used 22
    Key_read_requests 3658
    Key_reads 2
    Key_write_requests 1042
    Key_writes 0
    Max_used_connections 35
    Not_flushed_key_blocks 0
    Not_flushed_delayed_rows 0
    Open_tables 64
    Open_files 24
    Open_streams 0
    Opened_tables 569
    Questions 1330818
    Select_full_join 27
    Select_full_range_join 0
    Select_range 401
    Select_range_check 0
    Select_scan 3052
    Slave_running OFF
    Slave_open_temp_tables 0
    Slow_launch_threads 0
    Slow_queries 89
    Sort_merge_passes 2
    Sort_range 261
    Sort_rows 254711
    Sort_scan 481
    Table_locks_immediate 6620987
    Table_locks_waited 0
    Threads_cached 0
    Threads_created 111
    Threads_connected 35
    Threads_running 16
    Uptime 4746
    Variables Values
    back_log 50
    basedir C:\mysql\
    bdb_cache_size 8388600
    bdb_log_buffer_size 32768
    bdb_home C:\mysql\data\
    bdb_max_lock 10000
    bdb_logdir
    bdb_shared_data OFF
    bdb_tmpdir C:\WINDOWS\TEMP\
    bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (November 29, 2001)
    binlog_cache_size 32768
    character_set latin1
    character_sets latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
    concurrent_insert ON
    connect_timeout 5
    datadir C:\mysql\data\
    delay_key_write ON
    delayed_insert_limit 100
    delayed_insert_timeout 300
    delayed_queue_size 1000
    flush OFF
    flush_time 1800
    have_bdb YES
    have_gemini NO
    have_innodb YES
    have_isam YES
    have_raid NO
    have_openssl NO
    init_file
    innodb_additional_mem_pool_size 10485760
    innodb_buffer_pool_size 41943040
    innodb_data_file_path ibdata1
    innodb_data_home_dir C:\MySQL\ibdata
    innodb_file_io_threads 4
    innodb_force_recovery 0
    innodb_thread_concurrency 8
    innodb_flush_log_at_trx_commit ON
    innodb_fast_shutdown ON
    innodb_flush_method
    innodb_lock_wait_timeout 50
    innodb_log_arch_dir C:\MySQL\iblogs
    innodb_log_archive OFF
    innodb_log_buffer_size 4194304
    innodb_log_file_size 15728640
    innodb_log_files_in_group 3
    innodb_log_group_home_dir C:\MySQL\iblogs
    innodb_mirrored_log_groups 1
    interactive_timeout 28800
    join_buffer_size 131072
    key_buffer_size 8388600
    language C:\mysql\share\english\
    large_files_support ON
    log OFF
    log_update OFF
    log_bin OFF
    log_slave_updates OFF
    log_long_queries OFF
    long_query_time 10
    low_priority_updates OFF
    lower_case_table_names 1
    max_allowed_packet 1048576
    max_binlog_cache_size 4294967295
    max_binlog_size 1073741824
    max_connections 100
    max_connect_errors 10
    max_delayed_threads 20
    max_heap_table_size 16777216
    max_join_size 4294967295
    max_sort_length 1024
    max_user_connections 0
    max_tmp_tables 32
    max_write_lock_count 4294967295
    myisam_max_extra_sort_file_size 256
    myisam_max_sort_file_size 2047
    myisam_recover_options 0
    myisam_sort_buffer_size 8388608
    net_buffer_length 16384
    net_read_timeout 30
    net_retry_count 10
    net_write_timeout 60
    open_files_limit 0
    pid_file C:\mysql\data\gtt-dc-01.pid
    port 3306
    protocol_version 10
    record_buffer 131072
    record_rnd_buffer 131072
    query_buffer_size 0
    safe_show_database OFF
    server_id 0
    slave_net_timeout 3600
    skip_locking ON
    skip_networking OFF
    skip_show_database OFF
    slow_launch_time 2
    socket MySQL
    sort_buffer 2097144
    sql_mode 0
    table_cache 64
    table_type MYISAM
    thread_cache_size 0
    thread_stack 65536
    transaction_isolation READ-COMMITTED
    timezone Pacific Daylight Time
    tmp_table_size 33554432
    tmpdir C:\WINDOWS\TEMP\
    version 3.23.46-max
    wait_timeout 28800

    Last Lines from Err File

    InnoDB: for table 
    InnoDB: Could not find key n 0 with name PRIMARY from dict cache
    MySql: ready for connections

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •