mysql frequently crash on 6.2

[Mark Saad]

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