MySQL 5 64 Bit Edition serious problems

PauGasol

Verified User
Joined
Feb 3, 2004
Messages
125
CentOS 4.3

The mysql break sometimes and we need kill manually the pids (the service mysqld restart make nothing) . The log is :

"Version: '5.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
*** glibc detected *** free(): invalid pointer: 0x0000000001191c50 ***
mysqld got signal 6;
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=8388600
read_buffer_size=131072
max_used_connections=9
max_connections=100
threads_connected=7
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
"

I have try huge.cnf, large.cnf, not my.cnf , set 200 connections, 500 connecionts etc and nothing..

Any help?
 
Hello

Did you checked your customers websites? May be you have someone with a huge forum (typicaly) and he is stalling your mySQL from time to time.
 
Yes, was a client but with a small web. I moved the client to another box with MySQL 4 and problem solved. I dont understand what querys made that client but crash de mysql 5.

Thanks
 
Back
Top