Search the web
Sign In
New User? Sign Up
tvdinner
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
MYSQL trouble?   Message List  
Reply | Forward Message #98 of 121 |
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






Wed Nov 17, 2004 2:56 pm

valmasj
Offline Offline
Send Email Send Email

Forward
Message #98 of 121 |
Expand Messages Author Sort by Date

for some reason, if i let tvdinner sit around ahwhile, when i finaly go to connect to it i get the following error: error: DBD::mysql::st execute failed:...
Pablo Martinez
valmasj
Offline Send Email
Nov 14, 2004
2:08 am

... Hmmm...looks like a problem with Apache::Session. Is your MySQL process complete gone (from ps for example)? I'll see what I can dig up. Sean -- \___/...
Sean Keplinger
keane_skeplin
Offline Send Email
Nov 16, 2004
4:44 pm

... process ... 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...
Pablo Martinez
valmasj
Offline Send Email
Nov 17, 2004
2:56 pm

... I use MySQL for all of my websites (at least Apache::Session) so I think my database never sleeps. The only different thing I do to start is set the max...
Sean Keplinger
keane_skeplin
Offline Send Email
Nov 23, 2004
4:32 pm

not sure if it changes the scenario any, but i previously said that restarting mysql did the trick. which is true under the old version, restarting apache is...
Pablo Martinez
valmasj
Offline Send Email
Dec 6, 2004
4:24 am

... That points pretty much to Apache::Session::MySQL. I've noticed while coding and debugging that when a page crashes with a Mason error, I have to clear the...
Sean Keplinger
keane_skeplin
Offline Send Email
Dec 10, 2004
6:52 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help