List:General Discussion« Previous MessageNext Message »
From:刘卫涛 Date:June 2 2008 2:58am
Subject:help me with my db
View as plain text  
hellow here,
i have a question about my db on version 5.0.41
it run well most of the time,but what i worry about is that it
shutdown in about 7 days(almost every 7 days) what record in system
logs is


080525  7:23:48  InnoDB: Started; log sequence number 0 43655
080525  7:23:50 [Note] D:\mysql\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt'  socket: ''  port: 3306  MySQL
Community Edition (GPL)

D:\mysql\bin\mysqld-nt: ready for connections.
Version: '5.0.41-community-nt'  socket: ''  port: 3306  MySQL
Community Edition (GPL)

here is my my.ini

default-character-set=latin1

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=400

query_cache_size=44M

table_cache=768

tmp_table_size=30M


thread_cache_size=38

#*** MyISAM Specific options

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=30M

key_buffer_size=129M

read_buffer_size=64K
read_rnd_buffer_size=256K

sort_buffer_size=256K


#*** INNODB Specific options ***


innodb_additional_mem_pool_size=6M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=3M

innodb_buffer_pool_size=250M

innodb_log_file_size=50M

innodb_thread_concurrency=18


the os is win32 server 2003 with 3.25G RAM,the other server software
run on this are apache,php(apache handle).

any help or suggestion is welcome! thanks in advance!
Thread
help me with my db刘卫涛2 Jun