From: fa so (faka3oyahoo.com)
Date: Wed Jul 01 2009 - 00:10:41 CDT

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

Hi all,
I have a MySQL server with 1.7 GB of RAM, Some of the tables in my database use MyISAM and others use InnoDB

Do you think the following mysql configurations are Ok? or should I change something?

innodb_buffer_pool_size =712M
innodb_additional_mem_pool_size =20M
innodb_log_buffer_size =8M
Current tmp_table_size  = 32 M
key_buffer_size   = 712M
max_allowed_packet  = 16M
thread_stack            = 128K
thread_cache_size       = 128
myisam-recover          = BACKUP
max_connections        = 1000
query_cache_limit       = 1M
query_cache_size        = 64M
expire_logs_days        = 10
max_binlog_size         = 100M

thank you

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