MySQL Lists: mysql: MySQL tuning

List:	General Discussion	« Previous Message Next Message »
From:	fa so	Date:	July 1 2009 7:10am
Subject:	MySQL tuning
View as plain text

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

Thread
• MySQL tuning	fa so	1 Jul 2009
• RE: MySQL tuning	Gavin Towey	1 Jul 2009