Date: Thu, 17 May 2007 17:24:54 -0700 From: "Albert Wong" <ajwwong@gmail.com> To: <msaad@datapipe.com>, <freebsd-stable@freebsd.org> Subject: RE: mysql frequently crash on 6.2 Message-ID: <464cf251.017c7baf.440b.5f70@mx.google.com> In-Reply-To: <464CC70B.4090508@datapipe.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Mark: Thanks for the tips about the placement of the log into [mysqld] -- maybe it will start to show some error messages if I put it up into the mysqld section. :-) I will also take a look at table_cache and query_cache and read_rnd_buffer_size. [I've got some reading / figuring out to do!] Michael: And thanks also for the suggestion at looking into extensions.ini for the order of the modules. I'm not quite sure what do to there, but I'll definitely research this. Blessings, Albert > > One thing I normally turn off in MySQL is the query_cache . If your DB > is constantly receiving updates the query_cache is flushed to with each > update. This creates alot of useless overhead, in fact if set it very > high like to 1G or so you will see some nasty side effects of how MySQL > tries to flush the cache. > > As for you log you may want to move that in to the "[mysqld]" section of > the config. In this setup I beleive that mysqlhotcopy would be the only > mysql* command using that directive. > > table_cache should not be greater the amount of tables your databases > have . > > read_rnd_buffer_size = 524288 looks way to high your key_buffer_size is > only 32M Maybe you want to lower this to 64M of even leave it undefined > to see what the default does for you. > > > > PPS. Here's the my.cnf settings for this machine: > > > > [mysqld] > > safe-show-database > > skip-innodb > > max_connections = 500 > > key_buffer = 32M > > myisam_sort_buffer_size = 64M > > join_buffer_size = 1M > > read_buffer_size = 1M > > sort_buffer_size = 2M > > table_cache = 1800 > > thread_cache_size = 384 > > wait_timeout = 90 > > connect_timeout = 10 > > tmp_table_size = 64M > > max_heap_table_size = 64M > > max_allowed_packet = 16M > > max_connect_errors = 10 > > read_rnd_buffer_size = 524288 > > bulk_insert_buffer_size = 8M > > query_cache_limit = 3M > > query_cache_size = 80M > > query_cache_type = 1 > > query_prealloc_size = 163840 > > query_alloc_block_size = 32768 > > skip-name-resolve > > > > [mysqld_safe] > > open_files_limit = 8192 > > > > [mysqldump] > > quick > > max_allowed_packet = 16M > > > > [myisamchk] > > key_buffer = 16M > > sort_buffer = 16M > > read_buffer = 16M > > write_buffer = 16M > > > > [mysqlhotcopy] > > interactive-timeout > > > > log = /var/log/mysql/mysql_logfile > > > > > > > -- > Mark Saad > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?464cf251.017c7baf.440b.5f70>