Web Analytics Made Easy -
StatCounter Weird MySQL performance issue.. - CodingForum

Announcement

Collapse
No announcement yet.

Weird MySQL performance issue..

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Weird MySQL performance issue..

    Hi, Im new, but im hoping someone can help.

    Im running mysql4.0.13 on FrreBSD 5.1-release. The problem is MySQL is using 95% of the cpu leaving 0% idle and pushing the load avg up to > 1. This is the output of mysqladmin processlist..

    $ mysqladmin -uroot -p processlist;
    Enter password:
    +--------+------+-----------+----+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+------+-----------+----+---------+------+-------+------------------+
    | 387980 | root | localhost | | Query | 0 | | show processlist |
    +--------+------+-----------+----+---------+------+-------+------------------+
    $ uptime
    8:51PM up 82 days, 5:18, 2 users, load averages: 1.03, 1.07, 1.23


    I normally would expect a slow query or a table that requires optimisation, but without any hints from the processlist, where can i start looking?

    Any help would be great!!

  • #2
    Welcome here !

    Check out http://www.mysql.com/newsletter/2004...000000301.html
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

    Comment

    Working...
    X