Help with FreeBSD and Mysql heavy load

RvS

New Member
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
 
What about kern.maxdsize?
If i remember correctly, it is set to a maximum of 512MB. So maybe increase this sysctl via /boot/loader.conf.
 
Hello!

I think you really need professional help. MySQL AB is a company and i think, they know their product really well.

You could also seek help in the Usenet: news:de.comp.datenbanken.mysql (you can ask questions in english there too) or news:comp.databases.mysql

BTW: FreeBSD 6.1 is the current stable release, 6.2 is in preparation. Maybe it helps to update to FreeBSD 6.1-p10?

Ciao.
Markus Mann
];-)
 
kern.maxdsiz="2095882240" # 2GB
kern.dfldsiz="2095882240" # 2GB
kern.maxssiz="134217728" # 128MB
 
Rene, just for my curiosity: What application requires 10 TB of db-stored data?

Regards and good luck with solving your problem (did you check with bsdforums.org?),
ww
 
ww,

we are devoloping backup over ip solutions, and we are using mysql as meta data database.

Thats why we where/are on systems 2006 in munchen.

Rene
 
Back
Top