RE: MySQL tuning

[Gavin Towey]

That's impossible to say with the limited information you've provided; however, try this
script for some basic tuning suggestions.  It should make sure you're not doing anything
crazy:

https://launchpad.net/mysql-tuning-primer

Regards,
Gavin Towey

-----Original Message-----
From: fa so [mailto:faka3o@stripped]
Sent: Tuesday, June 30, 2009 10:11 PM
To: mysql@stripped
Subject: MySQL tuning

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





The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.