Hi all,
We visited the Systems in Munchen and we get around the booth off allBSD.de and they recommended this form if we had questions.
So here I'm,
On one of our 10 TB Systems we have the following:
FBSD 6.0
MySQL 5.0.26 (also had 5.0.11).
When we run it we get the following error in the error log off mysql:
====
mysqld 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=8
read_buffer_size=28672
max_used_connections=819
max_connections=2048
threads_connected=665
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 122896 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
====
the my.cnf is following:
====
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 32
max_allowed_packet = 10M
table_cache = 512
sort_buffer_size = 32k
read_buffer_size = 32k
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache = 16
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
max_connections = 2K
====
so already shaped to fits into the memory of FBSD to 2GB.
but is keeps crashing.
The databases are then corrupted and we want to repair the databases with myiasmchk, but then the complete system halts and no access to the system anymore (keyboard or ssh).
Can someone give us a hint, or help us with the problem, (company's with skills are welcome).
I hope I explained it in a nutshell to understand the problem.
Kind regards,
Rene
We visited the Systems in Munchen and we get around the booth off allBSD.de and they recommended this form if we had questions.
So here I'm,

On one of our 10 TB Systems we have the following:
FBSD 6.0
MySQL 5.0.26 (also had 5.0.11).
When we run it we get the following error in the error log off mysql:
====
mysqld 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=8
read_buffer_size=28672
max_used_connections=819
max_connections=2048
threads_connected=665
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 122896 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
====
the my.cnf is following:
====
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 32
max_allowed_packet = 10M
table_cache = 512
sort_buffer_size = 32k
read_buffer_size = 32k
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache = 16
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
max_connections = 2K
====
so already shaped to fits into the memory of FBSD to 2GB.
but is keeps crashing.
The databases are then corrupted and we want to repair the databases with myiasmchk, but then the complete system halts and no access to the system anymore (keyboard or ssh).
Can someone give us a hint, or help us with the problem, (company's with skills are welcome).
I hope I explained it in a nutshell to understand the problem.
Kind regards,
Rene
