Jon Miller wrote:
This is the configuration file in use.
/etc/my.cnf
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306
[mysql.server] user=root basedir=/var/lib
[safe_mysqld]
err-log = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
log_slow_queries = /var/log/slow-queries.log
long_query_time=2
max_allowed_packet = 384M
table cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache = 32M
thread_concurrency = 16
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
Right.
Firstly, don't top-post. It's annoying.
Secondly, don't just post directly to people on the list. Post all stuff to the LIST. That way other people who have the same problem as you don't have to ask the same question.
Your max_allowed_packet size is HUGE. Why is that big? Maybe that should be the key_buffer instead of the max_allowed_packet?
Have a look at the example config files ( in support-files in the source distribution ).
Have a look at the page I linked to in my last post, and also: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
They both talk about exactly what you want to do: tune the performance of your server.
You also didn't include any details of the tables or queries you're running. I see you have a slow queries log, in
/var/log/slow-queries.log. That would be a good one to look at too.
Dan
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
