|
Re: MYSQL trouble?
> Hmmm...looks like a problem with Apache::Session. Is your MySQL
process
> complete gone (from ps for example)?
no, its never actually dropped out completly. sometimes i can
refresh a billion times and it will come back to life, in a very
unstable state though (goes out to lunch frequently). once i restart
mysql though everything is wonderful.
heres my ps:
[root@205hotspot /]# ps auxw | grep mysql
root 3024 0.0 0.9 2428 1172 ? S Nov14
0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-
file=/var
mysql 3048 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3050 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3051 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3052 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3053 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3054 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3055 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3056 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3057 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3058 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3059 0.0 13.2 62704 16748 ? S Nov14
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3305 0.0 13.2 62704 16748 ? S 09:50
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
mysql 3306 0.0 13.2 62704 16748 ? S 09:50
0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --
user=mysq
root 3349 0.0 0.4 1760 584 pts/0 R 09:52 0:00 grep
mysql
[root@205hotspot /]#
there sure is a lot of them, i dont have much experience with mysql
other than what ive been playing with on this machine. we use
ibm:db2 at work so thats the sandbox i play in most.
thanks
josh
|