Operating System - HP-UX
1754014 Members
7172 Online
108811 Solutions
New Discussion

MySQL from HP Internet Express constantly restarting

 
Charles Soto
Advisor

MySQL from HP Internet Express constantly restarting

We get periodic restarts of mysqld when it is accessed via various PHP scripts. The 3.3.23 binary comes from HP's Internet Express, and Apache 2/PHP 4.3 is from HP Web Server. Both are the latest depots from HP Software Depot. This is the error I get:

/opt/iexpress/mysql/libexec/mysqld: ready for connections
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=16773120
record_buffer=131072
sort_buffer=524280
max_used_connections=8
max_connections=100
threads_connected=9
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

030729 09:12:45 mysqld restarted
/opt/iexpress/mysql/libexec/mysqld: ready for connections

-----

Watching the connections (mysqladmin proc) shows never more than a dozen concurrent connections. We're nowhere near any of the limits. I tried the various my.cnf configurations for small, medium and large servers (not huge, as it's sort of ridiculous in RAM usage).

I did not have this trouble using the binary from mysql.com. I was simply hoping to use a HP-maintained binary. Any ideas?

Thanks,
Charles