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:fak...@yahoo.com] Sent: Tuesday, June 30, 2009 10:11 PM To: mysql@lists.mysql.com 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
