this is my first time to install mysql, mod_perl on solaris, mysql and mod_perl are re-compiled with apache, has only a forum program running and it works just fine ... only a few hours, then mysql crashed, it said:

MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ...

this shouldn't be the bug from forum program because it doesn't occur on redhat and nt.

anybody has expericnce on solaris, mod_perl, mysql??

i need help. TIA.

This happened just once or keeps happening?........how often does it happen?

it keeps happening, i need to restart mysql every 3-4 hours:(

You may wish to read:

http://www.mysql.com/...nnect_to_server.html

that doesn't help ...

error log said: solaris signal 10 bus error.

error log:

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 agaist 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
record_buffer=131072
sort_buffer=2097144
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
011007 15:34:48 mysqld ended

Hi,

You may want to check you got the right MySQL for solaris (or did you compile from source)? Try running the mysql benchmark test and make sure it completes ok.

Cheers,

Alex
--
Gossamer Threads Inc.

I did do these, compiled mysql from source and all benchmarks passed...but problems are still there.:( I have to give up Solaris and reinstalled Linux, so far so good...

thanks for ur help anyway.

Hi,

You may want to use a binary from mysql, I've used them for solaris and it works quite well.

Cheers,

Alex
--
Gossamer Threads Inc.