From: ÁõÎÀÌÎ (liuwt123gmail.com)
Date: Sun Jun 01 2008 - 21:58:30 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]