mysql frequently crash on 6.2

[Albert Wong]

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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-stable
> To unsubscribe, send any mail to "freebsd-stable-unsubscribe at freebsd.org"