Franklin, Kevin writes:
> We are running an extremely large instance of mysql version 3.23.46 on
> Solaris 2.8. We are attempting to use a software version compiled 64 bit
> and have been experiencing memory related server crashes.
>
> The behavior suggests that we are still unable to use more than 4G of
> memory.
>
> If the server is started with the following settings:
>
> key_buffer=4608M
> max_allowed_packet=1M
> table_cache=1024
> record_buffer=1M
> sort_buffer=1M
> thread_cache=12
> thread_concurrency=12
> myisam_sort_buffer_size=512M
>
> We observe the following symptoms / problems:
> (1) A "mysqladmin variables" call shows that the key_buffer is set to be 1
> G, not 4.5G.
> (2) Under any sort of database load, the server crashes with the following
> error output:
>
> mysql got signal 10;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly built,
> or misconfigured. This error can also be caused by malfunctioning hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose the problem, but since we have already crashed, something is
> definitely wrong and this may fail.
>
> key_buffer_size=4831834112
> record_buffer=1044480
> sort_buffer=1048568
> max_used_connections=0
> max_connections=512
> threads_connected=1
> It is possible that mysqld could use up to
> key_buffer_size + (record_buffer + sort_buffer)*max_connections = 5765112 K
> bytes of memory
> Hope that's okay, if not, decrease some variables in the equation.
>
>
> If the server is started with more modest settings (e.g.,
> key_buffer_size=2G), mysql operates correctly. Additionally, "mysqladmin
> variables" shows a correct key_buffer value.
>
> System memory is not a constraint ( 6 G real memory and 14.5 G swap).
Hi!
This is a problem that we would like to take a look at !!
Please provide us with details on how have you built MySQL. For the
start ...
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
