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

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

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