NYCPHP Meetup

[Hans Zaunere]

--- "Christopher R. Merlo" <cmerlo at turing.matcmp.ncc.edu> wrote:
> Folks:
> I'm not quite sure what to do about this one.  Hopefully you guys can
> help.
> 
> MySQL on my server is running at 99% CPU, as reported by top.

RedHat assuming, and installed via RPMs?

> Anything that tries to access it (my web site, mysqldump, mysqladmin)
> waits forever.  I rebooted the server, and MySQL is still eating up
> the CPU.  I only found one log file in /usr/local/mysql/var, and it's
> dated from 2002.  How can I figure out what's wrong, fix the problem,
> and or restart MySQL so that it will work properly?

If you've installed from RPM and/or source/binary packages from mysql.com you
might be running multiple instances.  I think that MySQL generally installs
to /usr/* from RPM and /usr/local/ from binary/source.  Look for a
/etc/init.d/mysql.server or similar file in /usr/local/etc.  Then, something
like mysql.server stop should shut it down, and using the appropiate my.cnf
(which should also be in /etc) you could disable certain aspects of it (like
disable the TCP listener) and turn on extensive logging, pointing to a know
location.

H



> 
> TIA,
> -Chris
> 
> -- 
> cmerlo at turing.matcmp.ncc.edu        http://turing.matcmp.ncc.edu/~cmerlo
> 
> We're sorry, but the number you have dialed is imaginary.  Please
> rotate your phone ninety degrees and try again.  Thank you.
> 
> 
> --- Unsubscribe at http://nyphp.org/list/ ---
> 
>