[liphp] Big MySQL problem

[liphp@liphp.org]

I had a similar problem however it was due to poor query design.  Certain
queries would bog down my server big time. I had to re-evaluate the design
of my database, rebuild an index or two, and either rewrite certain
queries or eliminate them completely from my app.

You may have done this already, but just in case you havent make sure you
check over your tables to determine if any corruption has occured.

If you're using MyISAM or InnoDB use the CHECK TABLE command.
http://www.mysql.com/doc/en/CHECK_TABLE.html

Good luck!

-Rob

> Folks:
> I sent a similar message to NYPHP, but I thought one of you MySQL guys
> on the list could help me out.
>
> MySQL on my server is using 99% of the CPU, according to root.
> Anything that tries to access it, like my web page, mysqldump, or
> mysqladmin, waits forever.  I'm getting concerned here.  I rebooted
> the box last night, and it didn't change MySQL.  Worse, MySQL appears
> to not be creating any log files at all.
>
> Anyone have any hints how to proceed?
> -c
>
> --
> cmerlo@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.
> _______________________________________________
> Liphp mailing list
> Liphp@liphp.org
> https://www.liphp.org/mailman/listinfo/liphp
>