MySQL crashing (signal 11), CentOS 4 64-bit/Opteron, I need help...
Hi,before one month I buy one server from LiquidWeb and that is:
Dual Opteron 246
2GB RAM
2 x SATA RAID 1 120GB
1 x SATA 120GB for backup
CentOS 4.2 64 - bit
cPanel
and from start I have problem with MySQL because crashing every few minutes if I have high MySQL usage (that is not too high because now I moved my biggest DB to P4 2.8 with 1GB and load is 0.2 maximum, most time 0.02 and working fine) but now I moved one of my DB`s to other server and now I have only 2 sites who using MySQL DB`s and that is not big usage but still MySQL crashing (not every minutes) but I think that crashing on night when cPanel creating backup for this few sites (3-4) who I have on this server and updating cPanel and that is because load in that time on server can be over 2 but not over 5!!
But if that true this OPTERON can`t work on LOAD 2??? I using some celerons and P4 servers on load 20 and all working without crashing, slow but not crashing!
In error log only what I can see is too much lines of this error:
Number of processes running now: 0
060217 02:22:30 mysqld restarted
/usr/sbin/mysqld: ready for connections.
Version: '4.0.25-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Off
icial MySQL RPM
mysqld got signal 11;
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=0
max_connections=900
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 196658
4 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Number of processes running now: 0
060217 02:22:30 mysqld restarted
/usr/sbin/mysqld: ready for connections.
Version: '4.0.25-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Off
icial MySQL RPM
Is this problem with 64- bit OS/MySQL or...??
I contacted LiquidWeb few times but they don`t know how fix this and they don`t have solution for this, I thinking to move server from them because this opteron working very very bad and I don`t know why!!!
Whole day load on this server is under 1, most time 0.2-0.5!
I hope so that somebody know how I can fix this problem...
SORRY IF MY ENGLISH TOO BAD!
Thanks.