Date: Thu, 17 May 2007 17:20:11 -0400 From: Mark Saad <msaad@datapipe.com> To: <freebsd-stable@freebsd.org> Subject: Re: mysql frequently crash on 6.2 Message-ID: <464CC70B.4090508@datapipe.com>
index | next in thread | raw e-mail
Hello
In general This is what I use for my libmap.conf , it works fine
for me any you may want to give it a try.
[mysqld]
libpthread.so libthr.so
libpthread.so.2 libthr.so.2
Note nothing in MySQL 4.1 compiled on FreeBSD 6.2 should use libc_r.so .
The other thing in your libmap that looks odd is the line "libthr.so.2
libthr.so.2" not sure what that will do.
>
> In any event, my libmap.conf settings are now [located in
/etc/libmap.conf]:
>
>
> [mysqld]
> libc_r.so libthr.so
> libc_r.so.6 libthr.so.2
> libthr.so.2 libthr.so.2
> libpthread.so libthr.so
> libpthread.so.2 libthr.so.2
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
home |
help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?464CC70B.4090508>